Ninjakreborn Posted September 19, 2006 Share Posted September 19, 2006 [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. Quote Link to comment Share on other sites More sharing options...
Ninjakreborn Posted September 19, 2006 Author Share Posted September 19, 2006 Nevermind, I wasn't sending it to the right table, nevermind. Quote Link to comment Share on other sites More sharing options...
fenway Posted September 20, 2006 Share Posted September 20, 2006 Let this be a lesson to everyone -- post the interpolated query string after variable substitution as well. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.