Re: Update creating a new record?
| From: | Analysis & Solutions | Date: | Mon, 05 Aug 2002 19:06:10 +0000 |
| Subject: | Re: Update creating a new record? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-111245@lists.php.net to get a copy of this message | ||
On Mon, Aug 05, 2002 at 11:46:53AM -0700, Wm wrote:
> I've noticed that every time I "update" a record, mySQL is actually adding a
> new record (highest number ID, at the end) and deleting the original record.
Sounds like you're using a REPLACE query rather than an UPDATE query.
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#REPLACE
--Dan
--
PHP classes that make web design easier
SQL Solution | Layout Solution | Form Solution
sqlsolution.info | layoutsolution.info | formsolution.info
T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y
4015 7 Av #4AJ, Brooklyn NY v: 718-854-0335 f: 718-854-0409