var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Cant INSERT more than 2 fields at once
I have a strange problem inserting data to my database.
The script below works perfectly
printf ("Name =%s<br>",$name);
printf ("Style =%s<br>",$style);
$sql = "INSERT INTO xxx (name,style) VALUES ('$name','$style')";
As soon as I change the query line to the following nothing works !!
$sql = "INSERT INTO xxx (name,style,address) VALUES ('$name','$style','$address')";
$Address does contain valid data, I have tested that by printing it at the start of the script.
This is even the exact SQL script which MySQL Admin generates when I do it manually and that DOES work.
It seems to be limiting me to inserting only two fields at a time, if I submit $name & $address it works, add $style to the query and nothing again !!
Can anyone please help !!
This is driving me nuts !
Do you get an error message or do the fields not get updated when you try using three of them? From your code I see no reason that it shouldn't work.
No error message at all.
The database just doesnt update.
If I do it manually wth three fields from MyphpAdmin it does update.