RE: [PHP] mysql update query
| From: | Jonathan Wilkes | Date: | Fri, 19 Dec 2003 17:22:16 +0000 |
| Subject: | RE: [PHP] mysql update query | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-173030@lists.php.net to get a copy of this message | ||
> just had a thought, what happens when you have only 2 records in the database, does it work, is
> it possible that you may > have had 2 identical records in the first instance, hence it not
> working ?
ignore my idiotic comment, it's friday, it's late and I have 2 weeks off (only 10 minutes
to go), so I wasn't really thinking when I typed it.
Honestly, a unique index may be the best bet...
-----Original Message-----
From: Enda [mailto:lists@nightsol.net]
Sent: 19 December 2003 17:13
To: Php-General
Subject: Re: [PHP] mysql update query
I used single..
just deleted all records except 1 from the table and changed the query to
have just one WHERE condition
$result6=mysql_query("UPDATE $WorkTable SET Price=$CallCost WHERE A_Number
= $A_Number");
this worked... so looks like i'm going to have to rewrite the import bit!
unless of course someone can come in with a last minute flash of
inspiration!
i really really don't need this at 5:12 on a friday afternoon!