-----Original Message----- From: Christian Calloway [mailto:[EMAIL PROTECTED] Sent: Thursday, June 05, 2003 1:13 PM To: '[EMAIL PROTECTED]' Subject: update statement, error free but no affected rows?
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? Christian Calloway, Web Developer [EMAIL PROTECTED] Antharia, LLC | TDS Interactive www.antharia.com www.tdsinteractive.com 301-982-7358 775-218-4603 (fax) WHERE DESIGN MEETS TECHNOLOGY! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]