On 9/10/05 3:13 PM, "bruce" <[EMAIL PROTECTED]> wrote:
> if i allow a user to search on say 'aa', i'd like the user to be able to
> get:
>
> name email foo...
> aa [EMAIL PROTECTED] dddd
> b1 [EMAIL PROTECTED] 123
>
> any ideas as to how i could go about and create the query, or what would i
> need to do to have this result...
Use like in your select statement ...
Select name, email, foo from tbl where email like '%aa%';
> 2) if i have a query that produces a number of rows, how/what would i need
> to do, to limit the number of rows displayed, and to allow the user to
> select a 'back/next' button that would generate/display the next 'N' items
> in the list/query results...
>
Use limit in your select statement
Select * from tbl limit 10;
You can also use a start in the limit so the next button would call this
select.
Select * from tbl limit 10, 10;
> if anybody could direct me to sample docs/code that kind of describes/solves
> what i've described, i'd appreciate it!!!
The folks on the MySQL list can help you with these questions better then
the folks here on the PHP list.
>
> thanks
>
> -bruce
> [EMAIL PROTECTED]
--
Stephen Johnson
The Lone Coder
http://www.ouradoptionblog.com
*Join us on our adoption journey*
[EMAIL PROTECTED]
http://www.thelonecoder.com
*Continuing the struggle against bad code*
--
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
