Why should I rely on PHPJabbers.com for all my PHP scripting needs? What do you offer me when buying some script?
  • Top quality scripts
  • Full demo before buying
  • Best pricing
  • Script customization
  • 7 days a week support
  • Installation support
  • Secure buying
  • PHP / MySQL select data and split on pages

    posted on 2006-12-31 10:29:11
    Comments
    Ravi posted on 2007-06-19 16:32:24
    I have One form in which i am fatching all the data from databse and don\'t want to display all but only 10 per pages and page no only should be display after 10 records to go anothe page like Page:1,2,3
    ---------------------
    Veselin: you can use the example above and just change it to show 10 and not 20 database records per page

    judi posted on 2007-06-08 21:49:35
    thanks for this sample script - really helped me out this morning!!

    Adnan posted on 2007-06-03 15:30:09
    thank you sir, but i am very new to php, i did not understand it. but i want to do same thing in my program, what should i do???
    ---------
    Veselin: for a small fee we can make it work on your website

    samonn amra posted on 2007-05-17 07:01:35
    selecte data in table and link to other page

    Fungai posted on 2007-05-06 14:51:52
    I have tried using rand() and it does select the questions randomly but the answers are no longer coming up as A,B,C,D they are also coming out radomly and even mixing answers from different questions, am i missing something?
    -------------------
    Veselin: email me your database table structure and query you are using

    Fungai posted on 2007-04-05 16:19:28
    i am trying to retrieve random questions from mysql database using php. Any ideas of how i can do it?
    --------------------------
    Veselin: you can use
    SELECT * FROM table_name ORDER BY rand()

    tarun posted on 2007-03-08 12:57:43
    looking for more

    R.bala murugan posted on 2007-03-06 13:27:21
    Sir,
    Your sample is very usefull for me.

    Regards
    R.bala murugan

    Saqib Bilal posted on 2007-02-14 09:47:26
    i have a long pagination say 50 pages
    i want to split pages in to regular interval of 10 like
    10......20,20......30,30......40,40.......50
    any idea how to modify this code

    Carlos posted on 2007-01-22 17:39:09
    I get the following response
    Query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '$start_from, 20' at line 1 based on the following query;
    $sql = 'SELECT WGIOrdNo, ProjNo, ATTRefNo, CusName, CurDate, Status, Engr, SrvLn FROM rbsr_table LIMIT $start_from, 20';
    ----------------------
    Veselin: query needs to be in double quotes

    Pages:   1 2 3 4
       
    If you have any additions, suggestions or modifications for this example please contact us or use the form below.
       
    Your name:
    Your email: (email address will not be posted on the web site)
    Comment:
    Verification