Jump to content

Archived

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

johnny

Assign query result to variable and add query results together

Recommended Posts

Ok I have the following two queries that return a numeric value:

QUERY 1:

$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>';
}

QUERY 2:

$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>';
}

I want to build a THIRD QUERY and I want that to return the SUM of the first two. I realize that I will likely have to build in the first two queries into this third query, so I've tried this:

$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($rows = mysql_fetch_assoc($res));{
$f1 = $rows[$week];
};

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

$res2=mysql_query($query2);
while($rows = mysql_fetch_assoc($res));{
$f2 = $rows[$week];
};

$total= $f1 + $f2;

print $total;

But that comes back Resource Id #3.

I have tried to do this:
$res = mysql_query($query);
$res2 = mysql_query($query2);
$total = $res + $res2;
print $total;

but that always returns a numeric value of 7. the answer is not 7. heck I can change the queries to go fetch out different cells in the table and it still comes back 7.

Help!

Share this post


Link to post
Share on other sites
Resource? That means you're dealing with the PHP object itself, not the value... BTW, there's probably a way to do this in a single query, but I'm a little busy now, and it's not popping into my head yet.

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.