OK, this really has me flummoxed. I'm not sure if I'm going about this the right way.
I have three tables, an Employer table, a Provider table and a Jobs table. Each Provider (worker) has up to nine zip codes and a possible metro area which contains all the zip codes in their city which is their "service area". When they log on, I need to display only the Jobs in any of their zip codes. In the Jobs table, there is a remote zip field (remzip) and if that has a value, that is the zip where the job is, otherwise we use the zip field in the Employers table. I've built two arrays one by "SELECT * FROM Providers INNER JOIN Employers ON Jobs.empid = Employers.EmpID "; which gives me both the remzip and zip fields and the jobid field. And one by querying the database for all the zips in the service area of that particular Provider and dumping them all into an array. So now I have these two arrays I can compare...is there an easier way to do this or ... ? I need to compare these two arrays and if any value from array 2 is in array 1, pull out the entire row by jobid from the database and display it. Thanks in advance, ---- Kristina _______________________________________________ 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
