Maybe unquote 'posts' -- I would write: $query = "INSERT INTO posts ( `post_id` , `post_title` , `post_date` , ......
On Monday 02 August 2004 06:49 am, me2resh wrote: > thanks for your help > > i did that > and here is the error message returned > > 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 ''posts' ( > `post_id` , `post_title` , `post_date` , `post_author > > how can i fix it ? > > > -------Original Message------- > > From: John Holmes > Date: 08/02/04 13:45:22 > To: me2resh > Cc: [EMAIL PROTECTED] > Subject: Re: [PHP] script error > > > $query = "insert into 'posts' ( `post_id` , `post_title` , `post_date` , > > `post_author` , `post_content` , `m_cat_id` , `s_cat_id` , `post_pic`) > > values (\'\', \'$post_title, \'$post_title, \'$post_author, > > \'$post_content, \'\', \'\', \'subject.gif\' )"; > > mysql_query($query); > > Change that last line to > > mysql_query($query) or die(mysql_error()); > > and run the script again. If you can't figure it out, post back with the > error message and what troubleshooting you've done. > -- > > John Holmes > > php|architect - The magazine for PHP professionals - http://www.phparch.com > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php