Jump to content

I forget, how do I echo SQL statement to see how's being "constructed"...


mac007

Recommended Posts

Hello, all...

 

I seem to remember, like if I have a problem with a mysql_query() statement, and want find out why it keeps giving me an error, I'm often told to echo out the statement for debugging purposes. Can somebody remind me again how that's done...

 

thanks!

do you mean something like this?

 

$result = mysql_query("SELECT * FROM table WHERE value='value'");

if (!$result) {
    die('Could not connect: ' . mysql_error());
}

turn on error reporting in php.ini

 

or do you mean stuff like SHOW, DESCRIBE, EXPLAIN in the query itself

 

 

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.