RE: Sepating MySQL result set into html tables

[admin@xxxxxxxxxxxxxxxxxxx]

Might I suggest you count the fields and divide it by the cols you want to display? 
Example
$forest = mysql_query("SELECT * FROM your_table");
$gump = mysql_num_fields($forest);

Because I know my table contains 15 rows I can do this.
$tulip = floor($gump /5);
I know how many fields to display before a row break.
May seems extremely simple but works very well for me.



Hello everybody,
    I have a mysql result set that I want to print out in an html table. 
But some times it gets so big that I will probably need to separate it 
in to multiple ones. I wrote a function that separates the result set 
into three ones like this:

function showTable($columnNames,$data,$alignment,$wrap) {
   
    $limit = round(count($data)/3,0);
   
    $align = 
array('l'=>'align="left"','c'=>'align="center"','r'=>'align="right"');

    $table = "<table class='inner'>";


    $table .= "<table><tr><td><table class='inner'>";

    $table .= "<tr>";
    foreach ($columnNames as $col_name){
        $table .= "<th>".$col_name."</th>";
    }
    $table .= "</tr>\n";

    foreach ($data as $j => $row) {

        if(($j % 2) == 0){
            $table .= "<tr class=even>";
        } else {
            $table .= "<tr class=odd>";
        }
        for($i=0;$i<count($row);$i++){

            $table .= "<td ".$wrap." 
".$align[$alignment[$i]].">".$row[$i]."</td>";

        }

        $table .= "</tr>\n";

        if (($j == $limit-1) || ($j == (2*$limit)-1)) {
            $table .= "</table></td><td><table>";
            $table .= "<tr>";
            foreach ($columnNames as $col_name){
                $table .= "<th>".$col_name."</th>";
            }
            $table .= "</tr>\n";
        }
    }
    $table .= '</table></td></tr>';
    $table .= "</table>\n";
    print $table;
}


But I really need to tell the function in how many tables I need the 
result set to be separated. How can I do this?

What can I put instead of this for 3 tables: (($j == $limit-1) || ($j == 
(2*$limit)-1))

I can't find the algorithm although I think I have done this before but 
I can't remember how.

-- 
Thodoris


-- 
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