On Thu, 6 Dec 2001 08:32, Javier Muniz wrote:
> 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?
mysql_error() is a good debugging tool; it will return an error string
that may be useful.
David Robley Techno-JoaT, Web Maintainer, Mail List Admin, etc
CENTRE FOR INJURY STUDIES Flinders University, SOUTH AUSTRALIA
A waist is a terrible thing to mind.
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]