[Resolved] Simple SQL Insert

[furious5]

Arghhh I'm having one of those days today.

Why won't my INSERT statement work?

$sql = "INSERT INTO JOB (jobid, title, description, location, skills, salary, industry) VALUES (\"$jobid\", \"$title\", \"$description\", \"$location\", \"$skills\", \"$salary\", \"$industry\")";

$sql_result  = mysql_query($sql, $connection) or die("Sorry couldn't add job posting to table"); 

If I echo the statement I get this:

INSERT INTO JOB (jobid, title, description, location, skills, salary, industry) VALUES ("6", "2", "3", "4", "5", "6", "Accounting")Sorry couldn't add job posting to table

Any ideas?

[kevinsequeira]

try single quotes instead of double
to debug try printing mysql_error() after u insert into db

reg
kevin

[ahundiak]

Add mysql_error() to your die string and it should give you a clue.

You might want to consider using single quotes instead of double quotes around the data values simply because there will less typing. But double quotes should work. I'd say you have a db connection problem or one of column names is misspelled.