> I am passing an SQL statement through to Mysql, in certain circumstances > (not very often), the information within the statement is the same as what > is in the database, therefore 0 records are affected. This is great from a > speed perspective, but I want to know that 0 records were affected because > the information was the same and not something else. Anyway of doing his?
http://www.bitbybit.dk/mysqlfaq/faq.html#ch8_4_0 -- and your API's equivalent of mysql_info(). You can also specify a variable for client_flag when doing a mysql_real_connect(), forcing MySQL to return the number of matched rather than affected rows. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php