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
