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-------
Date: 08/02/04 13:45:22
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
--
|