error using SUM - help!!!

[[deleted]]

Hi guyz,

i'm a new php user. i got a problem when query a SUM. I used this statement:

$coun = mysql_query("SELECT sum(no_visitor) FROM company WHERE date_visit >= '$start' AND date_visit <= '$end' group by company") ;
......
Total Skali IDC visitor(s) = <?php echo($coun); ?>

i want to sum all the visitors in my database
and it come out with this result:
Total Skali IDC visitor(s) = Resource id #3

Can someone help me on this?
Thanks guyz.

cheerios,
mezi2u

[Anon]

$coun = mysql_query("SELECT sum(no_visitor) FROM company WHERE date_visit >= '$start' AND date_visit <= '$end' group by company") ;

then

$sumval = mysql_result($sd_q, $i, 'sumval');

dont forget to add the appropriate error checking etc. etc.

[Anon]

Should it not be:

SELECT SUM(no_visitor)
FROM company
WHERE date_visit>='$start' AND date_visit <= '$end'
GROUP BY no_visitor;

[Anon]

good point... I missed the GROUP by company rather than no_visitors.. but I think his main error was echoing the query rather than the result..