List:General Discussion« Previous MessageNext Message »
From:D. Marshall Lemcoe Jr. Date:October 10 2011 1:14pm
Subject:Weird UPDATE Problem
View as plain text  
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,