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