Simple (?) html output question

[Anon]

Hi,

I've got a script that pulls some recordsets from a mysql db. The results get put into an array, then I have a loop that outputs the html table containing the array variables one result per html table row.

My question is how to I get two results per html row? Example:

<TABLE CELLSPACING="2" CELLPADDING="2" BORDER="0">

<?php
if (mysql_num_rows($filelist) > 0) {
while ($f = mysql_fetch_array($filelist)) {
?>

<TR>
<TD><?=$f["prod_name"]?></TD> (This should be prod_name from first db row)
<TD><?=$f["prod_name"]?></TD>(This should be prod_name from second db row)
</TR>

<?php
}
}
?>
</TABLE>

As each page will be LIMITed to 4 results I need the above html row to loop and be populated with the third and fourth db row's particular value.

Thanks,
Ian Lalonde

[slug58]

give something like this a try it may suit your needs or give you an idea of how you could do it, or even do it better.

good luck!!

---

<TABLE CELLSPACING="2" CELLPADDING="2" BORDER="0">

<?php
$i = 1;

if (mysql_num_rows($filelist) > 0) {
while ($f = mysql_fetch_array($filelist)) {
if($i%2 != 0){
?>

<TR>
<TD><?=$f["prod_name"]?></TD>
<?php
}
if ($i%2 == 0){
?>
<TD><?=$f["prod_name"]?></TD>
</TR>
<?php
}
$i += 1;
?>

<?php
}
}
?>
</TABLE>