Multiple query data into single HTML Table (PHP, MySQL)

ismael66

New Member
Here is my current code. I'm trying to display data from three separate queries into a single table with multiple columns. Is my while statement wrong here? It's printing 1 table data, then the one after, instead of next to it in the same row.\[code\]echo "<table border='1'><tr><TH COLSPAN=2>July 2010</TH><TH COLSPAN=2>August 2010</TH><TH COLSPAN=2>September 2010</TH></tr><tr><th>User</th><th>Posts</th><th>User</th><th>Posts</th><th>User</th><th>Posts</th></tr>";while (($row = mysql_fetch_assoc($july)) || ($row2 = mysql_fetch_assoc($aug)) || ($row3 = mysql_fetch_assoc($sept))) {echo "<tr>";echo "<td>" . $row['cUsername'] . "</td>";echo "<td>" . $row['postCount'] . "</td>";echo "<td>" . $row2['cUsername'] . "</td>";echo "<td>" . $row2['postCount'] . "</td>";echo "<td>" . $row3['cUsername'] . "</td>";echo "<td>" . $row3['postCount'] . "</td>";echo "</tr>";}echo "</table>";\[/code\]
 
Back
Top