Jump to content

Archived

This topic is now archived and is closed to further replies.

Ninjakreborn

wierd, syntax error

Recommended Posts

[code]$insert = "INSERT INTO $postinfo (categoryname, subcategoryname, schoolname, userid, coursenumber, title, author, price, zipcode, dateentered, expiredate) VALUES ('$category', '$subcategory', '$schoolname', '$userid', '$coursenumber', '$title', '$author', '$price', '$zipcode', '$dateentered', '$expires');";[/code]
I have been re-using and re-replicating this sql query(with different variables), for over 4 days straight. A  total of 40 hours of work on this, and over 300 queries, and all of them worked fine, now out of nowhere I get one that says syntax error, right around category name, and I am sitting here comparing it to the other hundred and something queries and nothing is off, what's going on. It's for a classified ad system I am building for a client, everything else works, but when I got here, I noticed this one thing is messing up for some reason.

Share this post


Link to post
Share on other sites
Let this be a lesson to everyone -- post the interpolated query string after variable substitution as well.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.