[vipernet]

Good day all,

Trying to complete this script and having little issue:

Im running a Count query from multiple tables within SQL and want to add the values and Echo the added value.
This is what I got so far:

PHP Code:

<table border="1" align="center">
<tr>
<?php
$link = mysql_connect("localhost", "root", "PASSWORD");
mysql_select_db("dt08_vnc", $link);

$result="SELECT COUNT(*) as value1 FROM bayside UNION All SELECT COUNT(*) as value2 FROM mgteed  WHERE item like '%desktop%'";


$r=mysql_query($result);


while($row=mysql_fetch_assoc($r))
//$add=($row['value1']+['value2']);
{

echo array_sum ($row);     
//  echo '<tr><td width="50%">'.array_sum['value1','value2'].'Desktops</td></tr>';


} 
     ?>

</tr>
</table>

The output is showing up as:
5716
I want the 2 values to add:
should be 73 (57+16)

The // codes are just things i was playing with,

Any help on what array to use other then array_sum or direction would be great.

[Mudley]

//i'm not sure what your query is returning (one row, or multiples) - so try this

$sum = 0;
while($row=mysql_fetch_assoc($r))
{
$sum = $row['value1'] + $row['value2];
echo $sum;
// echo '<tr><td width="50%">'.array_sum['value1','value2'].'Desktops</td></tr>';
$sum = 0; //reset
}

[vipernet]

Thanks allot for your reply.

I tried your code:

PHP Code:

$result="SELECT COUNT(*) as value1 FROM bayside UNION All SELECT COUNT(*) as value2 FROM mgteed  WHERE item like '%desktop%'";


$r=mysql_query($result);

$sum = 0;
while($row=mysql_fetch_assoc($r))
{
$sum = $row['value1'] + $row['value2'];
echo $sum;


$sum = 0; //reset
} 
     ?> 


Output reads:

Notice: Undefined index: value2 in E:\WWW\reports\summary.php on line 18
57
Notice: Undefined index: value2 in E:\WWW\reports\summary.php on line 18
16

I think my issue is with the SQL query. the second

PHP Code:

COUNT 


value2

isn't given a value. So the count is actually displaying the numbers 57 and 16 as the result of

Value1

[Mudley]

so its returning 2 rows, but only value1 for each row, no value2s?

lets find out what your query is returning. (i've never used UNION before)
<?
$result="SELECT COUNT(*) as value1 FROM bayside UNION All SELECT COUNT(*) as value2 FROM mgteed WHERE item like '%desktop%' LIMIT 1";


$r=mysql_query($result);

row=mysql_fetch_assoc($r);
echo "<xmp>";
print_r ($r);
echo "</xmp>";
?>