php formatting queries

roach

Im looking for a way to format my query's a little better.

I have a table that has a server, item and time row.

Im using the query: select * from times order by server, time.

Basically, I have multiple servers all with different items and times .

I'm trying to find a way I can output the query so it would show each server as a header, then the time and item listed below it.

Kinda like:

SERVER1
00:01 ITEM1
02:02 ITEM2
03:03 ITEM3

SERVER2
00:04 ITEM4
02:05 ITEM5
03:06 ITEM6

Is there any way to do this without hardcoding the header? Someone point me in the right direction =)

thanks!
-r

raymie

Asuming that the database is MYSQL then there is no way to do this without PHP code.

What you need to do is keep track of the previous value of server and if it does not match the current value then output the header and set the prev value to the current value.

roach

Well the DB is Postgres. And, I do want to format this using PHP. I just need some tips on doing it =)

-r

raymie

Don't know postgres but the php would be similar to...

$prev = "";
do while (get data record)
{
if($prev != $server)
{
echo "$server <BR>";
$prev = $server;
}
echo $time." "$item."<BR>";
}

roach

k I think i get it. Ill try it out.

thanks for the tip =P

-r

raymie

Glad to hear it,

by the way, while I gave the example using <BR> you will get a better result using tables to format the rows.

ie (html for example only, not in valid PHP code format)

<table>
<tr><td colspan=2>SERVER</td></tr>
<tr><td>Time</td><td>Item</td></tr>
</table>

roach

raymie!!

Thanks for the tip.

I got it working and it looks very nice, exactly what i needed =)))

-r