The query code seems fine to me - did you try to otput $query to see if all
the variables you are using are OK. May be $order,$stationid or $orderNewsID
is misspeled or is not set properly.


-----Original Message-----
From: Jay Paulson <[EMAIL PROTECTED]>
Date: Tuesday, October 02, 2001 2:22 AM
Subject: [PHP-DB] Update Query?

>I'm trying to run an update query in an application I'm making.  I keep
>getting a MySQL error however when I try and print out the mysql_error()
>nothing is returned.  I run the same query in phpMyAdmin and the query runs
>fine.  Below is the update query I'm running and the php code that I'm
>to build it.  Any suggestions?
>update news set newsOrder=2 where station_id=5 and id=3
>$query = "update news set newsOrder=".$order." where station_id=$stationid
>and id=".$orderNewsID;
>PHP Database 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]

PHP Database 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