php/mysql sql error message repressed?

searain

If I wrote a sql statement with errors, if the database is InterBase/FireBird, php pages will show the error message and tells me what is the possible error.

But when I use php/mysql, if I wrote the sql statements with errors, php is not showing me the error message. Just sit there very quietly.

It might be the security reason to repress the mysql error messages in php programmng.

But how to turn the error message on (I need it just in my developing process)?

Thanks!

cafrow

$sql = mysql_query("SELECT * FROM example");
if ($row = mysql_fetch_array($sql)) {
  echo 'No Problems';
}
else {
 echo mysql_error();
}

The mysql_error() is your new friend.

searain

if I set mysql.trace_mode to be on in php.ini, will that work too, automatically display the sql error message?

can I set up mysql.trace_mode on for certain sites and leave the other sites as mysql.trace_mode off? If i can, how? through apache configuration file or through .htaccess?

Thanks!

liquorvicar

PHP docs say mysql.trace is configurable in INI-ALL so yes, via .htaccess would work (i'd have the default off and then use the .htaccess for test sites as required). or you can also set it per site in httpd.conf.