Yes, thank you very much, I shouldn$B!G(Bt code late at night without any caffeine in me.
- Vic -----Original Message----- From: @ Edwin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 14, 2002 12:29 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: [PHP] mysql error Looks like you're updating your table so instead of "INSERT INTO...", try: "UPDATE malibu_data SET ..." HTH, - E > >I get this error: > >Error submiting paragraph.You have an error in your SQL syntax near >'WHERE page_name='features' AND par_id='13' ' at line 1 > > >But my code, I think is fine: > >// Insert the form information into the database > mysql_query("INSERT INTO malibu_data SET heading='$heading', >paragraph='$paragraph' >WHERE page_name='$page_name' AND par_id='$par_id' ") > or die ('Error submiting paragraph.'. mysql_error()); > > >- Vic > > > >______________________________________________________________________ >Post your ad for free now! http://personals.yahoo.ca > >-- >PHP General Mailing List (http://www.php.net/) >To unsubscribe, visit: http://www.php.net/unsub.php _________________________________________________________________ $B%O%$%;%s%9$J>&IJ$r5$7Z$K9XF~(B MSN $B%7%g%C%T%s%0(B http://shopping.msn.co.jp/ ______________________________________________________________________ Post your ad for free now! http://personals.yahoo.ca -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php