Re: mysql update query
| From: | Richard Davey | Date: | Fri, 19 Dec 2003 16:37:21 +0000 |
| Subject: | Re: mysql update query | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-173023@lists.php.net to get a copy of this message | ||
Hello Enda,
Friday, December 19, 2003, 4:32:44 PM, you wrote:
E> which returns the following SQL query:
E> UPDATE cdr200311 SET Price=0.225 WHERE (A_Number = 61210146 AND
E> StartDateTime = 2003110216502400 AND Duration=15.0167 AND SMSDestinationName
E> = '1010')
E> The query executes successfully, but nothing happens to the database... all
E> connections etc are in place.
Have you tried placing quotes around the values? The timestamps should
be ok, but the price with the decimal place will almost certainly need
them.
--
Best regards,
Richard mailto:rich@launchcode.co.uk