On Tuesday, February 5, 2002, at 02:01 PM, DL Neil wrote:
> =option 2: whilst native-MySQL will give an errmsg in response to an > attempt to INSERT duplicates, PHP doesn't > have to pay attention! Check out MySQL_affected_rows(). David, I see... that's a good debugging tool, mysql_affected_rows(). Thank you for pointing me to that one. Still, I am glad that this sort of situation has been anticipated by the MySQL developers (or perhaps I should say the ANSI SQL spec drafters), and have decided to use INSERT IGNORE to handle my situation, if only to be forward compatible with a version of PHP that -might- pay attention. Hope all is well with you, Erik ---- Erik Price Web Developer Temp Media Lab, H.H. Brown [EMAIL PROTECTED] --------------------------------------------------------------------- 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