Not sure how to phrase this question

[jimmyoctane]

I'm not looking for someone to code for me I just need to be pointed in the right direction.

I currently have a table which holds images and information required to display with the images. Because of my limited knowledge in PHP I created one page that sqls the table and grabs the first 6 images and then builds the html to show them on a page. Then I had to do this a "few" more times changing only the Sql to grab records 7 thru 12, then 13 thru 18 ..........

Is there a way to do this in one Php page? Could it generate the navigation passing a parm with the next starting record number and post to itself??????


I hope I was clear in explaining this.

Thanks in advance for the help.

jimmy

[sde]

this would make a good tutorial, .. but generally here is how you do it ..

you will need to use a variable for the starting record and use it in the url:
http://site.com/gallery.php?s=1

in your code, you will do something like this:

PHP Code:

<?
// set $s to 1 if there is no value
if(!$_GET['s']){
  $s = 0;
}else{
  $s = $_GET['s'];
}

// get six results starting from s
$result = mysql_query("select * from table limit ".$s.",6");

// your link for the next page
echo "<a href=\"".$_SERVER['PHP_SELF']."?s=".($s+6)."\">get next page</a>\n";
?>

i didn't test the code, but it should point you in the right direction.

make sense?

a hell of a lot easier than you would do it in rpg huh?

[jimmyoctane]

Thanks I'm gonna play around with this.

(your site is busy)