Paging cant work

nuttynibbles

hi my paging wont work. whenever i click the next page, the record wont change and remain at page one.

php_paging.php

<html>

<head>
<title>Plus2net.com paging script in PHP</title>
<meta name="GENERATOR" content="Arachnophilia 4.0">
<meta name="FORMATTER" content="Arachnophilia 4.0">
</head>

<body bgcolor="#ffffff" text="#000000" link="#0000ff" vlink="#800080" alink="#ff0000">
<?
require "config.php";

$page_name="php_paging.php";

if(!isset($start))
{

$start =0;
}

$eu = ($start - 0);
$limit = 1; // No of records to be shown per page.
$this = $eu + $limit;
$back = $eu - $limit;
$next = $eu + $limit;

//WE have to find out the number of records in our table
$result2 = mysql_query('SELECT * FROM custInfo');
echo mysql_error();
$nume=mysql_num_rows($result2);

// Now let us print the table headers
$bgcolor="#f1f1f1";
echo "<TABLE width=50% align=center cellpadding=0 cellspacing=0> <tr>";
echo "<td bgcolor='dfdfdf' > <font face='arial,verdana,helvetica' color='#000000' size='4'>Name</font></td>";
echo "<td bgcolor='dfdfdf' > <font face='arial,verdana,helvetica' color='#000000' size='4'>Class</font></td>";

// Now let us start executing the query with variables $eu and $limit

$query=" SELECT * FROM custInfo limit $eu, $limit ";
$result=mysql_query($query);
echo mysql_error();

//Now we will display the returned records in side the rows of the table
while($noticia = mysql_fetch_array($result))
{
if($bgcolor=='#f1f1f1'){$bgcolor='#ffffff';}
else{$bgcolor='#f1f1f1';}

echo "<tr >";
echo "<td align=left bgcolor=$bgcolor id='title'> <font face='Verdana' size='2'>$noticia[ID]</font></td>";
echo "<td align=left bgcolor=$bgcolor id='title'> <font face='Verdana' size='2'>$noticia[Name]</font></td>";

echo "</tr>";
}
echo "</table>";
// End of displaying the table with records

// Start the buttom links with Prev and next link with page numbers
echo "<table align = 'center' width='50%'><tr><td align='left' width='30%'>";
//if our variable $back is equal to 0 or more then only we will display the link to move back

if($back >=0) {
print "<a href='$page_name?start=$back'><font face='Verdana' size='2'>PREV</font></a>";
}

// Let us display the page links at center. We will not display the current page as a link
echo "</td><td align=center width='30%'>";
$i=0;
$l=1;
for($i=0;$i < $nume;$i=$i+$limit){
if($i <> $eu){
echo " <a href='$page_name?start=$i'><font face='Verdana' size='2'>$l</font></a> ";
}
else { echo "<font face='Verdana' size='4' color=red>$l</font>";} // Current page is not displayed as link and given font color red
$l=$l+1;
}

echo "</td><td align='right' width='30%'>";
//If we are not in the last page then Next link will be displayed. Here we check that
if($this < $nume) {
echo "<a href='$page_name?start=$next'><font face='Verdana' size='2'>NEXT</font></a>";}
echo "</td></tr></table>";

?>
<center><a href='http://www.plus2net.com'>PHP SQL HTML free tutorials and scripts</a></center>
</body>

</html>

config.php

<?php
$servername='localhost'; // Your MySql Server Name or IP address here
$dbusername=''; // Login user id here
$dbpassword=''; // Login password here
$dbname='sql_tutorial'; // Your database name here

connecttodb($servername,$dbname,$dbusername,$dbpassword);
function connecttodb($servername,$dbname,$dbuser,$dbpassword)
{
global $link;
//Database
$link = mysql_connect('localhost', 'root', '');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
//<br>
$selectDB = mysql_select_db('databasetest', $link);

}

?>

Rodney_H_

This might help: You could check to see if "start" is set in the query string, and if it is, assign it's value to the $start variable. Otherwise, start at zero...

<?php
require('config.php');

$page_name = 'php_paging.php';

// if start is set:
if(isset($_GET['start']))
{
	$start = $_GET['start'];
}
else 
{
	$start = 0;
}
// etc...
?>

nuttynibbles

hey thanks it works. now i've got another Q. :p

if i were to display the record, it will be shown from top to down right. like the 1st record followed by the 2nd and so for vertically.

how do i display the record horizonally. meaning that my 1st record on the left of the page, followed by the 2nd record on the right of the 1st record..

example: refer to this page, notice the list of dvds at the bottom with the pictures are display.
starting from legend of zorro to Madagascar
http://www.catchmovie.com/

nuttynibbles

hi i've gt a problem.

lets imagine we have got a table with width=745, height=82 align=left. In this table, we're gonna display many image. let say 30 images. since the table align is "left", the images will start displaying from the left to right. since there is 30 images, you will see all 30 images from left to right of the table.

my Q is, how do we sort out the display in such a way whereby the max images to be display in the first row of the table is 10. therefore the other 20 images will be shown on the 2nd & 3rd row of the table.

here is my code:

Rodney_H_

<?php /*  Is this what you mean? */ ?>
<html>
<head>
<title>for loop</title>
</head>

<body>
<table width="745" height="82" border="0">
<tr>
  <td height="68" valign="top">
<?php
// define loop
for($i = 0; $i < 30; $i++)
{
	if($i % 10 == 0 && $i != 0){
		echo '
  </td>
</tr>
<tr>
  <td>
	<img src="image.jpg" width="50" height="50" />' ."\n";
	}
	else {
		echo "\t" . '<img src="image.jpg" width="50" height="50" />' . "\n";
	}
}
?>
</table>
</body>
</html>

If not, perhaps you could search the forums for displaying output...

nuttynibbles

yea!! hey thanks alot dude. yeappie