ok, so i assume that customers is a grouping of some sort and that in
some cases you may come accross a row like "Staff | John | A36 |LA ".
It may not be a perfect way of doinig it but this is what i would
generally try:
while ($row = mysql_fetch_array($resultset, MYSQL_NUM)){
if($row[0] == $group){
echo" $row[1] | $row[2]";
}
else{
echo"$row[0]<br/><br/>$row[1] | $row[2] | $row[3]";
}
$group = $row[0];
}
Ade
Danny wrote:
Thanks for your help Adrian, but the problem is that I need to show
row[0] once (Customers text are repeated), and below the details of
the records
Your solution shows:
Customers | John | A36 | New York
Customers | Jason | B45 | Los Angeles
(...)
And I need
Customers<BR>
John | A36 | New York
Jason | B45 | Los Angeles
(...)
(...)
On 10/27/05, *Adrian Bruce* <abruce@xxxxxxxxxxxxxxx
<mailto:abruce@xxxxxxxxxxxxxxx>> wrote:
load each row of the resultset into an array $row using
mysql_fetch_array(), each field in the result set row will be
held in
the corresponding array element.
while ($row = mysql_fetch_array($resultset, MYSQL_NUM)){
echo"$row[0] | $row[1] | $row[2]";
}
Hope this helps,
Ade
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.
>--
>
>
>
--
PHP General Mailing List ( http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
dpc
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
