PHP Help needed (Database Comparison)

[Allenport]

Ok I have a 2 table database.

One table called contacts and another table called user_info.

Each table has a field called "email"

There are 80 entries in "user_info" and 400 in "contacts".

I want to take the info from user_info and check if that email address is in contacts and if it is add "Regestered" to the field "Status" in the "contacts" table otherwise I want it to add "Unregistered" Is there an easy way to do this? Or would someone whip up a small php script for me?

[Allenport]

So there is noone who can write a script that compairs one row and then adds "registered" or "Unregistered"?

All I really need is something that does this (psudocode)

{loop}
FOR EACH 
SELECT email FROM contacts;
SElECT email FROM user_info;
IF email == email
UPDATE contacts('status') VALUE ('Regestered');
ELSE
UPDATE contacts('status') VALUE ('Unregestered');
END IF
{/loop}

but i just started with php and havent been able to do this yet.

[matt72]

Here ya go. Something like this should work:

//Connect to database server, select database, then:
$result = mysql_query("SELECT email FROM contacts");
if(mysql_num_rows($result))
{
   while($data = mysql_fetch_array($result))
   {
       $info_result = mysql_query("SELECT email FROM user_info WHERE email = '" . $data['email'] . "'");
       if(mysql_num_rows($info_result))
       {
              $update = mysql_query("UPDATE contacts SET status = 'Registered' WHERE email = '" . $data['email'] . "'");
       }
        else
       {
              $update = mysql_query("UPDATE contacts SET status = 'Unregistered' WHERE email = '" . $data['email'] . "'");
       }
   }
}

[Allenport]

Thank you I will try that.