Not printing what i want it to print

jerrylouise

Ok this is the start of my sites forum system. But it only prints out one record and i cant get the two counters to work i cant it to display the post count and the reply count. 😕
_Database______
forum-catagory
id
catagory

forum-topics
id
catagory_id
title
about

forum-posts
id
topic_id
username
date
subject
post

forum-reply
id
posts_id
username
date
subject
post

................................
Forum..............................Topics.......Posts
About
..........Topic 1.....................1...............4...
decript
..........Topic 2.....................1...............4...
decript
..........Topic 3.....................1...............4...
decript
This and that
..........Topic 1.....................1...............4...
decript
..........Topic 2.....................1...............4...
decript
..........Topic 3.....................1...............4...
decript
................................

<?
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.`id` COUNT(d.`topic_id`) AS `ct` FROM `forum-posts` e LEFT JOIN `forum-topics` e  ON e.`id`= d.`topic_id`";
$result = mysql_query($sql) or die("Query failed($sql): " . mysql_error()); 
if(mysql_num_rows($result)) 
{ 
   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)) {
      //the output// 
      printf("<tr><tr><td><font size=\"+2\" color=\"#ee103a\">%s" . "</font><td></tr>", $row["catagory"]);
 printf("<tr><tr><td>%s" . "</td>", $row["title"]);
 printf("<td>1</td><td>1</td></tr>");
 printf("<tr><tr><td>%s" . "</td></tr></tr>", $row["about"]);
   }   

   print '</tr></table>'; 
} 
?>

sheephat

should there not be a loop in there?

jerrylouise

sheephat wrote:
should there not be a loop in there?

lol i dono

jerrylouise

<?
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` GROUP BY s.`id`";
$result = mysql_query($sql) or die("Query failed($sql): " . mysql_error()); 
   print '<table width="100%" border="1" 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><tr><td><font size=\"+2\" color=\"#ee103a\">%s" . "</font><td><td></td></tr>", $row["catagory"]); 
WHILE($row = mysql_fetch_array($result)) {
	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>'; 
?>

This prints out one compleat row but still missies out the rest of the table

blackhorse

embed the php codes into html tags, instead of use php to print out the full html tags, that will make your code more readable.

run your sql directly in the database to see if it works first.

jerrylouise

i think its something to do with the loops cos if i move them arround i get diffrent results.

blackhorse

you have the while loop inside while loop, and the first outside while loop will fetch first array and print the the category, and then the inside while loop will loop out the results, and print the title etc. only. So the results is that the first array will be print with category of the first array and title of the second array, and the rest arrays will print without the category.

jerrylouise

so how do i go about correcting this loop inside a loop.

jerrylouise

<?
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` GROUP BY s.`id`";
$result = mysql_query($sql) or die("Query failed($sql): " . mysql_error()); 
   print '<table width="100%" border="1" 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><tr><td><font size=\"+2\" color=\"#ee103a\">%s" . "</font><td><td></td></tr>", $row["catagory"]);
$arr=array("one", "two", "three");
foreach ($arr as $value)
{
	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>'; 
?>

okies i done a little extra coding, so it now prints out all the catagorys and but the same title 3 times over. i suck at loops.

jerrylouise

more failed attempts.

PHP Code:

<?
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` GROUP BY s.`id`";
$result = mysql_query($sql) or die("Query failed($sql): " . mysql_error()); 
   print '<table width="100%" border="1" 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><tr><td><font size=\"+2\" color=\"#ee103a\">%s" . "</font><td><td></td></tr>", $row["catagory"]);
$arr= mysql_fetch_array($result);
foreach ($arr as $value)
{
    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>'; 
?>

jerrylouise

new almost working attempt. ok so now it is printing out all the results. however it keeps printing out the catagory like this.

catagory
title 1
catagory
title 2
catagory 2
title 1
catagory 2
title 2

instead of this

catagory
title 1
title 2
catagory 2
title 1
title 2

<?
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.`catagory`";
$result = mysql_query($sql) or die("Query failed($sql): " . mysql_error()); 
   print '<table width="100%" border="1" 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><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>'; 
?>