- Code: Select all
SELECT * FROM `table` LIMIT 0, 1
Thanks for your answer.
It works but this is not the result I wanted because how I explain my problem was wrong.
I actualy have several rows with the same date AND different dates.
Exemple: 29 dec.2002
31 dec.2002 etc...
What I'd like to print is: 29 dec.2002
I hope it's clearer now.
One more thing: The querry I had has changed and the (LIMIT statement doesn't work any longer - I think)
The new querry I have is:
$q = "SELECT
F_Num, Date, User_ID, User_Country
tableA.User_ID = tableB.User_ID
ORDER by Date desc
Thank to all for your help, and Happy new year