djanim8 Posted August 2, 2007 Share Posted August 2, 2007 I've looked over this like 100 times and can't seem to find the error, thought maybe another person could look over it and see what I'm missing... UPDATE packages SET name = 'Pkg 1. Complete Sound', price = '895', desc = 'Package priced fo up to 4 hours performance time. Package includes up to 3 hours complimentary set-up time, MC service from your chosen Disc Jockey throughout the evening, 2 Professional JBL Powered Speakers, Wireless Microphone, Custom-built Disc Jockey unit with Professional Grade equipment.' WHERE pkgID = '1' the error I get is: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'desc = 'Package priced for up to 4 hours performance time. Package includes up t' at line 1 Quote Link to comment https://forums.phpfreaks.com/topic/63082-error-in-sql-statement/ Share on other sites More sharing options...
premiso Posted August 2, 2007 Share Posted August 2, 2007 UPDATE `packages` SET `name` = 'Pkg 1. Complete Sound', `price` = '895', `desc` = 'Package priced fo up to 4 hours performance time. Package includes up to 3 hours complimentary set-up time, MC service from your chosen Disc Jockey throughout the evening, 2 Professional JBL Powered Speakers, Wireless Microphone, Custom-built Disc Jockey unit with Professional Grade equipment.' WHERE `pkgID` = '1' desc is a reserved keyword, use backticks around table and column names (`). Single quotes go around data like you have them. Quote Link to comment https://forums.phpfreaks.com/topic/63082-error-in-sql-statement/#findComment-314151 Share on other sites More sharing options...
DeepakJ Posted August 2, 2007 Share Posted August 2, 2007 priced fo up to 4 hours typo. Just so you know. Quote Link to comment https://forums.phpfreaks.com/topic/63082-error-in-sql-statement/#findComment-314157 Share on other sites More sharing options...
djanim8 Posted August 2, 2007 Author Share Posted August 2, 2007 ahhh didn't know that, thanks Quote Link to comment https://forums.phpfreaks.com/topic/63082-error-in-sql-statement/#findComment-314158 Share on other sites More sharing options...
djanim8 Posted August 2, 2007 Author Share Posted August 2, 2007 priced fo up to 4 hours typo. Just so you know. LOL yea I know, I thought the "FOR" was causing a problem.. thanks! Quote Link to comment https://forums.phpfreaks.com/topic/63082-error-in-sql-statement/#findComment-314161 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.