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,[email protected],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. 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." 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','[email protected]','name','0','0','2008-09-22 17:14:07'); 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. Link to comment https://forums.phpfreaks.com/topic/125391-solved-sql-error-sign/#findComment-648285 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.