Adding two query results together

Anon

I have a script which displays whos online in the forums on my website front page :

At the moment it says : There are 10 members and 5 Guests on the forums

I would like it to say

There are 15 users on the forums

Can anyone help with this please :

Code snippet: (i can mail the complete script if needed)

$invisibleregmember = "0";

if ($usernames == "on") {
$regmembers = mysql_query("SELECT DISTINCT username,invisible FROM user,session WHERE session.userid=user.userid AND session.lastactivity>$datecut AND invisible='0' ORDER BY username ASC") or die("oops2");
while($regmember = mysql_fetch_array($regmembers)):
++$regmembercomma;
if ($regmember[invisible] == 0) {
$regmemberson .= $regmember[username];
} else {
++$regmembercomma;
}
if ($regmembercomma < mysql_num_rows($regmembers)):
$regmemberson .= ", ";
endif;
endwhile;
} else {
$regmembers = mysql_query("SELECT DISTINCT COUNT(userid) AS membersonline FROM session WHERE userid>0 AND session.lastactivity>$datecut") or die("oops2");
while($members = mysql_fetch_array($regmembers)) {
$regmemberson = number_format($members[membersonline]);
}
}

$guests = mysql_query("SELECT COUNT(userid) AS guestsonline FROM session WHERE userid=0 AND session.lastactivity>$datecut") or die("oops3");
while($guest = mysql_fetch_array($guests)):
$guestson = number_format($guest[guestsonline]);
endwhile;

echo("Member(s) on: $regmemberson. Guest(s) on: $guestson.");
?>

Anon

... replace your last echo by the two following lines.

$somenumber=$regmemberson+$guestson;
echo("There are $somenumber users on the forums.");

You may also want to get some basic programming course ;-)

Anon

....or just a math class.

"i have 2 numbers, and i want their sum... can you explain how database unions and grouping functions work so i can accomplish this dreaded task"

"i just installed PHPNuke on my new super cool Dell Desktop and want to change the smallest thing and cant figure it out"

gardner1

Wow, you guys are super rude.

This is a discussion forum where people are encouraged to ask questions.

Put them down and then they won't feel as free to ask a question which could be considered "valid" from you two.

Considering you two are so high on taking classes, you might look into "Civics 101"

and do you remember pretty much ever freakin' teacher saying...

"The only bad question is the one you didn't ask"

At least Alain, you answered the question. But im sure somewhere in your illustrious career you spent hours at a time searching for the perfect function of train of logic only to realize, or have someone tell you nicely...

why dont you just use a + sign to add them?

Anon

First : thanks Alain - i appreciate it.. it works fine

When i saw the answer and how simple it was to achieve, i realised it did sound like a dumb question , but i try, i am trying to get my head around PHP and databases, i spent all afternoon getting the script to even work ...

I spend a lot of my time reading these Excellent forums to learn.. and i am getting there .... slowly but surely...

Thanks Richard and everyone else who has helped Newbies like myself, your time showing/teaching is very much appreciated.....

Anon

sorry about that, i even thought it was a troll.... but come on!

waddy, congrats on getting it working, and i'm glad you see how easy the question was. if you are new to programming, this is NOT the place to start. learn basic programming, and then start PHP. this forum can be very helpful to PHP newbies, but the people that answer the questions assume a certain level of programming skill that i don't think you have yet.

any just to set the record straight, my teacher always said "a stupid question deserves a stupid answer"......... something to think about.

Anon

My career is by no mean illustrious, and my only merit, if any, is to have been able to solve some common problems that more competent people did not want to see on their tasks list, be it a question of schedule or personal taste.
Granted, we were all junior at one time or another, and we have all wasted an awfull amount of time solving basic syntax issues or flawed logic. From this period, for my part, I have kept the taste to "rediscover the wheel" and to try to be as much self reliant as I can.
But, to be able to do so, you need at least some basic understanding of your trade. I was not trying to be ironic by suggesting waddy to take some basic programming courses, it is the best time saving advice that I can offer him.
Once one has a firm understanding of the basics, it is time to try something and learn from experience. When I pick up a new language, I usually do not go through someone else's code to try to modify it. For me, it is one of the more challenging tasks that I am only able to accomplish by having tried to reproduce the original functionnalities and then comparing my code (and its usual bugs) with others.
So, to be complete, my advice is :
- take some basics programming courses ;
- try to do some things by yourself ;
- then look at how others went to reach the same goal and eventually adapt their way to your style.
Just my two cents on the subject ;-)