for loop help!
| From: | Kieran Hall | Date: | Thu, 03 Apr 2003 22:32:25 +0000 |
| Subject: | for loop help! | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-19278@lists.php.net to get a copy of this message | ||
I want to display information from my database in two columns. I run
into a problem when there are three records. Another table data cell is
produced containing template material. Does anyone know a quick
solution to this problem? Code below:
$cols = 2;
$cell_count = 0;
if($numrows < $cols){
$cells = $numrows;
}
else{
$cells = $cols;
}
$test = $numrows/$cols;
if($test <= 0){
$rows = 1;
}
else{
$rows = round($test);
}
for($i = 0; $i < $rows; $i++){
echo"<tr>";
for($j = 0; $j < $cells; $j++){
$r=$lower_news->fobject();
$l_news_id = $r->id;
$l_news_title = $r->title;
$l_news_date = $r->date;
$l_news_username = $r->username;
$l_news_image = $r->image;
$l_news_intro = $r->intro;
$l_news_views = $r->views;
echo"<td width=\"50%\" align=\"left\">\n";
echo"<table cellpadding=\"0\" cellspacing=\"0\">\n";
echo"<tr>\n";
echo"<td align=\"left\" valign=\"top\"><a
href=\"javascript://void(0)\" OnClick=\"NewsPic('News',
'$hse_root_web_addr"."news/picture.php?pic=$l_news_image')\"><img
class=\"news_headline\" width=\"64\" height=\"48\"
src=\"$hse_root_web_addr"."news/img/$l_news_image\" alt=\"Click for
bigger version!\" /></a></td>\n";
echo"<td valign=\"top\">\n";
echo"<table width=\"100%\" cellpadding=\"1\"
cellspacing=\"0\">\n";
echo"<tr>\n";
echo"<td align=\"left\" valign=\"top\"
class=\"lower_news_headline\"><a
href=\"$hse_root_web_addr"."news/?id=$l_news_id\">$l_news_title</a></td>
\n";
echo"</tr>\n";
echo"<tr>\n";
echo"<td align=\"left\"
class=\"info\"><b>Published:</b>
$l_news_date<br /><b>Author:</b> $l_news_username</td>";
echo"</tr>\n";
echo"</table>\n";
echo"</td>\n";
echo"</tr>\n";
echo"</table>\n";
echo"</td>\n";
}
echo"</tr>";
}
?>