Posted by Adrian Bruce on 10/20/68 11:30

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@stvincent.ac.uk
> <mailto:abruce@stvincent.ac.uk>> 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

[Back to original message]