two querys - if Id match do this...

[sgtpepper]

I guys...I am trying to setup a simple if statement based on two queries. I am trying to find Id's that match based on two queries. If they match, than I want to assign a value to a variable. If they dont....do nothing.

Is this the correct way to structure the if statement?

if($row['Id'] = $row2['Id'] )
{
$new = "Match";
}
else
{
}

[focusbeam]

u need one more "=" sign(marked in red) and if "else" is to do nothing, then u can simply not write it
if($row['Id'] == $row2['Id'] )
{
$new = "Match";
}

[The_Chancer]

Nearly but not quite...

There is a difference between

==

x=1; sets X to 1

x==1; is x equal to 1

So...

if($row['Id'] == $row2['Id'] )
{
$new = "Match";
}
else
{
}

Would be the one you want...

[sgtpepper]

That seemed to solve that particular problem....but maybe I am still not getting the results I am hoping for. It seems that the code never 'sees' the match.....is it because they are placed in a loop before they get to the if statement.

Example:

///////////// This gets date info ---> $row2 //////
$query2="SELECT Id from mastertable WHERE p_mod_date_time > '2004-04-25 10:00:18'";

$result2=mysql_query($query2) or die (mysql_error());
$num2=mysql_numrows($result2);

if(mysql_numrows($result2) == '0') {
   echo "Sorry, no results were found...";
} else {
  // display results here
}
while ($row2 = mysql_fetch_array($result2)) // this will grab the results from query
{
$wang = $row2[Id];
}

I also have $chung = $row[Id]; coded in the same fashion as above.

So.... this:

if($chung == $wang )
{
$new_prop = "Match";
}
else
{
}

Doesnt seem to get a match. I know this is probably confusing, but I couldnt get any Id values unless they were in a loop. Any ideas on what else I could do?

All I am trying to do is get the results of SELECT Id from mastertable WHERE p_mod_date_time > '2004-04-25 10:00:18' and displaying an output of a valiable if it excisits.

[The_Chancer]

You need to put the if condition in the while loop...

///////////// This gets date info ---> $row2 //////
$query2="SELECT Id from mastertable WHERE p_mod_date_time > '2004-04-25 10:00:18'";

$result2=mysql_query($query2) or die (mysql_error());
$num2=mysql_numrows($result2);

if(mysql_numrows($result2) == '0') {
   echo "Sorry, no results were found...";
} else {
  // display results here
}
while ($row2 = mysql_fetch_array($result2)) // this will grab the results from query
{
    if ($row2['Id']==$chung)
    {
             echo "Match";
    }
}