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. Link to comment https://forums.phpfreaks.com/topic/32509-solved-sql-variant-mysql-4/ 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. Link to comment https://forums.phpfreaks.com/topic/32509-solved-sql-variant-mysql-4/#findComment-151127 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 ? Link to comment https://forums.phpfreaks.com/topic/32509-solved-sql-variant-mysql-4/#findComment-151128 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. Link to comment https://forums.phpfreaks.com/topic/32509-solved-sql-variant-mysql-4/#findComment-151872 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 Link to comment https://forums.phpfreaks.com/topic/32509-solved-sql-variant-mysql-4/#findComment-152745 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.