SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Guru ujjwal's Avatar
    Join Date
    Oct 2004
    Location
    kolkata
    Posts
    821
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Mysql retreving data problem

    Hi all

    I have faced a problem.
    In my database there is a table and that table has 6000 rows.
    but in my query if i limit it into 0 to 500
    SELECT * FROM `pc_Package` LIMIT 0 , 500
    It working fine.
    but if i do it in 0 to 2500
    SELECT * FROM `pc_Package` LIMIT 0 , 2500

    then it is not working

    Can you explain this?
    How could i retrevied all the data?
    -::Ujjwal::-
    Visit My Site

  2. #2
    Tranceoholic lilleman's Avatar
    Join Date
    Feb 2004
    Location
    Írebro, Sweden
    Posts
    2,716
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi,

    In which way does it not work? Any error messages?
    ERIK RIKLUND :: Yes, I've been gone quite a while.

  3. #3
    SitePoint Zealot newspire's Avatar
    Join Date
    Mar 2005
    Location
    Houston, TX
    Posts
    118
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Are you using some sort of GUI to query the database? GUIs often put a limit on the number of rows they retrieve from the db. This is a pretection in case you select a million records. If you are using some sort of GUI then you might need to turn that off.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •