Is there a way to see a prepared query as it will be executed on the database? [duplicate]

Question

Possible Duplicate:
PDO Prepared Statements

I'm using the mysqli extension in PHP and I'm wondering, is there possibly any way to see a prepared query as it will be executed on the server, e.g. The query is something like this

select * from table1 where id = ? and name = ?

but I want to see the query after the values are filled in, like this:

select * from table1 where id = 20 and name = "John"

Answer 1

Turn on mysql query logging and it will log all queries to a text file for you to review.