Could you do something like this instead? This is using named placeholders
and a separate line for your statement
but I was able to get it to echo the statement in this manner. 

$sql = "UPDATE table SET field1=:field1, field2=:field2 WHERE id=:id";
                $sth = $dbh->prepare($sql);
                                           ": field2"=>$ field2,
                                           ": id"=>$id));

echo $sql; 

Hope that helps,

-----Original Message-----
From: Peet Grobler [] 
Sent: Wednesday, August 31, 2011 4:24 AM
Subject: [PHP] mysqli sql question

Is it possible to get the actual sql that is being used to query or
update the database?

$sth = $dbh->prepare ("update table set field=?, field2=? where id=?);
mysqli_bind_param ($sth, 'ssi', 'text1', 'text2', 10);

Something like $sth->sql? Or $dbh->sql?

I want to see "update table set field='text1', field2='text2' where id=10;

Thanks in advance,

PHP General Mailing List (
To unsubscribe, visit:

PHP General Mailing List (
To unsubscribe, visit:

Reply via email to