Posted by Geoff Berrow on 07/29/05 17:18

I noticed that Message-ID:
<1122637460.994585.275610@g47g2000cwa.googlegroups.com> from
guitarromantic@gmail.com contained the following:

>thanks for the code, but all it does it display a table of images one
>by one in rows.. not what I need. I know theoretically what I need to
>do (count the number of rows returned, and every three rows or so, echo
>a "</td><td>") but I don't know how to actually code it.

Probably not the most elegant way but...

$result=mysql_query($sql);

$row[0]="";
$columns=3;
$i=0;
$j=0;
print "<table>\n";
while($myrow=mysql_fetch_array($result)){

if($i==0 || $i%$columns!==0){
$row[$j].=" <td>".$myrow['Make']."</td>\n";
$i++;
}
else{
$j++;
$row[$j]="";
$row[$j].=" <td>".$myrow['Make']."$j</td>\n";
$i++;
}
}
while($i%$columns!==0){
$row[$j].=" <td>&nbsp;</td>\n";
$i++;
}
foreach($row as $value){
print " <tr>\n$value </tr>\n";
}
print"</table>";

--
Geoff Berrow (put thecat out to email)
It's only Usenet, no one dies.
My opinions, not the committee's, mine.
Simple RFDs http://www.ckdog.co.uk/rfdmaker/

• Next in forum: Re: Newbie: How do I test for "reposting" a form to itself?
• Prev in forum: Re: Passwording a MySQL Database
• Thread view: Re: displaying a varying number of images.. in tables?!

[Reply to this message]