CODEWITHSUNDEEP
phpmysql
myom
myom

Reputation: 135

How to mySQL query based on matching column values?

I want the while loop to output based on matching column value of "id".

    $query = "SELECT s.id,s.last,s.first,s.course1,s.course2,s.course3
            ,e.id,e.last,e.first,e.course1,e.course2,e.course3
            FROM $startsem1 s
            JOIN $endsem1 e on s.id = e.id";
    $result = mysql_query($query) or die(mysql_error());

    while ($row = mysql_fetch_assoc($result))
    {
         print_r($row); echo "<br><br>";
    }

Upvotes: 0

Views: 170

Answers (2)

pamil
pamil

Reputation: 980

You use binary operator &, not logical && in the while loop condition.

Upvotes: 0

mellamokb
mellamokb

Reputation: 56769

Use a join:

SELECT s.id,s.last,s.first,s.course1,s.course2,s.course3
      ,e.id,e.last,e.first,e.course1,e.course2,e.course3
  FROM $startsem1 s
  JOIN $endsem1 e on s.id = e.id

Upvotes: 2

Related Questions