Re: SELECT with LIMIT
| From: | Bob Hall | Date: | Sun, 07 Jan 2001 15:22:09 +0000 |
| Subject: | Re: SELECT with LIMIT | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-4849@lists.php.net to get a copy of this message | ||
Hi all, With SELECT * FROM table_name LIMIT 0,158 I'm puling out from table first 158 elements. But what about if I want to pull out last 158 elements from table? Solution: SELECT * FROM table_name LIMIT 0,158 ORDER BY id DESC doesn't work.Sir, try ORDER BY id DESC LIMIT 158. Bob Hall Know thyself? Absurd direction!
Bubbles bear no introspection. -Khushhal Khan Khatak