Re: [PHP-DB] group by get last record

2003-03-16 Thread Bob Hall
On Sun, Mar 16, 2003 at 08:02:02AM +, Daniel Harik wrote: > Hello, > > Guys i try to join to tables > > slides: > id > userid > file > moment > > users > id > username > > As there few slids per user and i want to get only last one, i use following > sql query, but it fetches me first slid

[PHP-DB] group by get last record

2003-03-15 Thread Daniel Harik
Hello, Guys i try to join to tables slides: id userid file moment users id username As there few slids per user and i want to get only last one, i use following sql query, but it fetches me first slide. How can i make it fetch last one please? SELECT slides.file, slides.moment, users.id, us