Hi Dave,
I wrote the following script which does exaclty that.
Cami
<?
mysql_connect ($hname, $usrname, $password) OR DIE ("unable to connect");
$selectstmnt = "your sql statement";
$result = mysql_db_query ($dbname, $selectstmnt);
$numrows = mysql_num_rows($result);
$i=3;
echo "<table cellpadding=0 border=0 callspacing=0>";
if ($result) {
while ($list = mysql_fetch_array ($result))
{
if($i==3) { $i=0;
echo "<tr>"; }
echo "<td width=\"126\" height=\"23\" valign=\"middle\"
align=\"center\">".$list["yourvariablename"]."</td>";
$i++;
if($i==3) {
echo "</tr>"; }
} // end while fetch_array
if ($numrows%3==2){echo "<td> </td></tr>";}
if ($numrows%3==1){echo "<td> </td><td> </td></tr>";}
} //end if numrows>0
echo "</table>";
?>
-----Original Message-----
From: Greg Donald [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 18, 2002 2:14 PM
To: Dave Carrera; php List
Subject: Re: [PHP-DB] I cant get the logic for this...
> I want to display return results from my query (which works fine)
> In I tidy way on screen.
>
> So my result returns say seven results, I have a table, and I want to
> show
> 3 results per row of the table... I.e.:
>
> Table
> TR
> TD = result1 /TD TD result2 /TD TD = result3 /TD
> /TD
> /TR
> TR
> TD = result4 /TD TD result5 /TD TD = result6 /TD
> /TD
> /TR
> TR
> TD = result7 /TD TD resultempty /TD TD = resultempty /TD
> /TD
> /TR
> /table
>
> The last two td in row 3 are empty because result found 7 results.
>
> This cant be fixed so echo statements wont work as the result could
> Be 3 or 10 or 56 or whatever.....
>
> As Always your help and or guidance in this matter is appreciated.
You need a incrementer variable so you can tell when you have 3 <td> cells
built, so you know when to end the current <tr> and start a new one.
Then, you need to test that variable again when you run out of
mysql_num_rows(), and fill the 1 or 2 needed <td> cells with
Also, you might wanna look around for some table building classes if your
data is always gonna be really abstract.
------------------------------------------------------------------------
Greg Donald - http://destiney.com/
http://phprated.com/ | http://phplinks.org/ | http://phptopsites.com/
------------------------------------------------------------------------
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
