and if you are using windows/*nix
spark
On 9/19/06, DJ Spark <[EMAIL PROTECTED]> wrote:
> hya,
>
> Funny thing, i'm having the same problem now :)
> Which PHP/MYSQL/APACHE version are you using ?
>
> spark
>
> On 9/5/06, Ámon Tamás <[EMAIL PROTECTED]> wrote:
> >
> > Hello,
> >
> > I try the next query:
> >
> > "SELECT workers.nev, worker_id, item_id, sum(pays.amount) as amount
> > FROM pays, workers
> > WHERE workers.id=pays.worker_id and year >={$syear} AND
> > year<={$eyear} AND month>={$smonth} AND month<={$emonth} and item_id in
> > (".join(', ', $ids).")
> > GROUP by worker_id, item_id"
> >
> > But when I retrieving the data I get an array something like this:
> >
> > [5] => Array
> > (
> > [workers] => Array
> > (
> > [nev] => Ámon Tamás
> > )
> >
> > [pays] => Array
> > (
> > [worker_id] => 5
> > [item_id] => 6
> > )
> >
> > [#sql_ae6_0] => Array
> > (
> > [amount] => 0
> > )
> >
> > )
> >
> > The problem is the last sub-array with #sql_ae6_0. And this is always
> > changing. How can I retrieve datas from it?
> >
> > --
> > Ámon Tamás
> > http://amon.hu
> >
> >
> > > >
> >
>
>
> --
> [web] http://synapsisdi.com.br
> [livesets] http://djspark.com.br/mp3
>
--
[web] http://synapsisdi.com.br
[livesets] http://djspark.com.br/mp3
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cake-php
-~----------~----~----~----~------~----~------~--~---
