Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource
I am testing my website on a remote server. We have data-assist connected to a database for ecommerce products. I am able to use the insert pages to insert products to the database, however our results page does not display the inserted products. On our local server everything works fine, we are able to see the products. Remotely, there are no results. Below is the error message I receive when on the product_results page.
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/content/.......(path obscured)........products_Results.php on line 108
*I didn't include the full path above for security reasons.
The code on line 108 is:
$totalRows_WADAproducts = mysql_num_rows($all_WADAproducts);
Anyone know what is wrong?