I've had a few queries that worked strangely worked in Mysql monitor,
but did not work from PHP.
I was able to solve every one of them by ensure that the query in PHP did
not have any line breaks in it. It normally doesn't matter if there are
line breaks in the code, but on occassion, a line break can cause strange
results.
Hope this helps.
Mike
On Wed, 5 Dec 2001, Javier
Muniz wrote:
Hello,
I'm having trouble determining what's going wrong with a MySQL query that
I'm doing from PHP.
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. Any thoughts on where this
problem originates from? PHP or MySQL? They're pretty commonly used in
unison so I'd imagine something like this should work fairly smoothly. I've
also posted this to the PHP list in case there's someone there that's
encountered
this before.
Javier Muniz
Chief Technology Officer
Granicus, LTD.
Tel: (415) 522-5216
Fax: (415) 522-5215
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Michael J. Ridinger
Lead Web Developer
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php