I know I have posted a simalar message but now I'm getting to the root of the matter. I want one random display of info from $table. $query="SELECT * FROM $tablename ORDER BY rowid RAND() LIMIT 1"; Every time I get back error message: "stmterror:1064 You have an error in your SQL syntax near 'RAND()' at line 1" Anyone have any input on this? MySQL is up to date and so is PHP. RAND() does not work. Thanks MattD
you forgot the comman between rowid and rand().
But it won't work anyway, because there is only one rand() value per rowid value, so it will order by the rowid every time. Either order by the rand() or order by the rowid.
