> 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:[EMAIL PROTECTED] 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! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
