| Henrik Hornemann 2005-10-27, 7:55 am |
| Hi,
Sorry about the stupid mistakes, should ofcourse have been:
$sqlstmt1 =3D "select category, name, code, city from table order by =
category";
$rs1 =3D mysql_query ($sqlstmt1);
$category=3D'';
while ($row1 =3D mysql_fetch_object ($rs1) {
if ($category !=3D $row1->category) {
$category =3D $row1->category;
Print($category."<br>");
}=09
Print($row1->name. '-' .$row1->code. '-' .$row1->city. "\n'); =20
}
Regards Henrik Hornemann
-----Oprindelig meddelelse-----
Fra: Henrik Hornemann [mailto:HEH@DNLB.DK]=20
Sendt: 27. oktober 2005 14:24
Til: php-db@lists.php.net
Emne: SV: [PHP-DB] Detailed Report
How about :
$sqlstmt1 =3D "select category, name, code, city from table order by =
category";
$categry=3D'';
while ($row1 =3D mysql_fetch_object ($rs1) {
if ($old_category !=3D $row1->category) {
$ category =3D $row1->category;
Print($category."<br>");
}=09
Print($row1->name. '-' .$row1->code. '-' .$row1->city. "\n'); =20
}
Regards Henrik Hornemann
-----Oprindelig meddelelse-----
Fra: Shahmat Dahlan [mailto:shahmatd@sains.com.my]=20
Sendt: 27. oktober 2005 12:29
Til: Danny
Cc: php-db@lists.php.net
Emne: Re: [PHP-DB] Detailed Report
Not sure whether this would be such a good idea. Does anybody else have=20
a better one than this?
#main loop, gather distinct / unique category names
$sqlstmt =3D "select distinct(category) as category from table";
$rs =3D mysql_query ($sqlstmt);
while ($row =3D mysql_fetch_object ($rs)) {
print $row->category . "\n"; # output Customers / Providers
$sqlstmt1 =3D "select name, code, city from table";
$rs1 =3D mysql_query ($sqlstmt);
# inner loop, display those which category is from the main loop
while ($row1 =3D mysql_fetch_object ($rs1) {
print $row1->name . '-' . $row1->code . '-' . $row1->city .=20
"\n'; # output John - A36 - City
}
}
Danny wrote:
>Hi All,
> I=B4ve 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=B4m a bit stalled
> thx
>regards.
>
> =20
>
--=20
Best Regards,
Shahmat Dahlan
Research and Development
SAINS
Mobile: (60)16 882 6130
Office: (60)82 426 733 ext 5512
--=20
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--=20
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
|