Here is the code:
function array_search_bit($search, $array_in)
{
foreach ($array_in as $key => $value)
{
if (strpos($value, $search) !== FALSE)
return $key;
}
return FALSE;
}
$coll_check_sql = mysql_query("select paper_ad_no, db_id from collectibles_data where interface_type = 'Class_Coll'");
$coll_check_num = mysql_num_rows($coll_check_sql);
for($c=0; $c<$coll_check_num; $c++){
$coll_check_row = mysql_fetch_array($coll_check_sql);
$coll_searchkey = array_search_bit($coll_check_row[paper_ad_no], $file);
if($coll_searchkey != ''){
} else {
$coll_del_sql = "delete from collectibles_data where paper_ad_no = '$coll_check_row[paper_ad_no]'";
$coll_del_result = mysql_query($coll_del_sql);
$coll_del_ph = mysq_query("delete from collectibles_photo where db_id = '$coll_check_row[db_id]'");
system("rm /home/kitsapsu/classifieds_photo_uploads/collectibles.$coll_check_row[db_id].*");
}
}
Here is part of the array (with no spaces between lines):
"2010","12/08/2006","<B> 1920 Barber chair </B>$600 (360)692-7213","20024888","","","3060 NE MCWILLIAMS RD 127","BREMERTON","Washington","98311","36069272130000","",""
"2010","12/08/2006","<B> Beautiful </B> <B> Black </B> <B> Bear </B>rug, $500 offer (360)621-3220","20024758","","","PO BOX 133","POULSBO","Washington","98370","36062132200000","",""
"2010","12/08/2006","<B> Life size Collectors </B> <B> Ltd Edition </B> "YODA" & "JARJAR" Amazingly real! $500ea/offer. (360)621-3220","20024931","","","PO BOX 133","POULSBO","Washington","98370","36062132200000","",""