1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2000
    Rep Power
    in my data base there are thousands of records are there, i want to retrieve them and display only 15 records at a time.how can it possible.?

  2. #2
  3. No Profile Picture
    Devshed Newbie (0 - 499 posts)
    display in what (web browser?), using what language (php?)
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2000
    New Delhi,Delhi,India
    Rep Power
    Regardless of the language you use , if you sending a query in mysql and are trying to limit the no. of retreived records you can use "limit" at the end of the select statement to restrict the records also u can use the where option generally for this purpose .
    SELECT * FROM table_name LIMIT 10,10;
    will give you all the columns of table "table_name" and total 10 rows starting from the tenth row

Similar Threads

  1. selecting duplicate records
    By crackerweb in forum Visual Basic Programming
    Replies: 3
    Last Post: November 12th, 2003, 12:10 PM
  2. process records from stdin
    By dbehera in forum C Programming
    Replies: 0
    Last Post: August 5th, 2003, 02:37 PM
  3. Replies: 0
    Last Post: July 22nd, 2003, 08:56 AM
  4. zero records...
    By PhilgB in forum MySQL Help
    Replies: 2
    Last Post: May 7th, 2002, 07:43 AM
  5. printing records via loop with restrictions
    By bakedbean in forum PHP Development
    Replies: 5
    Last Post: January 29th, 2002, 12:15 AM

IMN logo majestic logo threadwatch logo seochat tools logo