----- Original Message -----
From: "Sharif Islam" <[EMAIL PROTECTED]>
To: "Hugh Bothwell" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, August 13, 2001 11:50 AM
Subject: Re: [PHP-DB] Re: Group By problem
> But its displaying the same as my code:
The SQL was just for reference, to make sure
we were both working on the same basis...
I don't think you looked at the PHP code I gave,
as it should produce exactly what you are asking for.
> Group:Desktop
> Service:BACKUP
> AITSBKUP
> Service:E-Mail
> AITSMAIL
> JEEVES
> Group:Unix
> Service:Database
> APOLLO
> Service:FIREWALL
> Console
try defining
<style>
body {
font-family: Verdana, Arial, sans-serif;
}
.group {
font-weight: bold;
font-size: 120%;
color: #000044;
}
.service {
font-weight: bold;
color: #000077;
}
.machine {
font-size: 80%;
color: #770000;
}
</style>
<?php
function PrintNewGroup($grp) {
echo "<br>\n<span class='group'>$grp</span>";
}
function PrintNewService($svc) {
echo "<br>\n\t<span class='service'>$nbsp;$svc</span><br>";
}
function PrintMach($mach, $first) {
if ($first)
echo " "
else
echo " | ";
echo "<span class='machine'>$mach</span>";
}
?>
> > $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;
> > }
How's that?
--
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]