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. Link to comment https://forums.phpfreaks.com/topic/21268-wierd-syntax-error/ 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. Link to comment https://forums.phpfreaks.com/topic/21268-wierd-syntax-error/#findComment-94606 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. Link to comment https://forums.phpfreaks.com/topic/21268-wierd-syntax-error/#findComment-95177 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.