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

[mac007]

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!

[kenrbnsn]

Let's see your code.

 

Ken

[QuickOldCar]

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

 

 

[trq]

sql statements are simply php strings.

 

$sql = "SELECT * FROM foo";

 

You can print a string....

 

echo $sql;