mysql update query

Hi guys Bit of a problem I'm having here with an update query on a PHP/MySQL site: This is the db query I execute: $result6=mysql_query("UPDATE $WorkTable SET Price=$CallCost WHERE (A_Number = $A_Number AND StartDateTime = $D_Full AND Duration=$Duration AND SMSDestinationName = '$SMSDestinationName')"); which returns the following SQL query: UPDATE cdr200311 SET Price=0.225 WHERE (A_Number = 61210146 AND StartDateTime = 2003110216502400 AND Duration=15.0167 AND SMSDestinationName = '1010') The query executes successfully, but nothing happens to the database... all connections etc are in place. Am I right to have the brackets around the WHERE conditions? I have also tried this query in phpMyAdmin but no result... and yes, the record does exist.. Help! Thanks Enda -- -- Enda Nagle NightSol e: enda@nightsol.net w: www.nightsol.net