Feedback from MySQL

Hi..
How can I receive feedback from MySQL when my PHP encounters a problem?

When you are working with PHP and MySQL and encounter an error, it is helpful to receive more detailed information regarding the problem.

You can use the mysql_error ( ) to get feedback from MySQL to your PHP document if you are encountering problems.

It is phrased as: mysql_error ( [link_identifier] ).

Hope this help you.

Thanks for the help.. but it would be very helpful if you can explain me how to utilize mysql_error()?

The following Example might help you in understanding mysql_error():

mysql_connect("your.hostaddress.com", "username", "password") or die(mysql_error())

This will return an error if there is a problem connecting to your MySQL database

$value = mysql_query($your_query) or die("A MySQL error has occurred.<br />
Your Query: " . $your_query . "<br />
Error: (" . mysql_errno() . ") " . mysql_error())

When you encounter an error, this will return your custom message (A MySQL error has occurred.<br />) followed by a line number, and the actual error.