Posted by Peschtra on 06/01/06 00:20

Marcin --

Thanks for the reply. However, I don't know how to do most of what you
suggest. After I send this I am going to library to hopefully find a
book as I find most of the website confusing.

How does one enable error reporting?

I don't know understand what your statement about transactions or
committing by hand means. :(

I think I capture the mysql query with $res = mysql_query (INSERT, but I
don't know how to analyze it.

If I don't have the DB on my computer (it is on my hosts computer) can I
still enable logging?

Sorry for the questions but greatful for any help from anyone.

Peter Kupfer

Marcin Dobrucki wrote:
>
> 1) check that error reporting is enabled
> 2) check you don't have transactions on (you will need to commit by hand)
> 3) mysql_query can return a result. Capure it and analyse it
> 4) enable logging on the DB, and see what it gets. This often gives a
> clue where the query breaks
>
> And as much as PEAR::DB can kill performance, a query like that is
> just begging to be automated via some kind of statement preparation. You
> should also pay attention to escaping quotes and such, in your fields.
>
> /marcin

[Back to original message]