W
WYSIWYG
Guest
Hi. I have the below sql code in a php file. It should be obtaining data from a form which it is linked to. The sql code is:
mysql_query("INSERT INTO lecturer
VALUES"($_POST['age'],
'$_POST['sex']','$_POST['user']',
'$_POST['pwd']',
'$_POST['emailAddress']',
'$_POST['firstName']',
'$_POST['secondName']',
'$_POST['houseNumber']',
'$_POST['pCFirstPart']',
'$_POST['pCSecondPart']',
'$_POST['phoneNum']','N'")");
When i try to run it and submit the form i get the error:
Parse error: parse error, unexpected '
What should the sql code look like because i cant fix it no matter what i do to its formatting.... thanks for the help.
ps it is layed out like tha above because answers cutts the text off if on one line. thanks
mysql_query("INSERT INTO lecturer
VALUES"($_POST['age'],
'$_POST['sex']','$_POST['user']',
'$_POST['pwd']',
'$_POST['emailAddress']',
'$_POST['firstName']',
'$_POST['secondName']',
'$_POST['houseNumber']',
'$_POST['pCFirstPart']',
'$_POST['pCSecondPart']',
'$_POST['phoneNum']','N'")");
When i try to run it and submit the form i get the error:
Parse error: parse error, unexpected '
What should the sql code look like because i cant fix it no matter what i do to its formatting.... thanks for the help.
ps it is layed out like tha above because answers cutts the text off if on one line. thanks