Hello NYPHP,
I have an array that has 13000 email addresses. For now, its in the
script but will be in a database table eventually. It is a list of
known bad guys.
I have a database table with 9000 records and one of the fields is
an email address.
In PHP I am using a foreach to loop through the array and do a
database lookup to try to find any matching emails.
I am using this query inside the foreach loop:
$res = ("SELECT * FROM `table` WHERE `email` = '$email2Chk'");
$numRows = mysql_num_rows($res);
if ( !empty($numRows ))
It processes about 12000 addresses in the array and the script times out.
Anyone have a better idea for doing this task?
TIA for any help.
--
Best regards,
mikesz mailto:[EMAIL PROTECTED]
_______________________________________________
New York PHP Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk
NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com
Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php
