How to mySQL query based on matching column values?

Question

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>";
    }

mellamokb · Accepted Answer · 2012-07-05 20:16:18Z

2

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

answered Jul 5, 2012 at 20:16

mellamokb

56.8k12 gold badges111 silver badges138 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

myom Over a year ago

I edited my code above, but the while loop only outputs the courses from $endsem1, but not $startsem1.

Ujjwal Prajapati Over a year ago

try using alias for the column value like select s.id as sid, e.id as eid, that way might help you.

pamil · Accepted Answer · 2012-07-05 20:16:38Z

0

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

answered Jul 5, 2012 at 20:16

pamil

9802 gold badges10 silver badges20 bronze badges

Collectives™ on Stack Overflow

How to mySQL query based on matching column values?

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related