Update Query?
| From: | Jay Paulson | Date: | Mon, 01 Oct 2001 23:23:11 +0000 |
| Subject: | Update Query? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-12900@lists.php.net to get a copy of this message | ||
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