10 records per page?

How does PHP display 10 records per page?

 

if u mean that the info displayd come from a database then it will be using sql query and adding the "LIMIT 10" to the query

if from a text based ... just by using a simple if and maybe a variable $i that will count ..

 

Like this?

 

if ur query is correct yes the limit will only return 10 if u add LIMIT 10 ...

 

It's not working:

 

I made some editing but still getting error.

 

Limit 0,10 is use only for mysql not for SQL Server

 

So any other way? I've been waiting for an answer for two days now.

 

http://blogs.msdn.com/sqlserver/archive/2006/10/25/limit-in-sql-server.aspx

 

SELECT * FROM `your_table` LIMIT 0, 10

 

there is no "LIMIT" In SQL server .

 

PHP with SQL server?

 

I couldn't figure out the page.

 

I'm using MSAccess 2000 with php. With the Apache Server.

 

gilgalbiblewheel - Commandos is correct. From looking at your errors. You are using SQL server. And there is no 'limit' for SQL server.

SELECT * FROM ( SELECT *, ROW_NUMBER() OVER (ORDER BY text_data) as row FROM book ) a WHERE row > 5 and row <= 10

 

But if I want to lay out the following pages 10 at a time then is this still good?

what's a before WHERE and why row > 5?

 

the following code i believe will return row 6, 7, 8, 9 and 10.

If you want to display 10 pages, then you will change the WHERE clause to something like row > 0 and row <=10.

And to make it dynamic, you can replace the '0' and '10' with variables (e.g. row > $beginRow and row <= $endRow). Where $beginRow and $endRow will store your pages.

 

I changed to mysql ( from MS Access ).

I have this so far:

$perpage = 10;
$start = (!empty($_GET['start'])) ? $_GET['start'] : 0;

$sql.= " LIMIT " . $start . "," . $perpage;

PHP:

What am I missing to go on to page 2?