MySQL: Logging SQL Statements for Debugging PHP Apps

[rdx]

Goal: I seek to log the SQL statements into a MySQL table, with the time they were executed as an aid to debugging problems with PHP apps I am writing.

Problem: MySQL seems to try to interpret the statement, meant to simply be data in a field. When I try to "INSERT" the values, I get MySQL syntax errors.

Solution: Does anyone have a way around this problem?

 

[verty]

Do your inserts have apostrophes? You'll need to double them (replace ' with '').

 

[rdx]

Do your inserts have apostrophes? You'll need to double them (replace ' with '').

Hmmm, I see what you mean.. I will look into it. Thanks.