Output db results with if statement

[bimmer528]

Heya, Having some trouble with this here. A helping hand would be great. I have given up trying to figure it out myself after 5 hours.

foreach($matches[1] as $key => $value) { //3
$name = $matches[1][$key];
$ip = $matches[3][$key];
$id= $matches[2][$key];





global $xoopsDB;

/*
$comparename = mysql_query("SELECT Player, IP, UniqueID FROM " . $xoopsDB->prefix('PlayersTOSERV') .
" WHERE Player = '$addname' AND IP = '$addip' AND UniqueID = '$addid'");
$mysql_num = mysql_num_rows($comparename); 

if ($mysql_num == 0) {  //4
$sql = "INSERT INTO ".$xoopsDB->prefix('PlayersTOSERV');
$sql .= " (id, Player, IP, UniqueID ) VALUES ";
$sql .= " ( '', '$name', '$ip' , '$id')";
$result = $xoopsDB->queryF($sql) or die('SQL Error: ' . mysql_error());
}
*/


$sql1 ="SELECT Player, IP, UniqueID FROM " . $xoopsDB->prefix('PlayersTOSERV') .
" ";
$result = $xoopsDB->query($sql1) or die('SQL Error: ' . mysql_error());


while ($v = mysql_fetch_row($result)) {

$checkname = $v['0'];

if ($checkname = $name) {
echo "Match" . $checkname . "In DB";
}
if ($checkname != $name) {
echo "No Match" . $name . "Not In DB";
}


}
}}

I can get the matches no problem but it's where I can't figure out how to output the names from the foreach-->check in db--->no result-->output just the names that are not in the db.

:/ cheers,

Bimmer

[Wynder]

Can you clarify your question a bit? It's kind of hard to follow what you're looking to do.

[bpat1434]

Watch your operators:
= sets a variable to a value
== compares

This:

if ($checkname = $name) {
echo "Match" . $checkname . "In DB";
} 

should probably be:

if ($checkname == $name) {
echo "Match" . $checkname . "In DB";
} 

[bimmer528]

Well, its recognizing the values from $name but this is what this script is doing exactly with the way it is now.

foreach($matches[1] as $key => $value) { //3
$name = $matches[1][$key];
$ip = $matches[3][$key];
$id = $matches[2][$key];

echo "<br>";



//echo "\n<br>" . $playername . " | " . $playerip . " | " . $playerid . "</br>\n" ;




/*$comparename = mysql_query("SELECT Player, IP, UniqueID FROM " . $xoopsDB->prefix('PlayersTOSERV') .
" WHERE Player = '$addname' AND IP = '$addip' AND UniqueID = '$addid'");
$mysql_num = mysql_num_rows($comparename); 

if ($mysql_num == 0) {  //4
$sql = "INSERT INTO ".$xoopsDB->prefix('PlayersTOSERV');
$sql .= " (id, Player, IP, UniqueID ) VALUES ";
$sql .= " ( '', '$addname', '$addip' , '$addid')";
$result = $xoopsDB->queryF($sql) or die('SQL Error: ' . mysql_error());
}
*/





global $xoopsDB;
$sql1 ="SELECT Player, IP, UniqueID FROM " . $xoopsDB->prefix('PlayersTOSERV') . 
" "; 
$result = $xoopsDB->query($sql1) or die('SQL Error: ' . mysql_error()); 


while ($v = mysql_fetch_row($result)) { 


$checkname = $v['0']; 
}
if ($name == $checkname) { 
echo "<br>Match " . $name . " In DB<br>"; 
} 
if ($name !== $checkname) { 
echo "<br>No Match " . $name . " Not In DB<br>"; 

}
}}

Lets say $name returns one, two, three, four, five

Lets say my table field Player has one, two, three in the db.

This script outputs this

No Match one Not in DB
No Match two Not in DB
No Match four Not in DB
No Match five Not in DB
Match three IN DB

if I change from == to = and !== to !=

I just see ($name matched to $checkname) from the last row Match three in DB repeated

I know I the compared operator is wrong or the compared variables are wrong. I know the loop is also an issue.

What My goal is, compare all $names in the foreach loop to the db Player fields, then list the following

If (the values of $name match a db record) {
echo Match $name)
}
if (the values of $name dont match any db record) {
echo "no match for $name";
}

I used to be better at this some years ago.. sigh...

Cheers,

Bimmer

[bpat1434]

why not just do it in one SQL statement:

SELECT Player, IP, UniqueID 
FROM ".$xoops->prefix('PlayersTOSERV')."
WHERE 

at this point, you'd loop through all the $matches values, and create a "dynamic query".

$query = "SELECT Player, IP, UniqueID
FROM ".$xoops->prefix('PlayersTOSERV')."
WHERE ";
$i = 0;

foreach($matches as $key => $val)
{
  if($i>0){ $query .= " OR";
  $query .= " Player LIKE '%".$key."%'";
  $i++;
}
echo "<!--\n".$query."\n-->";

// now go on and do your query.... 
//then just loop through the results, as they should be all matches....