PHP + MySQL problem (strange behavior)
| From: | Javier Muniz | Date: | Wed, 05 Dec 2001 22:02:25 +0000 |
| Subject: | PHP + MySQL problem (strange behavior) | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-76787@lists.php.net to get a copy of this message | ||
Hello,
I'm having trouble determining what's going wrong with a MySQL query that
I'm doing from PHP. Now before you go blaming MySQL read on :)
I have a table with the following columns:
id (int)
name (varchar 20)
starttime (int)
duration (int)
now, i have a row that has a starttime of 60, when i attempt to do the
following update with PHP, it sets it to 0:
"UPDATE mytable SET starttime=starttime-30 WHERE name = 'myname'"
but when I run it from the MySQL command line, copy/pasted from the code, it
sets the value of starttime to 30 as expected.
Anyone have any clue why this is?
Javier Muniz
Chief Technology Officer
Granicus, LTD.
Tel: (415) 522-5216
Fax: (415) 522-5215