Tuesday, 12 October 2010 19:59

random mysql row

<?php
  //  random row mysql query example
  $sql = "SELECT * FROM tablename
          WHERE somefield='something'
          ORDER BY RAND() LIMIT 5";

  //  or, something like this
  $sql = "SELECT * FROM tablename
          ORDER BY RAND()";
?>


 
Published in Administrative