Posted by Jerry Stuckle on 05/12/07 02:23

pmelan@yahoo.com wrote:
> Hi everyone.
>
> I wasn't sure how to describe what I want in the subject line so
> hopefully this post will allow me to further explain. I have a table
> where I have names of people who have filed evictions against their
> tenants. These plaintiffs have no mailing street addres. They have a
> city, state, and zip code. In another table, I have a massive listing
> of those plaintiffs who have filed evictions against their tenants but
> each record includes a full mailing address; street, city, state, and
> zip.
>
> What I'm trying to figure out is how to write a little PHP program to
> compare the name fields of table 1 (without address) into table 2
> (with addresses) and replace the address in table 1 with the address
> from table 2 based on the match. I would also like the capability to
> match combined fields from table 1 into table 2, meaning, if I were to
> combine name, city, state, and zip in table 1 and combine name, city,
> state, zip in table 2, I will most likely have the ability to reduce
> the list.
>
> Any ideas??
>
> Thanks in advance.
>
> Peter Melan
>

Peter,

I wouldn't even do it in PHP. I'd just use SQL. Check
comp.databases.mysql (or whatever database you're using) for a
SQL-specific answer to your problem.


--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

[Back to original message]