Gw Temp

Menu

Tutorial - 'Sql Errors' by rpgsmo

An item about Programming Languages posted on

Blurb

A tutorial which tells you a method for debugging easily when you are experiencing MySQL query errors.

Body

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!