SHOW SQL

[jgeddes]

Is it possible to SHOW the SQL statement on the web page for troubleshooting?

I use a package on the IBM AS/400 that allows me to see the select statement so I can debug.

Can PHP do something like that?

Thanks

John

 

[inlandpac]

You can assign your SQL to a variable.

$q = "SELECT COUNT(DISTINCT(zip_code)) FROM my_table";

echo $q;

if($debug) {
echo $q;
}

$r = @mysql_query($q) or die(mysql_error());

Chad ICQ: 54380631

 

[jgeddes]

Thanks Chad!


That worked great.


John