php mysql help!

[kororo]

hey guys!

how do you randomly select unique records from database?
pls include php code example.

thanks in advance..

Kororo🙂

[LarsLai]

hi!
with RAND() you can achieve this from a mysql db. try:

<?PHP
  $query = "SELECT yourfield FROM yourtable ORDER BY RAND() LIMIT 1";
  ...
?>