code no longer works

[sferris]

Hi. My web host recently upgrading my account and now one of my php scripts no longer works (It is now PHP 4.3.10). It is for a shopping cart program. The items are divided into brochures and categories. I need to pull information from the mysql db based on the brochure and category. Here is the line that seems to be giving me trouble:

$newsql = "SELECT * FROM item WHERE cat = '$ctg' AND BrochID = '$BrochID'";

$newres = mysql_query($newsql,$db);
$num = mysql_num_rows($newres);

I know that the correct variables are being passed as I am echoing them to the screen to debug. $num is coming back as 0.

I am able to pull the cat column from the database with the following code earlier in the script:

$ct = "SELECT DISTINCT cat FROM item WHERE BrochID = '$BrochID'";

$result = mysql_query($ct, $db);
$num = mysql_num_rows($result);

Any suggestions would be greatly appreciated.

[bradgrafelman]

Do you have a GUI, such as phpMyAdmin? Or even the MySQL CLI? Try doing this:

echo "SELECT * FROM item WHERE cat = '$ctg' AND BrochID = '$BrochID'";

and pasting the echo'd query into your GUI/CLI. Does it return any rows?

Also, perhaps there's an error occuring. Try using some debugging tactics, like so:

$newres = mysql_query($newsql,$db) or die(mysql_error());