MySQL error on shopping_cart.php

[vashichino7]

Hello All,

 

When you click on an item to be put in the checkout cart, and you are redirected to the shopping_cart.php page; I get an error on the bottom stating this:

 

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/savingsh/public_html/includes/functions/database.php on line 99

 

when I open my database.php on line 99 here is what it states:

function tep_db_fetch_array($db_query) {

(THIS IS LINE 99) return mysql_fetch_array($db_query, MYSQL_ASSOC);

}

 

Any help? Thank you guys!

[vashichino7]

So I read that placing an @ infront of the line 99 mysql_fetch_array($db_query, MYSQL_ASSOC); and making it @mysql_fetch_array($db_query, MYSQL_ASSOC);

 

it will fix the problem!

[MrPhil]

No, it will not "fix" anything. It just suppresses the error message. There was something wrong upstream of this function call, that was producing a bad query result.

[satish]

you need to use debug back trace and make out which function called this mysql_fetch_array function.

 

then check why those two variables are not as they are to be.

 

satish