[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 Dong

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

2002-11-08 Thread Qunfeng Dong
] wrote: At 13:30 -0800 11/8/02, Qunfeng Dong wrote: Hi, Can anybody give me a simple example of using PHP's mysql_query to perform mulitple mysql queries. I If you mean an example of a single call to mysql_query() that performs multiple queries, no one

[PHP-DB] mysql_use_result()

2002-12-05 Thread Qunfeng Dong
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! Qunfeng Dong

[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
might take you tomorrow. -Original Message- From: Qunfeng Dong [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 23, 2003 3:32 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] save output to a file instead of displaying in the browser Hi, I am trying to build a PHP-MySQL