[RESOLVED] To many results

jerrylouise

With my code im getting to many results it keeps printing out the catagory for every title instead of just one catagory and its titles.
http://www.dev.cossycomforts.com/forum.php

<?
include("include/session.php");
$sql = "SELECT s.`id`, s.`catagory`, c.`title`, c.`about` FROM `forum-catagory` AS `s` LEFT JOIN `forum-topics` AS `c` ON s.`id` = c.`catagory_id` ORDER BY s.`id`";
$result = mysql_query($sql) or die("Query failed($sql): " . mysql_error()); 
   print '<table width="100%" border="0" cellpadding="4" cellspacing="1" >';
print '<tr><td width="70%">Forum</td><td width="15%">Topics</td><td width="15%">Posts</td></tr>'; 
WHILE($row = mysql_fetch_array($result)) {
	printf("<tr><td><font size=\"+2\" color=\"#ee103a\">%s" . "</font><td><td></td></tr>", $row["catagory"]);
	printf("<tr><tr><td>%s" . "</td>", $row["title"]);
	print("<td>1</td><td>1</td></tr>");
	printf("<tr><tr><td>%s" . "</td><td></td><td></td></tr></tr>", $row["about"]); 
}
print '</tr>';
print '</table>'; 
?>

bradgrafelman

You could have another variable that keeps track of what category was last displayed. That way, on each iteration through the loop, you'd see if the row's category is different from the last displayed category. If it is, output the category information. If not, don't.

Example:

$last_cat = '';
WHILE($row = mysql_fetch_array($result)) {
    if($row['catagory'] != $last_cat) {
        $last_cat = $row['catagory'];
        printf("<tr><td><font size=\"+2\" color=\"#ee103a\">%s" . "</font><td><td></td></tr>", $row["catagory"]);
    }
    // rest of code here

}

By the way, did you know you misspelled "category" ?

jerrylouise

thanks, now i can move on to the next stage.

bradgrafelman

Don't forget to mark this thread resolved.