Veysel Harun Sahin wrote:
select vanNumber, sum(grossPay) from usertableDaily group by vanNumber;
The above is the correct query, to save yourself some time. As for your
problem:
But when I execute I get this:
Resource id#3
Resource id#4
This means you're using a resource resp
Are you referencing the result set correctly in php ?
How are you dealing with what MySQL returns ?
Looks like the info is there, you just not getting it out of the result
set.
-
Jerry @
MetalCat.Net
-
- Original Message -
From: "Guru Geek"
Hi
Interesting problem, normally to get a total by type, you would have a query
like,
select van, sum(pay) from ($usertableDaily) group by van;
However you are individually quering each total, your approach is correct, but
slower.
The problem you have though is the return of
Resource i
select vanNumber, sum(grossPay) from usertableDaily group by vanNumber;
[EMAIL PROTECTED] wrote:
hello,
I've performed searches on this site and php.net to try and figure out
why this is occuring. I can't find any instance in my searches that
helped me. So, I'm posting my very first question