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]