Sorry i do not know how to word this but hopefully you guys will understand.

I am building a database with movies in it, now i have a page called movies, on the page is a listing of all the movies but their is 50 movie listings on the page and i only want 20 movies per page and i was wondering if their was any way i could make a link that shows the next 20 movies on the same page when i click the link. like how google shows 10 links then when you click the 2 link it takes you to 10 more links like that.

If you don't understand what i am saying please tell me and i will try to reword it.

I think I know what you mean (In future, post code...it's worth 1000 words).

If your using SQL to pull the movies, just adjust the query.

For example, make your query:

SELECT * FROM `movies` LIMIT 0,20;

For the first page and the following for the second page

SELECT * FROM `movies` LIMIT 20,40;

and so on.

I would have submitted code but i do not have any for this other than the query to show the movies on the page. Also wouldent i have to make a new page for every 10 movies i inserted into my database? is their any way to use only one page and every time i click on the link for the next 10 they would show up on the same page?

yes you can use the same page of course.
just use page parameters like

page.php?p=0
and
page.php?p=1
and so on

then in the code you can check on this like the following

PHP Code:

$rows=10;
$start=$_GET["p"]*$rows;
$end=($_GET["p"]+1)*$rows;

$ors=mysql_query("select * from movie limit $start,$end"); 


of course you need ot loop through $ors and display the result
i assume you know that

Originally Posted by Knight13

I would have submitted code but i do not have any for this other than the query to show the movies on the page. Also wouldent i have to make a new page for every 10 movies i inserted into my database? is their any way to use only one page and every time i click on the link for the next 10 they would show up on the same page?

Thanks that is what i was looking for.