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
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
2011/10/10 09:19 -0400, Brandon Phelps
If this column(s) is/are a character type now, then you would need to have the
values in quotes.
Note that because of implicit conversion if they had numberic values no error
would be reported, but maybe the equality would not be exact.
--
MySQL