RE: [PHP] mysql error
| From: | victor at argilent dot com | Date: | Wed, 14 Aug 2002 04:54:24 +0000 |
| Subject: | RE: [PHP] mysql error | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-112484@lists.php.net to get a copy of this message | ||
Yes, thank you very much, I shouldn’t code late at night without any
caffeine in me.
- Vic
-----Original Message-----
From: @ Edwin [mailto:copperwalls@hotmail.com]
Sent: Wednesday, August 14, 2002 12:29 AM
To: victor@argilent.com
Cc: php-general@lists.php.net
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
_________________________________________________________________
ハイセンスな商品を気軽に購入 MSN ショッピング http://shopping.msn.co.jp/
______________________________________________________________________
Post your ad for free now! http://personals.yahoo.ca