PHP mySQL query question

[jsteiner87]

I have two tables like what I have below.

NameID Name
-------------------
1 Joe
2 Steve
3 Marty
4 Doug
-------------------


ID NameID Last LogIn
-------------------------
1 1 2006-01-01
2 1 2006-01-02
3 2 2006-01-02
4 3 2006-01-03
5 4 2006-01-03
6 4 2006-01-04
7 1 2006-01-04
8 2 2006-01-04
-------------------------


I have joined the tables (on name ID) and now I want to add to the sql statement so that it lists each of the peoples last login and only the last login. I have tried to use GROUP BY but it only gives me the first login and not the last login.

I need the output to look like the following

Joe 2006-01-04
Steve 2006-01-04
Marty 2006-01-03
Doug 2006-01-04

 

[jpadie]

why are you asking this question in the php forum and not the mysql forum?

 

[jsteiner87]

Good question, I guess I will just post in that forum then.