"Andrius Jakutis" <[EMAIL PROTECTED]> wrote in
message 003d01c125c2$fa6487a0$40722fd4@mano">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>

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to