Next button

[everlifefree]

ok i'm looking to make a next button for my site that goes up looks at the id of the page your on and then when you click the next button it takes you to the next one in line it the database. and it can't just go 1, 2, 3, 4, ect. because there are missing variable from deletions some it'd need to be able to read like this 1, 2, 5, 6, 7, 12, ect. (you get the point of just serveal missing numbers between.

[discomatt]

Why not:

 

$r = mysql_query('SELECT `id` FROM `table`');

while ($arr = mysql_fetch_assoc($r))

  echo '<a href="page.php?id=' . $arr['id'] . '">' . $arr['id'] . '</a> ';

[haku]

or:

 

"SELECT id FROM table WHERE id > current_page_id ORDER BY id ASC LIMIT 1"

[everlifefree]

k but what would be the url for the next button?

 

[everlifefree]

URL anyone?

[haku]

Add one to the current page ID. You are going to have to set the currentp age ID first though - use a $_GET variable.

[everlifefree]

so my original url is like: http://mysite.com?L=index.gallery&id=57 but to call the next page what'd the url be?

[sasa]

use SELECT * FROM TABLES WHERE id>=$id AND ... LIMIT 2

in 1st featch you have curent data, and in 2nd is next id

[teng84]

use SELECT * FROM TABLES WHERE id>=$id AND ... LIMIT 2

in 1st featch you have curent data, and in 2nd is next id

why dont you just do it this way  so it will only fetch one record?

SELECT * FROM TABLES WHERE id>$id AND ... LIMIT 1

[everlifefree]

I get that side of things but I need the exact URL to fetch the next page??

[haku]

It should be the same URL as the page you are on, just using the next ID number.

[everlifefree]

Here's the code I attempted but I get all it puts in {ezine.id2} is the number 1 and that isn't right! Can anyone tell me where I went wrong??

 

if (isset($_GET["id"])) 
	$row2 = myF(myQ("
		SELECT * 
		FROM `[x]gallery` 
		WHERE 'id' > '{$_GET["id"]}' 
		AND `processed` = '1'
		ORDER BY 'id' ASC
		LIMIT 1
	"));

$tpl -> AssignArray(array(
	"ezine.id2" => $row2["id"],
));

[everlifefree]

anyone?

[everlifefree]

Anyone know where I went wrong?

[haku]

I'm about to go on a trip with the wife so I only have about one minute to post. I dont know what is wrong with your current code, but use this:

 

if(isset($_GET['page_id']))
{
   $query = "SELECT page_id FROM pages WHERE page_id > " . $_GET['page_id'] . " ORDER BY page_id ASC LIMIT 1";
}
else
{
    $query = "SELECT page_id FROM pages WHERE page_id > 1 ORDER BY page_id ASC LIMIT 1";
}
// Do your mysql query here
echo "<a href=\"page_name?page_id=" . $page_id_taken_from_database . "\">NEXT PAGE</a>";