title: Mysql table hanging - Unable to save result set in /home/my_site/public_html/my_file.php on line 149
body: <p>I am getting the following error when trying to run a script from my site:</p>
  
  <p>Warning: mysql_query() [function.mysql-query]: Unable to save result set in /home/my_site/public_html/my_file.php on line 149</p>
  
  <pre><code>$run_sql = mysql_query("SELECT count(*) from tix_orders where order_id='$uniq_transaction_id'",$conn)
  </code></pre>
  
  <p>I have tried analyzing and doing and extended repair on the table but still the problem persists.  </p>