title: how to use ORDER BY RAND() with where condition
body: <p>i want to display my products using ORDER BY RAND() with where condition</p>
  
  <p><strong>This is my query</strong></p>
  
  <pre><code>$qry="select * from product_tbls where category_tbls_id=".$data["0"]["product_tbls"]["category_tbls_id"];
  </code></pre>
  
  <p>i know this normal working query without where condition</p>
  
  <pre><code>$qry="select * from product_tbls ORDER BY RAND() LIMIT 0,6;";
  </code></pre>
  
  <p>but i want to use where condition</p>
  
  <p>Thanx in advance.</p>