PHP + MySQL problem (strange behavior)

From: 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

« previous php.general (#76787) next »