On 9/10/05 3:13 PM, "bruce" <bedouglas@xxxxxxxxxxxxx> 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 a@xxxxx dddd > b1 aa@xxxxx 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 > bedouglas@xxxxxxxxxxxxx -- Stephen Johnson The Lone Coder http://www.ouradoptionblog.com *Join us on our adoption journey* stephen@xxxxxxxxxxxxxxxx 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
