A tutorial which tells you a method for debugging easily when you are experiencing MySQL query errors.
Find more tutorials at http://bullzeyeproduction.net
This is a helpful little mysql tutorial that would help you find out what is wrong in your mysql coding.
It is very simple, just use this little thing:
mysql_error()
It's very simple, use it on something like this:
$linkid = mysql_connect("localhost", "username", "password");
mysql_select_db("name of db");
$aquery = mysql_query("SELECT * FROM tblname WHERE column='whatever'") or print mysql_error();
?>
And that's it, notice I used it on the query only:
$aquery = mysql_query("SELECT * FROM tblname WHERE column='whatever'") or print mysql_error();
You can use it on anything that involves mysql.
Well, that's it, this is rpgsmo...out!