[SOLVED] Retrieving the most recent record from a mysql table

[debuitls]

Hi,

 

This might be an easy question for someone.

 

I have a mysql table which has a datestamp column.

 

I'm retrieving email records from the table using the following

 

SELECT signuphotel.email
FROM proposal
LEFT JOIN signuphotel 
ON proposal.county = signuphotel.county AND proposal.starrating = signuphotel.starrating
WHERE proposal.county = '$county' AND proposal.starrating = '$starrating'";

 

The problem is that this statement is retrieving all the relevant records when all I want to retrieve is the latest one.

 

I'm thinking I need to include another AND statement saying something like AND proposal.datestamp = …..

 

Can anyone suggest how to retrieve just the latest record?

 

Any help would be greatly appreciated.

 

Thanks!

 

[rhodesa]

SELECT signuphotel.email
FROM proposal
LEFT JOIN signuphotel
ON proposal.county = signuphotel.county AND proposal.starrating = signuphotel.starrating
WHERE proposal.county = '$county' AND proposal.starrating = '$starrating'
ORDER BY proposal.starrating DESC
LIMIT 1

[debuitls]

Ah it obviously was an easy queston!

 

That works fine.

 

Thanks very much for your help rhodesa.