That query looks fine. What error are you getting if you execute the query
from the CLI? Also is it possible that the s_id or owed columns are no longer
numeric data types? If this column(s) is/are a character type now, then you
would need to have the values in quotes.
-Brandon
On 10/10/2011 09:14 AM, D. Marshall Lemcoe Jr. wrote:
Hello all.
I have recently finished my migration from an older server to a newer
server running RHEL 6. The MySQL version went from 5.0.77 to 5.1.52.
In my application, this query used to work just fine:
$paid_query = mysql_query("UPDATE $table_name SET owed = 0 WHERE s_id
= $student");
Where table_name was
mysql_real_escape_string("collection_41_students"). With the new MySQL
version, the UPDATE query does not work, and echo mysql_error();
results nothing.
Is my syntax correct going from version to version?
Thanks in advance,
David
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[email protected]
