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
Geek" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, February 15, 2003 10:09 AM
Subject: Need Help With MySQL Query
> 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 i
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
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 to this list
Here's my table ($usertableDaily):
vanNumber|grossPay
-
