Retrieving Last entry only

[Anon]

Hi,
When I execute the script I get the entire table to display. How do I write the script in order to get just the last entry to display?

$sql = "
SELECT *
FROM maint, lsv
WHERE maint.vid = \"$vid\"
AND maint.vid = lsv.vid
ORDER BY maint.date DESC
";

Any help will be gratefully appreciated.

:o) Ivan

[Anon]

$sql = "
SELECT *
FROM maint, lsv
WHERE maint.vid = \"$vid\"
AND maint.vid = lsv.vid
ORDER BY maint.date DESC
LIMIT 1";