At 12:07 4/7/2001 +0930, David Robley wrote:
>On Wed, 4 Jul 2001 00:00, Christian Dechery wrote:
> > well... I tought of that.
> > It doesn't work for many reasons:
> > 1 - '*' always has to be the first on the select list
> > 2 - you can't have expressions (max, min, avg) without a group by
> >
On Wed, 4 Jul 2001 00:00, Christian Dechery wrote:
> well... I tought of that.
> It doesn't work for many reasons:
> 1 - '*' always has to be the first on the select list
> 2 - you can't have expressions (max, min, avg) without a group by
> clause if you are handling multiple rows
> 3 - etc. etc.
well... I tought of that.
It doesn't work for many reasons:
1 - '*' always has to be the first on the select list
2 - you can't have expressions (max, min, avg) without a group by clause
if you are handling multiple rows
3 - etc. etc.. etc...
that's why I included the code in between the queries.
onday, July 02, 2001 9:41 PM
To: Christian Dechery; [EMAIL PROTECTED]
Subject: Re: [PHP] help in getting results from mysql
On Tue, 3 Jul 2001 09:54, Christian Dechery wrote:
> I have to get some results from a mysql table, and I'm pretty sure
> that I'm not doing it the bes
On Tue, 3 Jul 2001 09:54, Christian Dechery wrote:
> I have to get some results from a mysql table, and I'm pretty sure that
> I'm not doing it the best way.
>
> its like this... I have a table (a historical one) with these fields:
> date | item_id | item_type_id | qty | value
>
> and there are m
I have to get some results from a mysql table, and I'm pretty sure that I'm
not doing it the best way.
its like this... I have a table (a historical one) with these fields:
date | item_id | item_type_id | qty | value
and there are multiple lines for the pair item/type (as I said it's a
histori
6 matches
Mail list logo
