Re: Need Help With MySQL Query

[Veysel Harun Sahin <suppressed>]

select vanNumber, sum(grossPay) from usertableDaily group by vanNumber;

suppressed 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 to this list....
>
> Here's my table ($usertableDaily):
>
> vanNumber|grossPay
> ---------------------
> 1111          | 1000
> 1111          | 500
> 2222          |100
> 2222          |100
>
> Here's my query:
> SELECT SUM(grossPay) FROM $usertableDaily WHERE vanNumber =
> $vanList[$count]
>
> The query appears inside a loop hence the $vanList[$count] variable.  I
> have a txt file that contains the van numbers.  I read that file and
> then run through the loop and for each van number I execute the above
> statement.  Yes, I've trimmed off any extra blank spaces before and
> after the 'read' van numbers...
>
> I want to SUM the grossPay for each van number.  Here's what it should
> be:
> 1111 $1500
> 2222 $200
>
> But when I execute I get this:
> 1111 Resource id#3
> 2222 Resource id#4
>
> Anyone got any idea why this is happening?
>
> Thanks in advance,
> Roger
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
>   http://www.mysql.com/manual.php   (the manual)
>   http://lists.mysql.com/           (the list archive)
>
> To request this thread, e-mail <suppressed>
> To unsubscribe, e-mail <suppressed>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>  

--

Veysel Harun Sahin
suppressed




---------------------------------------------------------------------
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <suppressed>
To unsubscribe, e-mail <suppressed>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php