|
|
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
Navigation:
[Reply to this message]
|