1. No Profile Picture
    Devshed Newbie (0 - 499 posts)
    I've asked for the help for displaying 10 records per page just before. The actual result which i needed is like altavista search result or same like the result that is displayed when we select "all topics" from the top-right corner drop-down.

    Thanx in advance

  2. #2
  3. .Net Developer
    Devshed Novice (500 - 999 posts)

    Join Date
    Feb 2000
    Rep Power

    you can do this,you should issue the following sql statement.

    $query="SELECT * FROM tblname LIMIT 0,10";

    //0- offset,10 rows
    //Retrieve 1-10 rows

    if you want to display all the records then remove "limit" from the sql query...

    GOOD LUCK!!!

    SR -

    "The fear of the LORD is the beginning of knowledge..."

    [This message has been edited by Shiju Rajan (edited June 10, 2000).]

Similar Threads

  1. re: JSP page not displaying name
    By Internment in forum Java Help
    Replies: 3
    Last Post: February 18th, 2004, 04:03 AM
  2. Displaying records in between 2 fields
    By davecollier in forum ASP Programming
    Replies: 2
    Last Post: February 17th, 2004, 11:59 AM
  3. displaying mysql records (10 at a time) ?
    By tim0 in forum Perl Programming
    Replies: 10
    Last Post: January 29th, 2004, 01:48 AM
  4. page not displaying correctly in netscape 4.77
    By derrek in forum HTML Programming
    Replies: 4
    Last Post: January 13th, 2004, 04:42 PM
  5. page not displaying correctly in netscape 4.77
    By derrek in forum Beginner Programming
    Replies: 5
    Last Post: January 13th, 2004, 02:31 PM

IMN logo majestic logo threadwatch logo seochat tools logo