Thanks a lot! Great quick help!!!
--- Paul DuBois <paul@snake.net> wrote:
> >I don't know how to merge all the results from each
> >mysql_query.
> >
> >$result1 = mysql_query("CREATE temporary table
> >tempTable ...");
> >$result2 = mysql_query("insert ...");
> >...
> >$resultn-1 = mysql_query("select * from
> tempTable");
> >$resultn = mysql_query("Drop table tempTable");
> >
> >Then what?
>
> What do you mean, merge the results? The merging
> happens on the
> server side. When you're ready to select the merged
> result, then
> process the result of this query:
>
> $resultn-1 = mysql_query("select * from tempTable");
>
> Once you've fetched all the rows from that query,
> then go on
> to issue the DROP TABLE statement in the next call
> to mysql_query().
>
> Does that help?
>
> >
> >Qunfeng
> >
> >--- Paul DuBois <paul@snake.net> wrote:
> >> >Hi Thanks for the reply. But then do you happen
> to
> >> >know 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
> >> understand the
> >> difficulty. What problem are you experiencing?
> >>
> >> >
> >> >Qunfeng
> >> >
> >> >--- Paul DuBois <paul@snake.net> 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 will be
> able
> >> to
> >> >> show you
> >> >> an example. It doesn't work that way. It
> >> executes
> >> >> a single
> >> >> query per call.
> >> >>
> >> >> >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
> >> >>
> >> >
> >> >
> >>
> >__________________________________________________
> >> >Do you Yahoo!?
> >> >U2 on LAUNCH - Exclusive greatest hits videos
> >> >http://launch.yahoo.com/u2
> >>
> >
> >
> >__________________________________________________
> >Do you Yahoo!?
> >U2 on LAUNCH - Exclusive greatest hits videos
> >http://launch.yahoo.com/u2
>
__________________________________________________
Do you Yahoo!?
U2 on LAUNCH - Exclusive greatest hits videos
http://launch.yahoo.com/u2
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
