|
|
Posted by Jerry Stuckle on 12/14/06 20:03
Advo wrote:
> Hi there.
>
> Im trying to generate a table and its content from a database, and
> display it 5 products across, and as many rows as it needs down.
>
> Ive kind of done this, but the products are being listed like:
>
> Name Name Name Name Name Name Name Name Name Name
>
> Image Image Image Image Image Image Image Image Image Image
>
> descr descr descr descr descr descr descr descr descr descr descr
>
>
> so theyre going across the page for ever and ever, rather than
>
> Name Name Name Name Name
>
> Image Image Image Image Image
>
> Descr Descr Descr Descr Descr
>
> Name Name Name Name Name
>
> Image Image Image Image Image
>
> Descr Descr Descr Descr Descr
>
>
> if that makes sense. Any ideas please, im pretty stuck. The code is:
>
> for ($i = 0;$i< 5; $i++) {
> $j++;
>
> $name .= '<td style="padding-bottom: 3px;">'.
> $array_category_name[$i] . '</td>';
> $imagename .= '<td>'. '<img src="images/'
> .$array_category_image_name[$i] . '" width="74" height="59">' .
> '</td>';
> $description .= '<td>'. $array_category_description[$i] . '</td>';
>
> }
> echo '<table width="100%" border="0" align="center" cellpadding="0"
> cellspacing="0">';
> echo "<tr align=\"center\">$name</tr>";
> echo "<br>";
> echo "<tr align=\"center\">$imagename</tr>";
> echo "<tr align=\"center\">$description</tr>";
> echo "<tr align=\"center\"><td collspan='3' </td></tr>";
> echo "</table>";
>
First of all, do you want one table with many rows, or many tables?
Your code (if it worked properly) would create many tables (the <table
statement is within your loop).
Assuming you want one table with multiple rows, there are several ways
to do it. The easiest is probably to just add a new row every time you
get another 5 items (warning - not tried, may contain syntax errors!):
echo '<table width="100%" border="0" align="center" ' .
'cellpadding="0"' cellspacing="0">';
$name = $imagename = $description = '';
// Assuming all arrays have the same # of elements
for ($i = 0;$i count($array_category_name); $i++) {
if (($i % 5) && ($name <> '')) { // Every 5th line except first
echo "<tr align=\"center\">$name</tr>\n";
echo "<tr align=\"center\">$imagename</tr>\n";
echo "<tr align=\"center\">$description</tr>\n";
$name = $imagename = $description = '';
}
$name .= '<td style="padding-bottom: 3px;">'.
$array_category_name[$i] . '</td>';
$imagename .= '<td>'.
'<img src="images/'.$array_category_image_name[$i] .
'" width="74" height="59">' . '</td>';
$description .= '<td>'. $array_category_description[$i] .
'</td>';
}
// Might have a partial last rows) - complete them
for ($i = count($array_category_names); $i % 5 > 0; $i++)
$name .= "<td> </td>\n";
$imagename .= "<td> </td>\n";
$description .= "<td> </td>\n";
}
if ($name <> '') { // If something left in it
echo "<tr align=\"center\">$name</tr>\n";
echo "<tr align=\"center\">$imagename</tr>\n";
echo "<tr align=\"center\">$description</tr>\n";
}
echo "</table>";
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
[Back to original message]
|