Re: show only some entries
| From: | Hugh Bothwell | Date: | Wed, 15 Aug 2001 20:33:43 +0000 |
| Subject: | Re: show only some entries | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-11401@lists.php.net to get a copy of this message | ||
"Andrius Jakutis" <nfs@cis.lt> wrote in
message news:003d01c125c2$fa6487a0$40722fd4@mano...
> 1. How to make, that I could get output of only
> those entries, which name(field) is "John".
SELECT * FROM table WHERE name='John'
> 2. How to make, that only 10 entries with John would
> be shown in the same page, and others would be on
> "next page" and so on.
SELECT * FROM table WHERE name='John' LIMIT 10*($thispage-1),10
<a href='myscript.php?{$thispage+1}'>Next page</a>