RE: [PHP] group by get last record

2003-03-16 Thread Don Read
On 16-Mar-2003 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 slide. How can i make it fet

[PHP] 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