[RESOLVED] Display grid with unknown number of rows and columns

[scrupul0us]

I have a database table full of geometric point data (postgres 'point' type field) stored in Y,X format:

SELECT name,type, coord[0] as posx, coord[1] as posy FROM grid order by coord[0], coord[1] asc

Since each "grid" will have multiple rows and columns, whats the best way to output the data?

Thanks =)

[scrupul0us]

fwiw I'm using this currently:

$currX = 0;
$lastX = 0;
while ($row = pg_fetch_array($result))
{
        $currX = $row['posx'];
        if($currX == $lastX)
        {
                echo $row['name'];
        }
        else
        {
                echo '<br/>';
                echo $row['name'];
        }
        $lastX = $row['posx'];
}

I just don't like having to set the initial values to 0 as I can't guarantee those will always be the "starting point" for a grid

[scrupul0us]

Annd I'm just realizing my data points are really Y,X instead of X,Y...

Le sigh

Consider this thread shamefully resolved