[Resolved] sql error causing me to go bald

[mystrymaster]

allright so I get this error

You have an error in your SQL syntax near 'cross, loc, county, callb, carinf, reg, prob, cov, allinf, recap, expec, seconet' at line 2

here is the query

mysql_query("INSERT into csrmonitor
(who, login, phone, memnum, date, callnum, emp, custname, callrem, nadp, phys, cross, loc,
 county, callb, carinf, reg, prob, cov, allinf, recap, expec, seconetot, tow, aarneed, 
referaar, garage, dest, estimate, passnum, drive, onetime, sectwotot, bonus, comments, total, poss)
VALUES
('$who', '$login', '$phone', '$memnum', '$date', '$callnum', '$emp', '$custname', '$callrem', '$nadp', '$phys',
 '$cross', '$loc', '$county', '$callb', '$carinf', '$reg, '$prob', '$cov', '$allinf', '$recap', '$expec', 
'$secOneTotal', '$tow', '$aarneed', 
'$referaar', '$garage', '$dest', '$estimate', '$passnum', '$drive',
'$onetime', '$secTwoTotal', '$bonus', '$comments', '$grandTotal', '$totalposs')") or die(mysql_error());

Here is the create for the db

CREATE TABLE csrmonitor (
ID int(11) NOT NULL auto_increment,
who int(11) NOT NULL default '0',
login varchar(100) NOT NULL default '',
phone varchar(100) NOT NULL default '',
memnum varchar(100) NOT NULL default '',
date datetime NOT NULL default '0000-00-00 00:00:00',
callnum int(11) NOT NULL default '0',
emp int(11) NOT NULL default '0',
custname int(11) NOT NULL default '0',
callrem int(11) NOT NULL default '0',
nadp int(11) NOT NULL default '0',
phys int(11) NOT NULL default '0',
cross int(11) NOT NULL default '0',
loc int(11) NOT NULL default '0',
county int(11) NOT NULL default '0',
callb int(11) NOT NULL default '0',
carinf int(11) NOT NULL default '0',
reg int(11) NOT NULL default '0',
prob int(11) NOT NULL default '0',
cov int(11) NOT NULL default '0',
allinf int(11) NOT NULL default '0',
recap int(11) NOT NULL default '0',
expec int(11) NOT NULL default '0',
seconetot int(11) NOT NULL default '0',
tow int(11) NOT NULL default '0',
aarneed int(11) NOT NULL default '0',
referaar int(11) NOT NULL default '0',
garage int(11) NOT NULL default '0',
dest int(11) NOT NULL default '0',
estimate int(11) NOT NULL default '0',
passnum int(11) NOT NULL default '0',
drive int(11) NOT NULL default '0',
onetime int(11) NOT NULL default '0',
repairneed int(11) NOT NULL default '0',
repair int(11) NOT NULL default '0',
sectwotot int(11) NOT NULL default '0',
bonus int(11) NOT NULL default '0',
comments mediumtext NOT NULL,
total int(11) NOT NULL default '0',
poss int(11) NOT NULL default '0',
PRIMARY KEY (ID)
) TYPE=MyISAM;

Now I can not figure out where the freakin problem is

If the form code will help please let me know and I will post that as well.

[CrimsonBane]

Ok, from a quick check everything looks correct (although I am not a fan of putting ' ' around numerical values because enterprise database software will not allow you to do that.

can you do a echo "INSERTÂintoÂcsrmonitor
(who,Âlogin,Âphone,Âmemnum,Âdate,Âcallnum,Âemp,Âcustname,Âcallrem,Ânadp,Âphys,Âcross,Âloc,
Âcounty,Âcallb,Âcarinf,Âreg,Âprob,Âcov,Âallinf,Ârecap,Âexpec,Âseconetot,Âtow,Âaarneed,
referaar,Âgarage,Âdest,Âestimate,Âpassnum,Âdrive,Âonetime,Âsectwotot,Âbonus,Âcomments,Âtotal,Â_poss)
VALUES
('$who', '$login', '$phone', '$memnum', '$date', '$callnum', '$emp', '$custname', '$callrem', '$nadp', '$phys',
'$cross', '$loc', '$county', '$callb', '$carinf', '$reg, '$prob', '$cov', '$allinf', '$recap', '$expec',
'$secOneTotal', '$tow', '$aarneed',
'$referaar', '$garage', '$dest', '$estimate', '$passnum', '$drive',
'$onetime', '$secTwoTotal', '$bonus', '$comments', '$grandTotal', '$totalposs')";

and give us the result. I find its normally easier to identify bugs this way as sometimes you don't always get the most accurate error report.

[mystrymaster]

INSERT into csrmonitor
(who, login, phone, memnum, date, callnum, emp, custname, callrem, nadp,
phys, cross, loc, county, callb, carinf, reg, prob, cov, allinf, recap, expec, seconetot, tow, AARneed,
referaar, garage, dest, estimate, passnum, drive, onetime, repairneed, repair, sectwotot, bonus, comments, total, poss) VALUES ('21', '2865', '4587', '85263512', '2003-08-21 12:03:50', '1254', '5', '5', '5',
'5', '5', '5', '5', '5', '5', '5', '5', '10', '5', '15', '10', '5', '100', '1', '1', '1', '1', '1', '1', '1', '1', '1',
'1', '1', '0', '1', 'test comments', '100', '120')

That is the reuslt of the query and man it still looks fine to me I even echo the key value pairs from the query so I would get everything accurately and man it just doesn like it.

[mystrymaster]

Just so all know

I got it to work by changing the word cross to crossstreet

Maybe cross is a resrved word?

I don't have the time to check right now.