2 column, alphabetical sort

[MystedVeil]

I am currently using this to pull up the area list:

$cols = 2; // how many cols you want

$result2 = mysql_query("SELECT geography_area.*  FROM geography_area WHERE zone_id = $row[zone_id] ORDER BY area  ASC");
echo mysql_error();  

if (mysql_num_rows($result2)) 
for($i=1;$row = mysql_fetch_array($result2);$i++)
{
    if($i==1)
    {
        echo "<TR>";
    }
    echo"<td valign=top width=50%>" . $row['area'] . "</td>";
    if($i==$cols)
    {
        echo "</TR>";
        $i=0;
    }
}
if($i!=1)
{
    echo "</TR>";
}

The problem I am having is it is listing the results as

A A
B B
C C

How I want it to appear is:
A B
A C
B C

[Installer]

Try this:

$cols = 2; // how many cols you want
$result2 = mysql_query("SELECT geography_area.*  FROM geography_area" .
                       "WHERE zone_id = $row[zone_id] ORDER BY area  ASC"); 
echo mysql_error();
if (mysql_num_rows($result2) {
    while ($row = mysql_fetch_array($result2)) {
        $array[] = $row['area'];
    }
    $table_rows = ceil(count($array) / $cols);
    echo '<table>';
    for ($i = 0; $i < $table_rows; $i++) {
        echo '<tr>';
        for ($j = 0; $j < $cols; $j++) {
            $key = $i + ($j * $table_rows);
            if ($key < count($array)) {
                echo '<td>' . $array[$key] . '</td>';
            } else {
                echo '<td>&nbsp;</td>';
            }
        }
        echo '</tr>';
    }
    echo '</table>';
}

[zx9]

TNKZ Installer ... i googled it for 4 hours..to find this function.. :mad: :mad:

PHP.net...
Others manuals.....

but heare is my solution... i change few lines to my proyect ...and VOILE!!!🙂 🙂

tnkz

[bradgrafelman]

Don't forget to mark this thread resolved (if it is).