Jump to content

Archived

This topic is now archived and is closed to further replies.

johnny

How can I add these query results?

Recommended Posts

Ok I have the following queries that display numeric values on my page:

[code]      <?php

$link = mysql_connect("xxx", "xxx", "xxx")
  or die("Could not connect : " . mysql_error());
mysql_select_db("xxx") or die("Could not select database");
$query="
SELECT CelebTotal.$week
FROM CelebTotal,schedule
WHERE CelebTotal.Celeb = schedule.f1
AND schedule.week = $week
AND schedule.team = '1'
";
$res = mysql_query($query);
while($row = mysql_fetch_assoc($res))
{
echo $row [$week].'<br>';
}



?>

      <?php

$link = mysql_connect("xxx", "xxx", "xxx")
  or die("Could not connect : " . mysql_error());
mysql_select_db("xxx") or die("Could not select database");
$query="
SELECT CelebTotal.$week
FROM CelebTotal,schedule
WHERE CelebTotal.Celeb = schedule.f2
AND schedule.week = $week
AND schedule.team = '1'
";
$res = mysql_query($query);
while($row = mysql_fetch_assoc($res))
{
echo $row [$week].'<br>';
}



?>[/code]

I want to ADD these two values and display that number on the same page.  I have tried something like this, but it's not working:

[code]<?php

$link = mysql_connect("xxx", "xxx", "xxx")
  or die("Could not connect : " . mysql_error());
mysql_select_db("xxx") or die("Could not select database");
$query="
SELECT CelebTotal.$week
FROM CelebTotal,schedule
WHERE CelebTotal.Celeb = schedule.f1
AND schedule.week = $week
AND schedule.team = '1'
";

$query2="
SELECT CelebTotal.$week
FROM CelebTotal,schedule
WHERE CelebTotal.Celeb = schedule.f2
AND schedule.week = $week
AND schedule.team = '1'
";

$res=mysql_query($query);
$res2=mysql_query($query2);

$total = $res+$res2;

echo $total;

?>[/code]

It returns a number, but that number is always 7 and that's not correct. 

Share this post


Link to post
Share on other sites
Try:

[code]
<?php

$link = mysql_connect("xxx", "xxx", "xxx")
  or die("Could not connect : " . mysql_error());
mysql_select_db("xxx") or die("Could not select database");
$query="
SELECT CelebTotal.$week
FROM CelebTotal,schedule
WHERE CelebTotal.Celeb = schedule.f1
AND schedule.week = $week
AND schedule.team = '1'
";


$res=mysql_query($query);

$total = $res++;

echo $total;

?>
[/code[[/code]

Share this post


Link to post
Share on other sites
What does the "++" mean/do?  That code only includes one of the two queries I want to add together. 

Share this post


Link to post
Share on other sites
++ means post-increment. The line "$total = $res++" means "assign the value of $res to $total, and then increase $res by 1".

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.