[PHP-DB] multiple mysql query in PHP mysql_query?

2002-11-08 Thread Qunfeng Dong
Hi, Can anybody give me a simple example of using PHP's mysql_query to perform mulitple mysql queries. I am using MySQl 3.23, trying to use create temporary table and insert ... select to overcome the lack of union operation in that verion of MySQL. Thanks! Qunfeng

[PHP-DB] Re: multiple mysql query in PHP mysql_query?

2002-11-08 Thread Qunfeng Dong
how to accomplish those mysql statements > in > >> YOUR > >> >BOOK pg. 168 about Union in PHP? > >> > >> For each statement that you wish to execute, > invoke > >> it with > >> a separate call to mysql_query(). I don't > >> understa

[PHP-DB] mysql_use_result()

2002-12-05 Thread Qunfeng Dong
hen I used mysql --quick to run the same query and it returns the results very fast. My question is: which PHP function can I use to query the MySQL database in the "mysql --quick" mode? That is which PHP functions represents the mysql_use_result()? Thanks

[PHP-DB] How to seperate the web server and MySQL database server?

2003-01-04 Thread Qunfeng Dong
Hi, I am sure this is a silly/easy question but I really hope someone can point me some documents. We are currently running PHP and MySQL at the same machine. Can I run PHP in one machine and MySQL server in another machine? If so, how can I make the database connection? Currently, in all my PHP

[PHP-DB] save output to a file instead of displaying in the browser

2003-01-22 Thread Qunfeng Dong
Hi, I am trying to build a PHP-MySQL application. When users query our database from our web interface, how can I send the output to a file for users to save it to his local disk instead of displaying the output to the browser. Thanks, Qunfeng _

RE: [PHP-DB] save output to a file instead of displaying in the browser

2003-01-28 Thread Qunfeng Dong
Sincerely > > berber > > Visit http://www.weberdev.com Today!!! > To see where PHP might take you tomorrow. > > > > -Original Message- > From: Qunfeng Dong [mailto:[EMAIL PROTECTED]] > Sent: Thursday, January 23, 2003 3:32 AM > To: [EMAIL PRO