RE: [PHP-DB] export query
| From: | John W. Holmes | Date: | Thu, 16 Jan 2003 04:08:45 +0000 |
| Subject: | RE: [PHP-DB] export query | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-24891@lists.php.net to get a copy of this message | ||
> I need to essentially take a query and make it into a table. I'll
first
> settle for the ability to export the query into a text file, somehow
> delimited.
>
> Can anyone help me with this?
What have you done so far? Do you know how to make a table?
While($row = mysql_fetch_row($result))
{ echo
"<tr><td>{$row[0]}</td><td>{$row[1]}</td></tr>"; }
etc...
As for exporting it to a file, use SELECT * INTO OUTFILE ...
---John W. Holmes...
PHP Architect - A monthly magazine for PHP Professionals. Get your copy
today. http://www.phparch.com/