mysql_query

[vision1]

I have created a table with 61 fields. The table has 45 tinyint fields ( 1 ). Using the following PHP function, mysql_query("INSERT INTO table ("'$field1','$field2',...,'$field61'") - I cannot load data to the table. When using other tables with smaller number of fields, the data loads with no problem.

Question - Is there a limit to the number of fields.
Question - Do I need to add a hard return somewhere in the string of 61 $fieldX to ensure the line is completely read.
Question - Should i be using some other type of form.

Any advice in advance, great appreciated!

Jerry
mailto: [e-mail]

[[deleted]]

1: yes, and it's waaaaay beyond what any sane person would ever need (>32k)
2: a hard return terminates a line, so how do you figure it would help?🙂
3: form?

A few pointers:
-tinyint is bad, use INT instead (unless you can somehow prove you'll never need to store values larger than 255).
- numbers are never quoted, especially not integers.
- If a query doesn't do what you think it should, the PRINT it before you execute it.

• If a mysql query fails, you can find out why by using error checking:

if (!mysql_query($sQuery))
{
echo mysql_error();
}
else
{
echo 'query ok';
}