Thread: Results Listing

    #1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2000
    Posts
    2
    Rep Power
    0
    I am using MySQL together with PHP3. I want to create a 'search engine' where the results are not displayed as one big listing on a single page, but on multiple pages with something like 20 results per page. The user will have the option to click on some link to get the next/previous set. My first idea is to implement this with MySQL's LIMIT. Can anyone advise if this is the right way to do this, or perhaps tell me about other ways.

    Thanks for your help,
    Rene
  2. #2
  3. No Profile Picture
    Apprentice Deity
    Devshed Loyal (3000 - 3499 posts)

    Join Date
    Jul 1999
    Location
    Niagara Falls (On the wrong side of the gorge)
    Posts
    3,237
    Rep Power
    19
    Yes, that would be the way to do it. Check out my article on this subject at http://www.phpbuilder.com
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2000
    Posts
    2
    Rep Power
    0
    Thanks! I have read the article and found it to be very useful.

    Rene

Similar Threads

  1. need ideas on listing query results
    By loco30 in forum PHP Development
    Replies: 1
    Last Post: February 14th, 2004, 02:17 AM
  2. Listing results in a 3 or 4 column table
    By muffty in forum PHP Development
    Replies: 8
    Last Post: January 14th, 2004, 07:39 AM
  3. Listing results alphabetically
    By JasonL in forum MySQL Help
    Replies: 2
    Last Post: January 4th, 2004, 04:36 PM
  4. Listing results from DB
    By woldie in forum PHP Development
    Replies: 2
    Last Post: July 15th, 2003, 10:25 AM
  5. listing Mysql results in form data...
    By cosworth in forum PHP Development
    Replies: 10
    Last Post: June 2nd, 2003, 01:26 PM

IMN logo majestic logo threadwatch logo seochat tools logo