Jerry Stuckle wrote:

> lazy wrote:
>> I want to write a script such that it executes 2 mysql queries on the
>> server. But before executing the second query, I would like to return
>> the results of the first query to the user and then do my second query
>> or second query can go on asynchronously

If you totally *need* to do so, do it client-side. Make the browser request
the first set of data, and when loaded, make it request the second.
Javascript and some AJAX techniques will .


> You don't find much on PHP threading because you don't typically do
> multithreading in PHP. Most PHP scripts (especially web based) are
> meant to be short and sweet - get in, do the job and get out.

Also, multithreading in web servers' processes doesn't usually go very
well - output race conditions and messing with the webserver's threading
model are a recipe for disaster. I speak from experience here. Please don't
try to do threading using the PHP apache module if you don't want to get a
headache.

OTOH, threading goes well with local scripting (when the PHP script is not
tied to a webserver). In this case, the PHP POSIX API works like any other
language - learn to do multithreading in C, you already know how to do
multithreading in PHP.


Cheers,
--
----------------------------------
Iván Sánchez Ortega -ivansanchez-algarroba-escomposlinux-punto-org-

Proudly running Debian Linux with 2.6.24-1-amd64 kernel, KDE 3.5.9, and PHP
5.2.6-1 generating this signature.
Uptime: 17:53:17 up 14 days, 1:41, 4 users, load average: 0.41, 0.62,
0.58