foreach not producing desired result

[mellis95]

I have the following foreach that should output two rows, but only outputs the first result. Can someone help me see what I am missing?

 

Here is the query:

SELECT DISTINCT m.lname AS plname, m.fname AS pfname FROM tbl_schedule AS s LEFT JOIN members AS m ON m.id=s.id

 

Which outputs the following from the command line:

+---------+----------+

| plname  | pfname  |

+---------+----------+

| Boring  | David A. |

| Bateman | Megan    |

+---------+----------+

2 rows in set (0.00 sec)

 

Here is the foreach:

 

echo "<table class='petite'><tr>";

   foreach($result as $name){
echo "<th>" . $name . "</th>";
    	}
    	echo "</tr>";

 

Which outputs the following:

Boring David A.

 

Thank you in advance for the help.

 

Matt

 

[TeamCIT]

I don't think I'm understanding your problem, what is not displaying correctly? Is the second row not displaying?

[PFMaBiSmAd]

Each call to a mysql_fetch_xxxxx() instruction retrieves ONE row from the result set (like it states in the php documentation.) You would need to use the mysql_fetch_xxxxx instruction in a loop (like the examples in the php documentation show) to retrieve each row in a result set.

[mellis95]

Thanks PFMaBiSmAd. I was looking for the problem in the wrong place. The following code, per your suggestion, fixes the issue:

 while ($row = $query2->fetch(PDO::FETCH_ASSOC)) {
   foreach($row as $name){
  		echo "<th>" . $name . "</th>";
    	}
    	}
    	echo "</tr>";