[PHP-DB] export query

2003-01-15 Thread Doug Parker
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?


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



RE: [PHP-DB] export query

2003-01-15 Thread John W. Holmes
 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 trtd{$row[0]}/tdtd{$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/



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php