select date from table limit 1

[liamloveslearning]

Hi all, I need to select the highest date out of my table where user = sessionid.

 

for example, USER SESSION ID = 10

 

user_ses_id        Date

12                      2010-05-19

10                      2009-12-01

10                      2010-05-24

30                      2009-05-20

 

so the value I would be calling is '2010-05-24'

 

Does this make sense?

 

My code im trying is

SELECT *
FROM model_pictures
WHERE user_id = colname
ORDER BY model_pictures.user_picture_date DESC LIMIT 1

[Yucky]

Use:

SELECT *
FROM model_pictures
WHERE user_id = colname
ORDER BY str_to_date(user_picture_date, "%Y-%m-%d") DESC LIMIT 1