|
|
Posted by leader on 03/31/07 07:14
I'm trying to list meteorological data reports, from an ever-varying
number of locations, in two columns, side-by-side - the first half of
the list alphabetically in the left column and then the second half in
the right column. In the example below, numbering the locations for
the purpose of the example, it has to be something like this, using,
say, 60 locations -
$Query="SELECT * FROM obervations order by location";
$Result=mysql_db_query ($DBName, $Query, $Link);
while ($Row=mysql_fetch_array ($Result))
(
<table>
<tr>
<td>$Row[location1] $Row[humidity1] $Row[oktas1]</td>
<td>$Row[location31] $Row[humidity31] $Row[oktas31]</td>
</tr>
<tr>
<td>$Row[location2] $Row[humidity2] $Row[oktas2]</td>
<td>$Row[location32] $Row[humidity32] $Row[oktas32]</td>
</tr>
</table>
and so on until the database is exhausted.
I've tried using arrays to store each data item but I think it's
clumsy. Is there a more elegant way to do it?
TIA.
Navigation:
[Reply to this message]
|