Hello, Shoulder.

You wrote 18 сентября 2002 г., 5:20:55:

Do you mean random row?

So, try this

   $query = "SELECT * FROM table ORDER BY RAND() LIMIT 1";
   $result = mysql_query($query);


StSF> Hi all,
StSF> How can I select one random column from a MySQL table?
StSF> Thanks, Taj

www.pskov.ru                    webmaster|programmer|DBA
Best Regards,
Andrey                          mailto:[EMAIL PROTECTED]

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to