Random Row

[Luis E Valencia]

How can I select a random row from a database? and show it?

 

[Curt_C [MVP]]

Count the rows, generate a random # from 1 to X
Get row x.
Mind you you really should get the unique ID's, put them into an array/list,
generate the random from there.

 

[Raterus]

if you are using sql server

select top 1 * from mytable
order by newid()

I think you should be able to find plenty of articles on how to display data from a database.