NewbieNotes is a little series of tips for people who are new to PHP to give them a few handy tips that the more experienced of us use often
Never assume that just because a SQL query looks simple it works!
Always store your query in a variable before you use it, this way you can see what happenned if things go wrong
Do something like this ...
<?php
.
.
$sql = "select * from users";
if($res = mysql_query($sql, $link))
{
// code to do stuff
}
else
echo mysql_error()."<br>\n$sql<br>\n";
?>
In the event of you supplying a bad query the else clause above will kick into life and you'll get to see what My#SQL didn't like and the query MySQL didn't like
It usually only takes a few seconds to see where you went wrong - not enough quotes, too many quotes etc being the most common.
