title: Select random row in SQL where Status = 0 using php
body: <p>I wonder... is this possible to select a random row in my DB where only the record that contains <code>field-&gt;Status = 0</code> ? because i only need a row that contains 0 in the field <code>name=Status</code>. if the status <code>contains = 1</code> , then the row will not belong in the randomization.</p>
  
  <p>my code in the query is</p>
  
  <pre><code>$result = mysql_query( " SELECT * FROM `$haha` ORDER BY RAND() limit 1");&lt;br&gt;
  $result = mysql_query( " SELECT * FROM `$haha` ORDER BY RAND() limit 1 Where Status=0");
  </code></pre>
  
  <p>But it does not work.. i appreciate your replies.. thank you very much!</p>