Hi, 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.
HTH Dobromir -----Original Message----- From: Jay Paulson <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Tuesday, October 02, 2001 2:22 AM Subject: [PHP-DB] Update Query? >Hello- >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 using >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; > >thanks, >jay > > >-- >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]