Re: Detailed Report
| From: | Adrian Bruce | Date: | Thu, 27 Oct 2005 09:32:41 +0000 |
| Subject: | Re: Detailed Report | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-224716@lists.php.net to get a copy of this message | ||
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. --