Thanks Jonathan,
I'll have a go with your codes.
Thanks very much
awlad
----- Original Message -----
From: "Jonathan Pitcher" <[EMAIL PROTECTED]>
To: "Awlad Hussain" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, March 03, 2003 4:17 PM
Subject: Re: [PHP] Automatic Table Creation
> Awlad,
>
> I would guess you are trying to create an HTML table to display the
> records.
>
> $Row = The results returned from. mysql_fetch_array().
>
> $Total = count($Row);
>
> $TotalInEachRow = round(($Total/3));
>
> if (($TotalInEachRow * 3) < $Total) {
> $TotalInEachRow ++; // Planning for the Remainder items.
> }
>
> $HTML = "<TABLE>"; // HTML string that holds the table
>
> $ColumnCount = 0; // For knowing the Number of Columns.
>
> for ($C=0; $C<$Total; $C++) {
> if ($ColumnCount == 0) {
> $HTML .= "<TR>";
> }
> $HTML .= "<TD>".$Row[$C]["DatabaseFeildName"]."</TD>":
> $ColumnCount ++;
> if ($ColumnCount == 3) {
> $HTML ."</TR>";
> $ColumnCount = 0;
> }
> }
>
> if ($ColumnCount > 0) {
> for ($C=$ColumnCount; $C<=3; $C++) {
> $HTML .= "<TD> </TD>";
> }
> $HTML .= "</TR>";
> }
>
> $HTML .= "</TABLE>":
>
> That should do it for you. I typed this code directly into the email so
> be forwarned about copy and pasting it.
>
> Hope this helped.
>
> Jonathan Pitcher
>
>
> On Monday, March 3, 2003, at 08:58 AM, Awlad Hussain wrote:
>
> > I have a mysql table containing about 100 record, alphabetically
> > ordered.
> >
> > How would i display them in browser in a 3 columns, doesn't matter how
> > long the rows is as the number of records will grow in the database
> > table.
> >
> > the records should be in alphabetically order, for example:
> >
> > aaa bbba ccca
> > aab bbbb cccb
> > aac bbbc cccc
> > aad bbbd cccd
> >
> > any idea anyone?
> >
> > awlad
> > _______________________________________________________________________
> >
> > Sheridan Phoenix Company
> > The Business Centre Kimpton Road Luton Bedfordshire LU2 0LB
> >
> > Email: [EMAIL PROTECTED]
> > Phone: 01582 522 330
> > Fax: 01582 522 328
> > _______________________________________________________________________
> >
> > This electronic transmission is strictly confidential and intended
> > solely for the addressee. If you are not the intended addressee, you
> > must not disclose, copy or take any action in reliance of this
> > transmission. If you have received this transmission in error it would
> > be helpful if you could notify The Sheridan Phoenix Company Ltd as soon
> > as possible.
> >
> > Any views expressed in this message are those of the individual sender,
> > except where the sender specifically states them to be the views of The
> > Sheridan Phoenix Company Ltd.
> >
> >
> >
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
