[PHP-DB] Re: Group By problem

2001-08-13 Thread Hugh Bothwell 


Sharif Islam [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
 I am trying to caregorize to group at the same time, but its not working.
 Any hints?
 Here's my code:
 $temp=Dummy;
 while ($row = mysql_fetch_array($result))
 {
  if($temp !=$row[group_name]){
  $temp=$row[group_name] ;
  echo bGroup:$tempbr/b;

 }

 $temp1=blah;
 if($temp1 !=$row[service_cat]){
 $temp1=$row[service_cat];
 echo Services:$temp1br;
 }
 $machine_name=$row[machine_name];
 echo a
 href=view_server.php?machine_name=$machine_name$machine_name/abr;
 }

 This is displaying :
 Group:Group_Name
 Services:Email
 Machine_Name
 Services:Email
 Machine_name2
 Services: Backup
 Machine_name
 Group:Group_name2
 ...
 I dont want to print services multiple times. Just like the group name
 catagorize it.

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

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]

Re: [PHP-DB] Re: Group By problem

2001-08-13 Thread Sharif Islam 


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]