Re: Combining 2 queries into 1?

Thanks for your response, however you missunderstood my question. I just posted the sollution in this thread over. I was looking for a query that gave me the total amount on users which had a userID and the total without a userID. Selecting (*) would give me both the anonymous and logged users. -- -- Kim Steinhaug ---------------------------------------------------------------------- There are 10 types of people when it comes to binary numbers: those who understand them, and those who don't. ---------------------------------------------------------------------- www.steinhaug.com - www.easywebshop.no - www.webkitpro.com ---------------------------------------------------------------------- "Jonathan Hadddad" <jon@oldirtyhaddad.com> wrote in message news:9BADBFEC-B27D-11D8-958A-000D9350D348@oldirtyhaddad.com... > How about > > select count(*) from online > > Jon > > On May 30, 2004, at 1:23 PM, Kim Steinhaug wrote: > > > I have theese two queries : > > > > select count(*) as online from online where uid=''; > > select count(*) as online from online where uid!=''; > > > > Each online user has a uid (UserID), so if their logged > > inn this field will represent their unique uid. If not logged > > in its set to nothing. > > > > To detect how many online users the first query tells me > > all the "anonymous" users and the second gives "members". > > > > Since theese two queries are fired on every page hit, I would > > assume that if I could join theese queries into one I would > > atleast save the mysql for a 50% of the queries. > > > > Ive veeb experimenting on the count(expression) without > > any luck, probably since the server is running v4.0.17-standard > > > > So I wonder - is there any way I could join the above queries > > into one single query? Ofcourse I could easily add another > > field for the database, something like temp which is NULL for > > anonymous and 1 for user if this makes is easier to group the > > the query in some wmart way I havnt figured out at the moment. > > > > -- > > -- > > Kim Steinhaug > > ---------------------------------------------------------------------- > > There are 10 types of people when it comes to binary numbers: > > those who understand them, and those who don't. > > ---------------------------------------------------------------------- > > www.steinhaug.com - www.easywebshop.no - www.webkitpro.com > > ---------------------------------------------------------------------- > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > >