Re: Detailed Report

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Not sure whether this would be such a good idea. Does anybody else have a better one than this?

#main loop, gather distinct / unique category names
$sqlstmt = "select distinct(category) as category from table";
$rs = mysql_query ($sqlstmt);
while ($row = mysql_fetch_object ($rs)) {
  print $row->category . "\n";         # output Customers / Providers
  $sqlstmt1 = "select name, code, city from table";
  $rs1 = mysql_query ($sqlstmt);
  # inner loop, display those which category is from the main loop
  while ($row1 = mysql_fetch_object ($rs1) {
print $row1->name . '-' . $row1->code . '-' . $row1->city . "\n'; # output John - A36 - City
  }
}


Danny wrote:

Hi All,
I´ve got a connection, to a MySQL db, and get the following
ResultSet(Category | Name | Code | City)
Customers | John | A36 | New York
Customers | Jason | B45 | Los Angeles
Customers | Max | A36 | Paris
Providers | John | A36 | London
Providers | Mark | B67 | Madrid
And I need the report in the following format:
Customers
John - A36 - New York
Jason - B45 - Los Angeles
Max - A36 - Paris
Providers
John - A36 - London
Mark - B67 - Madrid
Any one can help? I´m a bit stalled
thx
regards.



--
Best Regards,

Shahmat Dahlan
Research and Development
SAINS

Mobile: (60)16 882 6130
Office: (60)82 426 733 ext 5512

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux