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