Thanks for your reply
>
> You don't show your SQL, but I assume it's something like
> SELECT grp,svc,mach FROM table ORDER BY grp,svc,mach
>

Thats right.

But its displaying the same as my code:
---
Group:Desktop
Service:BACKUP
AITSBKUP
Service:E-Mail
AITSMAIL
Service:E-Mail
JEEVES
Group:Unix
Service:Database
APOLLO
Service:FIREWALL
Console
-----

I want it like this. Sorry if my previous email wasnt clear enough.

Group:Desktop
Service:BACKUP
AITSBKUP
Service:E-Mail
AITSMAIL
JEEVES
Group:Unix
Service:Database
APOLLO
Service:FIREWALL
Console


> then
> $grp="";
> $svc="";
> $firstmach = true;
> while ($row=mysql_fetch_array($result)) {
>     if ($grp != $row["grp"]) {
>         $grp = $row["grp"];
>         PrintNewGroup($grp);
>         $svc = "";    // force new-svc when switching groups
>     }
>
>     if($svc != $row["svc"]) {
>         $svc = $row["svc"];
>         PrintNewService($svc);
>         $firstmach = true;
>     }
>
>     PrintMach($row["mach"], $firstmach);
>     $firstmach = false;
> }
>
> Hope this helps...
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to