Thread: PHP4 + MS SQL

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

    Join Date
    Jul 2000
    Location
    Sweden
    Posts
    2
    Rep Power
    0
    Is there any way to limit the number of hits per page when using PHP4 and MS Sql.
    I would like to show 10 hits per page when running the question.
  2. #2
  3. .Net Developer
    Devshed Novice (500 - 999 posts)

    Join Date
    Feb 2000
    Location
    London
    Posts
    987
    Rep Power
    15
    Hi ,

    you can do that very easily.Read the following example(You should replace the database connectivity with MSSQL)

    http://www.phpbuilder.com/columns/rod20000221.php3

    ------------------
    SR -
    webshiju.com

    "The fear of the LORD is the beginning of knowledge..."
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2000
    Location
    Sweden
    Posts
    2
    Rep Power
    0
    I have tried that, but it seems like MS Sql does not support "Limit". It says that the syntax is incorrect.

    //Rickard

Similar Threads

  1. Long SQL Statement
    By aaron.martone in forum MS SQL Development
    Replies: 5
    Last Post: April 8th, 2004, 07:59 PM
  2. sql UPDATE table
    By imustgo in forum ASP Programming
    Replies: 3
    Last Post: November 11th, 2003, 09:28 AM
  3. Poor SQL Server Programming, Part 4
    By DavidM in forum MS SQL Development
    Replies: 0
    Last Post: October 21st, 2003, 10:28 PM
  4. Poor SQL Server Programming Part 2
    By DavidM in forum MS SQL Development
    Replies: 0
    Last Post: October 20th, 2003, 10:19 PM
  5. Poor SQL Server Programming!
    By DavidM in forum MS SQL Development
    Replies: 0
    Last Post: October 20th, 2003, 10:19 PM

IMN logo majestic logo threadwatch logo seochat tools logo