如果它们的行相等，则比较两个表

Question

I have three tables.

deliverable_category deliverable passed_deliverable

i want to compare these two tables(deliverable & passed_deliverable),check if thier number of rows of thesame deliverable category is equal.

here is what i have :

  $query2=mysql_query("SELECT * FROM deliverable WHERE deliverable_category_id=3 ");
   if($row2=mysql_num_rows($query2)>0){
     $query3=mysql_query("SELECT * FROM passed_deliverable WHERE deliverable_category_id=3"); 
   }
    if($row3=mysql_num_rows($query3)>0){
      if ($row2=$row3){
        echo "EQUAL ";
    } 
      }
       else { 
        echo "NOT EQUAL "; 
       }

Answer 1

"Wow, it worked. thanks for the answer Mr. @Fred-ii- – Mark Yu"

You're presently assigning = instead of comparing == with if ($row2=$row3)

Change that to if ($row2==$row3).

• http://php.net/manual/en/language.operators.assignment.php
• http://php.net/manual/en/language.operators.comparison.php