Stricter Error Checking?
| From: | Tim Legg | Date: | Wed, 23 Sep 2009 18:11:46 +0000 |
| Subject: | Stricter Error Checking? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-298293@lists.php.net to get a copy of this message | ||
Hello,
I just spent way, way to much time trying to debug code due to a misnamed element. Here is a
simplified example of the problem I dealt with.
$test = "SELECT * FROM
Materials WHERE Part_Number =
'125664'";
$result = mysql_query($test,$handle);
if(!$result)
{
die('Error: ' . mysql_error());
}
$row = mysql_fetch_array($result);
echo $row['Number'];
After retyping the code 3 or 4 times over the course of the morning, I finally found where the
problem was. The problem is that the database field is called 'Part_Number', not
'Number'. The field 'Number' does not exist in the database. I am very
surprised that I didn't even get a warning that there might be a problem with the statement.
All I saw is that nothing was being returned via the echo command.
There really must be a stricter error checking that is turned on somewhere, isn't there?
Thanks for your help.
Tim