Posted by Marcin Dobrucki on 06/02/06 12:44

Peschtra wrote:

> 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?

You know, you could make a bit of an effort:
http://www.php.net/manual/en/function.error-reporting.php

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

http://dev.mysql.com/doc/refman/5.1/en/custom-engine-transactions.html

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

http://www.php.net/manual/en/function.mysql-query.php

All you need to do is copy&paste the example to get the mysql error
out of your query (if such error occured)

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

No, then probably you can't unless you can arrange it with the
privider. You can however print the queries onto the screen, then copy
them onto a locally installed db, and see what it complains about.

/m

[Back to original message]