[SOLVED] Pagination Script... What's wrong with it?

[Foser]

Nothing executes I'm trying to find why... I'm trying to make my own simple pagination program.

heres the script:

 

index.php

<?php
mysql_connect(localhost, root, password) or die(mysql_error());
mysql_select_db(tutorial1) or die(mysql_error());
include_once('function.php');
if (!isset($_GET['PAGE'])){
$getpage = 1;}
else { 
$getpage = $_GET['PAGE'];}
max_ammount($getpage,2);
next_number($getpage);
$query1 = mysql_query("SELECT * FROM pagination ORDER BY id");
while (mysql_num_rows($query1) <= $max_value && mysql_num_rows($query1) > $min_value ){
echo "ID Number: {$query['id']}<br>Name: {$query['name']}<br>Age: {$query['age']}<br>Referer: {$query['referer']}<br>-----------------------------------------------------<br>";
}

?>

 

function.php

<?php
function max_ammount($getpage,$maxammount){
if ($getpage <= 1){
$max_value = 1;
return $max_value;}
else {
$max_value = $getpage * $maxammount;
return $max_value;}	
}
function next_number($getpage){
if ($getpage <= 1){
	$min_value = 0;
	return $min_value;}
	else { 
	$get_1 = $getpage. + 1;
	$min_value = $get_1. + 2;
	return $min_value;}
	}
?>

[btherl]

When a function returns a value, you need to set that value to a variable.  For example:

 

$max_value = max_ammount($getpage,2);
$min_value = next_number($getpage);

[teng84]

i dont see you use the limit clause?

[Foser]

i dont see you use the limit clause?

Could you give an example of limit clause?

[teng84]

mysql_query("SELECT * FROM pagination ORDER BY id limit $min_value ,$max_value ");

 

thats how paging work

 

 

ooops

glad thorpe dont see my post lol or else he will say stop posting one liner explanation

lol

[btherl]

$num = $max_value -$min_value + 1;
$query1 = mysql_query("SELECT * FROM pagination ORDER BY id LIMIT $min_value, $num");
while ($row = mysql_fetch_assoc($query1)){
echo "ID Number: {$row['id']}<br>Name: {$row['name']}<br>Age: {$row['age']}<br>Referer: {$row['referer']}<br>-----------------------------------------------------<br>";
}

 

Give that a try and let us know how it goes.  My mysql syntax is a bit rusty, as i'm a postgres user.

[Foser]

Works but I think im limiting too much since it's only displayed 1.

[teng84]

can we see your code now

[Foser]

<?php
mysql_connect(localhost, root, password) or die(mysql_error());
mysql_select_db(tutorial1) or die(mysql_error());
include_once('function.php');
if (!isset($_GET['PAGE'])){
$getpage = 0;}
else { 
$getpage = $_GET['PAGE'];}
$max_value = max_ammount($getpage,2);
$min_value = next_number($getpage);
$query1 = mysql_query("SELECT * FROM pagination ORDER BY id LIMIT $min_value , $max_value");
$query2 = mysql_query("SELECT * FROM pagination ORDER BY id");
while ($row_info = mysql_fetch_assoc($query1) ){
echo "ID Number: {$row_info['id']}<br>Name: {$row_info['name']}<br>Age: {$row_info['age']}<br>Referer: {$row_info['referer']}<br>-----------------------------------------------------<br>";
}
if (mysql_num_rows($query2) > $max_value) {
echo "<br>Next";
}
?>

 

functions:

<?php
function max_ammount($getpage,$maxammount){
if ($getpage <= 1){
$max_value = 1;
return $max_value;}
else {
$max_value = $getpage * $maxammount;
return $max_value;}	
}
function next_number($getpage){
if ($getpage <= 1){
	$min_value = 0;
	return $min_value;}
	else { 
	$get_1 = $getpage. + 1;
	$min_value = $get_1. + 2;
	return $min_value;}
	}
?>

[Foser]

fixed it.