PcGeniusProductions Posted September 23, 2008 Share Posted September 23, 2008 Hi, i have spent all night looking for support, but cannot get the info I need... I want to run this query: insert into jos_ccnewsletter_subscribers(id,name,email,plaintext,enabled,sdate) values(68,name@domain.com,name,0,0,2008-09-22 17:14:07); But it gives me an error, I suspect it is the "@" sign. Does anyone know a fix for this? I would be extremely grateful for any help you can offer. Quote Link to comment https://forums.phpfreaks.com/topic/125391-solved-sql-error-sign/ Share on other sites More sharing options...
F1Fan Posted September 23, 2008 Share Posted September 23, 2008 You need single quotes around pretty much anything that's not an integer or the word "NULL." Quote Link to comment https://forums.phpfreaks.com/topic/125391-solved-sql-error-sign/#findComment-648280 Share on other sites More sharing options...
peranha Posted September 23, 2008 Share Posted September 23, 2008 Put the items in quotes insert into jos_ccnewsletter_subscribers(id,name,email,plaintext,enabled,sdate) values('68','name@domain.com','name','0','0','2008-09-22 17:14:07'); Quote Link to comment https://forums.phpfreaks.com/topic/125391-solved-sql-error-sign/#findComment-648283 Share on other sites More sharing options...
PcGeniusProductions Posted September 23, 2008 Author Share Posted September 23, 2008 the quotes worked :D Thank you soo much. I have been searching google for hours. thanks for that guys, i am reli grateful. Quote Link to comment https://forums.phpfreaks.com/topic/125391-solved-sql-error-sign/#findComment-648285 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.