Posted by tomasz abramowicz on 10/08/31 11:30

if your db is built correctly you could use
UNION or JOIN(S) to build the correct query.
otherwise look into DISTINCT(ROW) and/or creating
temporary tables.
formatting the info later is, as adrian illustrated,
up to you.

t.

ps. all the above depends on your mysql server version and
configuration.

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