Comparing 2 table fields

TSiOmiCron

i got 2 tables:
Table1 = eqdkp_members with the colums: member_name, member_adjustment

Table2 = raidsign_signups with the colums: name

This is what i want to do:

The users in the raidsign table is deleted all the time, but the ones in the eqdkp members is constant. Users have to type in their name again everytime the raidsign table is empty, so it has to be independent of case sensitivty if the user types his name FrAnk one time and frank another time.

I want to, is compare the user in the eqdkp members table to the other one. if the user exist, i want to show the dkp number for that user found in the eqdkp table. i really dont know how to do this, and iv'e tried lots of different things with no success.

example:

$compare1 = mysql_query ("SELECT name FROM raidsign_signups");
$myrow = mysql_fetch_array($compare1);
$compare2 = mysql_query ("SELECT member_name FROM eqdkp_members");
$myrow2 = mysql_fetch_array($compare2);


if (strtolower ($myrow['name']) == ($myrow2['member_name']))  {
echo "DKP";
} else {
echo "No DKP";
}

$query1 = "SELECT raidsign_signups.name, eqdkp_members.member_name FROM raidsign_signups, eqdkp_members WHERE raidsign_signups.name = eqdkp_members.member_name";
$result1 = mysql_query ($query1) or die(mysql_error());
$member = mysql_fetch_row($result);

any idea on how to write it?

-OmiCron-

TSiOmiCron

Anyone?!

Was is 2 hard 2 answer or?

-OmiCron-

Roger_Ramjet

If the names in eqdkp_members are always there while those in the other table are deleted then eqdkp_members should be the left-hand table in your queries and you should be using a left join so that you always get something retured even if the raidsign table is empty.

Go read up on Join Syntax , especially the part about Left Joins. You should be able to work it out from there, and you'll learn more than you would if I just wrote the queries for you.

hints: pay attention to the part about IS NULL; in ver 4.0+ string comparison is generally case-insensitive unless you force a binary comparison, earlier versions are case-sensitive, but you can change this behaviour in all versions through the character set collation settings.

TSiOmiCron

Thank you very much Roger. Will have a look at it 🙂 Learning new stuff every day now.

-OmiCron-