Little help with layout of a print

jerrylouise

working on a little problem here during my print out i get the table headers every single time and the bottom is never printed.

UPDATE: the title now prints out as it is supposed to but the footer prints out to many times it is only supposed to print out once per category not once per result. i got the title and table to print out once per category but am finding it difficult to master the same with the bottom of the table.

	
					///start result//
$result = mysql_query($sql) or die("Query failed($sql): " . mysql_error());
/// logic to handle the last category  ///
$last_cat = '';
/// first counter for row colours/// 
$i = 0;
/// second counter for row colours /// 
$m = 0; 
/// start loop///
WHILE ($row = mysql_fetch_array($result)) { 
/// if statement for handleing category rows///
    if($row['category'] != $last_cat) { 
        $last_cat = $row['category']; 
////The title of the block element (the catagory)////
printf( "<div class=\"title\"><h3>%s" . "</h3></div>", $row["category"]);
}
/// printing the rest of the table////
print "<div class=\"content\"><div class=\"content_text\">";
/// if statement for handleing category rows///
    if($row['category'] != $tableish) { 
        $tableish = $row['category']; 
////The title of the block element (the catagory)////
print '<table width="100%" border="0" cellpadding="2" cellspacing="2" >';
print '<tr class="page_title"><td width="50%">Forum</td><td width="10%">Topics</td><td width="10%">Replies</td><td width="30%">Last Posted by</td></tr>'; 
}
if($i++ % 2) 
      { 
         print '<tr class="wight">'; 
      } 
      else 
      { 
         print '<tr class="other">'; 
      }
	printf("<tr><td><a href=\"forum_topic.php?id=%s&title=%s\">%s</a>" . "</td><td>%s" . "</td><td>%s" . "</td><td>%s" . "</td></tr>", $row["id"], $row["title"], $row["title"], $row["topiccount"], $row["replycount"], $row["lastpost"]);
/// the second row colour changer ////
    if($m++ % 2) 
      { 
         print '<tr class="wight">'; 
      } 
      else 
      { 
         print '<tr class="other">'; 
      }
	printf("<td><font size=\"-1\">%s" . "</font></td><td></td><td></td><td><font size=\"-1\">%s" . "<br /><a href=\"forum_topic_view.php?catagory=%s&title=%s&id=%s\">%s</a>" . "</font></td></tr>", $row["about"], $row["lastposttime"], $row["id"], $row["title"], $row["lastid"], $row["lasttopic"]); 

/// finish the table ///
//////////bit that needs to only be printed ones per catagory////
print '</table></div></div>';	
print '<div class="bottom_content"><div class="btm_text">Add me</div></div>';
}

rsmith

You should be using include() not readfile:

<?
     include("/pageblocks/header.php");
?>
     //Whatever other code goes here.
<?
     include("/pageblocks/login.php");
?>

Then it's on you to make sure any tables or divs line up.

jerrylouise

http://cossycomforts.com/ilustation.png

Little pic to show you were its going wrong.

BlueKai

Everything you have in the while loop executes for every single row of data you have. If you're wanting 'topics/replies/last posted by' to only print once, you need to do it before you start the loop. Along the same lines, make sure you 'finish table' after the loop.

It also looks like you have an extra closing bracket just under 'content ends' which could be causing you problems.

jerrylouise

well the way its supposed to work is for every category there is ment to be a table with the headings, then the results and the bottom of the element so i need to work out how to get to print out the bottom div and the table heading once for each element.

in the end its 4 categorys, each have a title, each have headings, each have content, and each have a footer. so it makes them look like little rectangles to fit into the site. been working at this more today and it really isnt working they way i want been so long since i last worked at this.

jerrylouise

Ok this is what i have so far, its a bit of a mess so perhaps some help with that but the main problem is the very last part of the table and end of div only needs to be printed out once however it is printing out everytime when i only want it printed the last time once only like i have the header and header text printing out once only.

/// logic to handle the last category  ///
$last_cat = '';
$head_table = '';
$nummmies = '';
/// start loop///
WHILE ($row = mysql_fetch_array($result)) { 
/// if statement for handleing category rows///
    if($row['category'] != $last_cat) { 
        $last_cat = $row['category']; 
////The title of the block element (the catagory)////
printf( "<div class=\"title\"><h3>%s" . "</h3></div>", $row["category"]);
}
/// printing the rest of the table////
print "<div class=\"content\"><div class=\"content_text\">";
/// if statement for handleing category rows///
    if($row['category'] != $head_table) { 
        $head_table = $row['category']; 
////The title of the block element (the catagory)////
print '<table width="100%" border="0" cellpadding="2" cellspacing="2" >';
print '<tr class="page_title"><td width="50%">Forum</td><td width="10%">Topics</td><td width="10%">Replies</td><td width="30%">Last Posted by</td></tr>'; 
}
/// first row ////
	printf("<tr><td><a href=\"forum_topic.php?id=%s&title=%s\">%s</a>" . "</td><td>%s" . "</td><td>%s" . "</td><td>%s" . "</td></tr>", $row["id"], $row["title"], $row["title"], $row["topiccount"], $row["replycount"], $row["lastpost"]);
/// second row ////
	printf("<tr><td><font size=\"-1\">%s" . "</font></td><td></td><td></td><td><font size=\"-1\">%s" . "<br /><a href=\"forum_topic_view.php?catagory=%s&title=%s&id=%s\">%s</a>" . "</font></td></tr>", $row["about"], $row["lastposttime"], $row["id"], $row["title"], $row["lastid"], $row["lasttopic"]); 

/// finish the table ///
//////////bit that needs to only be printed ones per catagory////
$nummmies = $row['category']; 
if($row['category'] == $nummmies) { 
////The title of the block element (the catagory)////
print '</table></div></div>';	 
print '<div class="bottom_content"><div class="btm_text">Add me</div></div>';
}
}