nadeemshafi9 Posted January 2, 2007 Share Posted January 2, 2007 hello guysi am able to work normaly whith all the tables in my DB, exept i just added another table, i am sure it has no special change made to any feild. The prob is it is insisting on ` being around one feild in particular (all feilds are same type)$sql = "INSERT INTO users (userid, password, email, `group`) ".the thing i am worried about is for portability as this will be ported on to LAMP and is being developed on W,ISS,M,P is why the hell is it insisting i have the crazy chars around group like this `group` i mean none of my other tables in the db ask for this, mysql_error basicaly says you hav an error near group until i put it like `group` so why is this.as always Thanks guys for any help. Quote Link to comment Share on other sites More sharing options...
nadeemshafi9 Posted January 2, 2007 Author Share Posted January 2, 2007 i found some info but it dosent make sense mysql.comA phrase that is enclosed within double quote (`"') characters matches only rows that contain the phrase literally, as it was typed. why ? its no diff from any other feild, il try delete it and make it again see what happens 1 sec. Quote Link to comment Share on other sites More sharing options...
nadeemshafi9 Posted January 2, 2007 Author Share Posted January 2, 2007 no change still requires the special quotes `` around group but why ? Quote Link to comment Share on other sites More sharing options...
fenway Posted January 3, 2007 Share Posted January 3, 2007 [quote author=nadeemshafi9 link=topic=120623.msg494979#msg494979 date=1167701102]no change still requires the special quotes `` around group but why ?[/quote]GROUP is a reserved MySQL keyword (as in GROUP BY)... so you have to escape it. Quote Link to comment Share on other sites More sharing options...
nadeemshafi9 Posted January 4, 2007 Author Share Posted January 4, 2007 dum me, thanx for the news flashthanx v much 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.