Yes, actually my apologies to everyone. I figured out the error. So , yep, I'm down to a problem with the date. The column is set to date. I'll go ahead and add the quotes. Stuart --- dpgirago@xxxxxxxxxxxxxx wrote: > Stuart, > > The date has forward slashes. These are not > integers, right? So put single > quotes around the whole date, like '10/15/2004'. > > dave > > > > > > Stuart Felenstein <stuart4m@xxxxxxxxx> > > 10/14/2004 10:02 AM > > > > > > To: > Stuart Felenstein <stuart4m@xxxxxxxxx> > cc: > php-db@xxxxxxxxxxxxx > > > > > Subject: > RE: mysql error and resource ID: > > > > Anyone see something wrong here : > > My error message is : > > "0: 1064: You have an error in your SQL syntax. > Check > the manual that corresponds to your MySQL server > version for the right syntax to use near > 'ddddd',1,'ddddddddd',1,1, 31, 33,10/15/2004))' at > line 5" > > Code: > > $query = "INSERT INTO MainTable > (RecordID,UserID,other > fields..............) > values > (null,null,'$f1a',$f2a,$f2c,$f2d,$f2e,$f2g,'$f5b','$f3m','$f3n,'$f3e',$f3f,'$f3g',$f3h,$f3i, > $f3j, $f3k,$f3l))"; //not sure if the double ) is > //needed though it doesn't make a diff > begin(); // transaction begins > $result = mysql_query($query); > > --- Stuart Felenstein <stuart4m@xxxxxxxxx> wrote: > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
