Tuesday, 12 October 2010 19:59

random mysql row

Written by  mark
Rate this item
(0 votes)
<?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()";
?>


 
mark

mark

E-mail: This e-mail address is being protected from spambots. You need JavaScript enabled to view it
Login to post comments