--- In [email protected], James Keeline <[EMAIL PROTECTED]> wrote: > > --- whoisquilty <[EMAIL PROTECTED]> wrote: > > > James - I tried your first option (which suits my needs best) and it > > tells me that it "can't group on popular". I also tried a few > > variations but it still gave the same results. > > > > Is that the right column to be grouping? Or should I be grouping > > 'vidno' as that's the one that I'll be using to join other tables? > > > > Jeremy > > Yes, vidno is the one to GROUP BY. > > I guess you have another column which includes the date-time? Your table field > list seemed incomplete. > > James >
I see the problem with my earlier post. My mistake. rankid (id for each row) vidno (id number of the video viewed i.e. page loaded) access_time (date/time it is accessed) So, vidno is the id number for the video. I will join another table based on vidno that will show the info on the video that is viewed, therefore displaying that info in the "most popular". Even when I group by vidno, it tells me that it can't group on popular, however.
