Thanks a lot! Great quick help!!!

--- Paul DuBois <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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

Reply via email to