php not inserting into database (?)

Anon

I have several forms on different pages that are all supposed to enter data into only a few fields of a big table (like 6 out of 40) each. Near as I can tell, my php code is correct (using update query) to enter the data into a record based on the user name (as in Update Tablename bla bla where username='$username'). But I'm having trouble pre-creating the usernames in the table using phpmyadmin. I have all the fields listed as type TEXT, or should they be CHAR or VARCHAR or something else?

Thanks again,

Jeof Oyster

Anon

The best way to debug sql is to just insert a print statement of your sql query and manually submit it... in most cases it will tell you right where the error is. Common problems are using illegal characters in text strings.. the addslashes fuction is useful in fixing that problem..

Anon

Very true,
but what makes it even eaier is to use the mysql error reporting.
That will tell you exactly at what point mysql found a problem.

For example:

if (!($result=mysql_query($sql_statement,$db_connection)))
{

Query failed, report error

print mysql_errno().": ".mysql_error()."\n";
}
else
{

Query ok, process output

};