(Query)SELECT 20 most recent rows

[bhattvk]

The (classified) Ads table has One row for One Ad (adid, title, desc, category, ph, postdate).

On "Ads Home" page I want to show 20 most recently posted ads. This can be achieved using ORDER BY postdate.🆒

But how to get first 20 records out of it??😕

[Weedpacket]

$sql=".... ORDER BY postdate DESC LIMIT 20";

[hand]

SELECT * FROM table ORDER BY postdate DESC LIMIT 20;

[bhattvk]

Great help. thannks