I have a PHP driven site where I have a internal messaging type
system for registered users. Each time a message is sent I create a
log entry in a table with the from and to user id and an id from the
original message to maintain a message 'thread'. Example (my
timestamps do not display p
type
>
> and i still only get a single row for each type, where i would expect to
get
> the ~5000 rows, grouped around the 3 different types.
>
> what's going on
>
> thanks...
>
> -bruce
>
>
> -Original Message-
> From: Paul DuBois [mail
ECTED]
Sent: Friday, September 10, 2004 4:36 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: group by issue...??
At 16:27 -0700 9/10/04, bruce wrote:
>hi...
>
>if i do this...
>
>select
>h1.itemID as hitem,
>h1.process as process,
>h1.status as status,
>h1.tblTyp
[EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: group by issue...??
At 16:27 -0700 9/10/04, bruce wrote:
hi...
if i do this...
select
h1.itemID as hitem,
h1.process as process,
h1.status as status,
h1.tblType as tbl,
h1.date as date
from historyTBL as h1
where (h1.tblType = '3' or h1.tb
At 16:51 -0700 9/10/04, bruce wrote:
paul
forgive me for being a neophyte!!! but i have no idea how what you said
helps me get to how i can actually get a grouping
is there anyway to get a grouping... is there some other way to accomplish
this..?
am i totally lost!
If you just want to s
4 | | 160 | 160 | 1 | 0 |3 | 2004-09-11
> 12:23:15 |
>
+--+---+--+---+-++--+---
> --+
>
> i was thinking that a subselect might work, but couldn't get it to work...
>
> thanks for any pointers
At 16:27 -0700 9/10/04, bruce wrote:
hi...
if i do this...
select
h1.itemID as hitem,
h1.process as process,
h1.status as status,
h1.tblType as tbl,
h1.date as date
from historyTBL as h1
where (h1.tblType = '3' or h1.tblType = '4');
i get a results table with ~5000 rows...
if i add the 'group by'
hi...
if i do this...
select
h1.itemID as hitem,
h1.process as process,
h1.status as status,
h1.tblType as tbl,
h1.date as date
from historyTBL as h1
where (h1.tblType = '3' or h1.tblType = '4');
i get a results table with ~5000 rows...
if i add the 'group by' sql,
select
h1.itemID as hitem,
