MySQL result resource

[jamesloi]

Does anyone know what this error means?

Warning: Supplied argument is not a valid MySQL result resource in /home/lj917/public_html/cart.php on line 155

this line is causing the problem

while($row = mysql_fetch_array($result)) {

$totalCost += ($row["qty"] * $row["Price"]);

does anyone know what this means?? }😕

[nnichols]

A "result resource" is what is returned by the mysql_query() function. So it is the "$result" that you use in your "while($row = mysql_fetch_array($result))". The problem lies in the execution of your query.

This problem will occur if the query was an insert, update or delete query, as these return true or false not a result set.

If this is not the case post your full code so we can have a look.

Hope this helps 😉

[ahundiak]

It almost always means that your query syntax is incorrect.

$result = mysql_query('Select this from that');
if (mysql_errno()) die(mysql_error());

The mysql_error message will usually give you a clue as to where the problem is. Whenever a query actually fails, $result will be NULL which in turn causes mysql_fetch_array to complain.

[jamesloi]

Thanks dudes,

it was a query thats was messing me up.:p