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


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to