101548 Help with SQL
N/A
Dibayar semasa penghantaran
The following has been tested in my phpmyadmin and works fine, however when I run the same query from my site I get the following error:-
SQL: SELECT * , SUM (rating_value) AS ave FROM rating_values, rating, products WHERE products.available='1' and rating_values.rating_value_id=rating.rating_value_id AND products.prod_id = rating.p_id AND products.prod_name LIKE '%b%' GROUP BY prod_id ORDER BY ave DESC
Error Message:-
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/1506/justine/[url removed, login to view] on line 106
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/1506/justine/[url removed, login to view] on line 107
Im sure the solution is probably obvious for someone who knows SQL better than me.
ID Projek: #1847715