debugging tips?

[Anon]

I am new to PHP. I'm creating this form for a customer, it stores data from a form in a database (MySQL). There are over 100 pieces of info on the form. It appears to work when the form is submitted, but I no record in the database.

Is there somewhere I can look, such as an error file or something to see what's happening? I've been battling this problem for over a week now!

Thanks! Bill Blue

[Anon]

I suggest, printing out the actualy SQL function you use to insert the data in to the database to yourself, then put it directly in to the MySQL database via the "mysql" command editor. If the sql command works, you know it's your mysql_db_query or mysql_query not functioning correclty, if it doesn't, you now you've got some problems w/ your subbmission and creation of sql.

Have at =)

[Anon]

A thing that is very usefull when writng in/retreaving info from a SQL-database is: write the sql-statement( $sql="SELECT *...), and then run it(mysql_result($sql)) THEN:

Write out $sql-variable to screen, and see if you can see any obveous mistakes, you can also copy the sql-statement outputted in the browser, and run it directly in MySQL, there you get better error-reporting, unless you use the php-mysql-error-functions.

This is something I always do when I am developting PHP/MySQL-scripts...

Good luck!

[Anon]

DID NOT SEE Chuck G's answer to this one, sorry!

[Anon]

Hahah, ya np bud =). You only wasted your own time, not mine =P