[SOLVED] printing the query within a mysqli_stmt?

I'm using prepared mysqli_stmt variables in an object-oriented fashion to communicate with my MySQL server. Something's not quite right with the SQL statement I prepared, and I want to print out the query to see what's wrong with it, but I can't find a way to print out the query held within a mysqli_stmt object. I'm used to doing things the old fashioned way where you just define a query in a (easily printable) string and pass that to mysql_query().

How do I print the query held inside a mysqli_stmt?

You should post the code, it might help get an answer.

Sure:

$conn = new mysqli("********","****","*****","*****");

....

$statement = $conn->prepare("INSERT INTO foo VALUES(?,?,INET_ATON(?),NOW())");
$statement->bind_param('sss', $string1, $string2, $_SERVER['REMOTE_ADDR']);
$statement->execute();
$statement->close();

My query is executing, but not doing exactly what I want. I would like to see the raw text of the SQL query. I've tried print_r($statement) and var_dump($statement), but they don't give me the info I need.

bump

You can't.

best thing to do is put it in a string (ie. $query = "INSERT INTO foo VALUES('$whatever', '$something'.....)

and echo $query.

I find that very surprising.

Oh well, thanks play_ for the response.

No prob.

If the query throws an error, you can see it by

$sql->errorInfo()

http://php.mirror.facebook.net/manual/en/pdostatement.errorinfo.php

No prob.

If the query throws an error, you can see it by

$sql->errorInfo()

http://php.mirror.facebook.net/manual/en/pdostatement.errorinfo.php

Here's some more useful info

http://stackoverflow.com/questions/210564/pdo-prepared-statements