php random select information from a database

unwashed potato! · 22 May 2007 at 23:42

i got a database which has id, author, post

How would i get it so php randomly selects the id number and then displays the author and post for it at every load up?

thanks

Clarkey · 22 May 2007 at 23:51

something very loosely along the lines of

SELECT MAX(id) FROM table

$fields = mysql_result($sql, 0);

$randid = rand(0,$fields);

SELECT * FROM table WHERE id = $randid

Moredhel · 23 May 2007 at 00:03

SELECT fields FROM table ORDER BY RAND() LIMIT x;

where x is the number of random entries you want.

unwashed potato! · 23 May 2007 at 01:29

[edit] ok got it working.

reason it wasn't working was because i was including another file before that so some reason didn't allow this. anyone know why as i need to include the other file for the login on another page which will also have the code just added.

Thanks

unwashed potato! · 24 May 2007 at 10:14

removed because no one answering