Hello,

I am experiencing some strangeness that I've never ran into before. On an update statement, like:

update students set counselor_id = 1 and school_attending='Univsity of Maryland' where id = 1;

I have no errors generated with the query, but the affected rows reads 0? This is not duplicate data, and even if I change the data around, the query appears to go through, but no affected rows. I got around the problem by writing a separate query for each field, but that sucks. All of my queries are going through the PHP, so I guess, through the PHP native MySQL functions. Any ideas?