Hello.
> 1) i'm trying to figure out how to allow a user to search through a Full-Text search functions might be helpful. See: http://dev.mysql.com/doc/mysql/en/Fulltext_Search.html > 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 To limit the number of rows use LIMIT. See: http://dev.mysql.com/doc/mysql/en/select.html "bruce" <[EMAIL PROTECTED]> wrote: > hi... > > i'm trying to figure out how to approach/solve a few issues. looking through > google hasn't made the light shine!! > > 1) i'm trying to figure out how to allow a user to search through a > query/tbl for a given string. ie, if i have the following as the result of a > query: > > name email foo... > aa [EMAIL PROTECTED] dddd > b1 [EMAIL PROTECTED] 123 > bb [EMAIL PROTECTED] qwe > > > 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... > > > 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... > > if anybody could direct me to sample docs/code that kind of describes/solves > what i've described, i'd appreciate it!!! > > thanks > > -bruce > [EMAIL PROTECTED] > > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
