mySQL Insert Into

Anon

I am having an unusual problem using the insert into statement.
If I can fit all of my variables on one line then it will add the record to my database but if i have more variables then i can fit on one line and i have to go to the second line it will not update
Example

$sql = "INSERT INTO test_table (test,test2) VALUES ('$test','$test2')";
All this on one line will work but if i do this
$sql = "INSERT INTO test_table (test,test2)
VALUES ('$test','$test2')";
on 2 lines will not work. This is just an example in reality i think i have maybe around 25 to 30 columns that I insert
Can anyone help me with this?

Anon

hi, chris
try this, i hope it works
$sql = "INSERT INTO test_table (test,test2)".
"VALUES ('$test','$test2')";
the example above is just adopted from yours.

AlphaCent Indonesia Technologies

Anon

hai Chris Fletcher,
I have read your problem about inserting the data using two lines.But I think there is absolutely no problem in doing so if you are using latest version of mysql.I can't say about older ones.

Bye,

Chris Fletcher wrote:

Anon

Try this:

$sql = "INSERT INTO test_table (test,test2) ";
$sql .= "VALUES ('$test','$test2')";

the '.' is the concat operator...