random query

[nellyihu]

hi,
pls how can i achieve this senerio: i want a new set a data (records) to be displayed to the client each time he accesses the site instead of static data.
in order words i want a different set of records to be displayed each time the site is accessed or the query should be randomized.
A typical senerio could be an online book store that displays differents books up for sale instead of just static data
pls i need this in real good time thanks

[r937]

which database system?

also, have you searched this forum?
http://www.sitepoint.com/forums/showthread.php?t=286692
http://www.sitepoint.com/forums/showthread.php?t=271369

[nellyihu]

mssql

[r937]

select top 1 foo from yourtable order by newid()

[nellyihu]

thanks man this really works i appreciate