yes, I am a blonde

[Anon]

I am trying to insert a new record, but get a:
"Could not execute SQL insert statement Unknown column 'cars' in 'field list'"

Cars is replaced by whatever the $catagory value may contain at the time. Here is my code, can some kind soul please help me!!

$catagory = addslashes($cat)
or die("Could not execute function \"AddSlashes\" ".mysql_error());

$rsNewCat = mysql_query("INSERT INTO catagory (cat) VALUES ($cat)")
or die("Could not execute SQL insert statement ". mysql_error());

$rsCatID = mysql_query("SELECT catid FROM catagory WHERE catagory = '$cat'")
or die("Could not retrive \"CatID\". ". mysql_error());

---

[Anon]

Well... the error is just what it says... There is no 'cars' field in the table your inserting into...

The what you do wrong is not that... You need to put ' on the sides of $cat....

like this:

INSERT INTO catagory (cat) VALUES ('$cat')

Hope this helps

Andreas

[Anon]

Thank you all. I figured it out last night, missing quotes! See what happens when you are still writing code at three in the morning. Sorry for the bother everyone.

Saliudos,
Robert James Patterson
(A.K.A. Boweavil)
[e-mail]