Mark Hensler — Fri, 29 Aug 2003 07:20:40 +0000

"When in doubt, print it out."

I think often times there is nothing wrong with the logic where the error occurs. But rather, the data we are manipulating is not what we expected it to be at that point.

Suzanne — Fri, 29 Aug 2003 06:42:12 +0000

I think I've said this before, but instead of forcing someone else to go through my code line by line, I use:

<?php
if (!$qry) { 
    echo mysql_error(); 
    exit;
    } 
?>

Perhaps there is a better way to check line by line, but that's often all I need after a particular query to find MY ERROR and fix it.

zollet — Fri, 29 Aug 2003 05:56:14 +0000

Before the mysql_num_rows() line, type: echo mysql_error();
If there are any problems, that line will print it on the screen.

Mark Hensler — Fri, 29 Aug 2003 01:49:06 +0000

Try testing it against FALSE. If the query failed, for whatever reason, mysql_query() will return false.