SQL syntax error

[einSTein]

this is my syntax

$kk=$session['user'];
$sql="INSERT INTO user2 WHERE user = $kk (obj, Expr, pos, dob, comp, cnt, cert, Major, Grade, stPeri, cont2, skills, eng, fr, ge, span, other, jobT, empT)

this is my error

Error: You have an error in your SQL syntax near 'WHERE user = walaa (obj, Expr, pos, dob, comp, cnt, cert, Major, Grade, stPeri, ' at line 1

i want to know whats wrong in my syntax an u must know that it raads the user well

[-T-]

Put "WHERE user = $kk" at the end

INSERT INTO user2 (obj, Expr, pos, dob, comp, cnt, cert, Major, Grade, stPeri, cont2, skills, eng, fr, ge, span, other, jobT, empT) WHERE user = $kk 

Though, are the parts between the ( ) values or column names?

if it is, you need to do it like this

INSERT INTO user2 VALUES ("obj", "Expr", "pos", "dob", "comp", "cnt", 
"cert", "Major", "Grade", "stPeri", "cont2", "skills", "eng", "fr", "ge", "span", "other", "jobT", "empT") WHERE user = $kk 

If it's not values but column names you aren't inserting any values into the table

[einSTein]

$sql="INSERT INTO user2 (obj, Expr, pos, dob, comp, cnt, cert, Major, Grade, stPeri, cont2, 
 
skills, eng, fr, ge, span, other, jobT, empT) WHERE user = $kk
VALUES
('$_POST[obj]','$Exp','$_POST[phel]','$_POST[cnam]', '$_POST[con]','$_POST
 
[cer]','$_POST[Maj]','$_POST[Gd]','$_POST[stp]','$_POST[ctry]','$_POST[skills]','$_POST
 
[Eng]','$_POST[FR]','$_POST[Ger]','$_POST[Spsh]','$_POST[other]','$_POST
 
[Job]','$_POST[type]')";

this is the error now

Error: You have an error in your SQL syntax near 'WHERE user = walaa VALUES ('asdas','1','','', 'Egypt','','sdasdas','Pass','','' at line 1

[r937]

if you are going to supply values, the correct syntax does not allow a WHERE clause at all

check this page for more info

[-T-]

Woha, now I feel stupid Mixed up update and insert for a sec

If you are to update a field in the database, you can use where, but if you insert a new entry there is no need to match it to old entries, thus where gives you an error