Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in line 2 : <pre><code>$query2 = mysql_query("SELECT *from order where reservation_id = '$reservation_id' "); //query for getting the order_id

$row = mysql_fetch_assoc($query2); //this is the line that warns

echo $row['order_id']; // the value of order id
</code></pre>

<p>// anyone knows how to solve this? i keep getting warning on mysql_fetch_assoc()</p>
