Re: results to html table

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Sun, 2007-08-12 at 08:07 +1000, Kevin Waterson wrote:
> I wish to get a result set into a html table.
> normally this is not a problem. 
> But I wish to use one of the results as a heading.
> 
> Here is the data... ASCII art warning
> +----------------+------------------+-----------------+---------------+
> | forum_group_id | forum_group_name | forum_type_name | forum_type_id |
> +----------------+------------------+-----------------+---------------+
> |              1 | Administration   | Photography     |             1 |
> |              1 | Administration   | Site Issues     |             3 |
> |              1 | Administration   | Test            |             4 |
> |              2 | General          | Modelling       |             2 |
> |              2 | General          | foo             |            10 |
> |              2 | General          | bar             |            11 |
> +----------------+------------------+-----------------+---------------+
> The goal is to produce HTML tables like this..
> +----------------+
> | Adninistration |
> +----------------+
> | Photography    |
> +----------------+
> | Site Issues    |
> +----------------+
> |    Test        |
> +----------------+
> +----------------+
> |   General      |
> +----------------+
> |  Modelling     |
> +----------------+
> |     foo        |
> +----------------+
> |     Bar        |
> +----------------+

<?php

$data = array();
while( ($row = mysql_fetch_assoc( $result )) )
{               
    $data[$result['forum_group_name']][] = $result;
}                                                  

foreach( $data as $forumName => $types )    
{                                        
    echo '<table>'
        .'<tr>'
        .'<th>'
        .$forumName
        .'</th>'
        .'</tr>';
 
    foreach( $types as $type )
    {
        echo '<table>'
            .'<tr>'
            .'<td>'
            .$type['forum_type_name']       
            .'</td>'
            .'</tr>';
    }   
 
    echo '</table>';
}

?>

Cheers,
Rob.
-- 
...........................................................
SwarmBuy.com - http://www.swarmbuy.com

    Leveraging the buying power of the masses!
...........................................................

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux