Re: Detailed Report

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> 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