$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