sorting limit
Posted: Sun Jul 21, 2002 6:46 am
hi, i'm coding a news page with a full newspage and an other page that only show the last 3 items, my question, HOW? i can't get it sorted right because i simply dont know how, this is the query call:
what should i add to it that only the 3 last news items are shown? MAX 3 doesn't work 
Code: Select all
$query="SELECT * FROM nieuwtjes ORDER BY id DESC LIMIT 0 , 100";