RE: [PHP-DB] I cant get the logic for this...
| From: | Cami | Date: | Mon, 18 Feb 2002 14:30:48 +0000 |
| Subject: | RE: [PHP-DB] I cant get the logic for this... | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-17025@lists.php.net to get a copy of this message | ||
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:greg@ascendantmedia.com]
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