i want to display each row from mysql table in a different page using this code:
Code: Select all
<?
require_once('config.php');
//Connect to mysql server
$link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
if(!$link) {
die("can't connect: " . mysql_error());
}
$db = mysql_select_db(DB_DATABASE);
if(!$db) {
die("can't select database");
}
mysql_query("SET NAMES 'hebrew'");
//mysql_set_charset('utf8',$link);
if (isset($_GET["page"])) { $page = $_GET["page"]; } else { $page=1; };
$start_from = $page-1;
$qry='SELECT * FROM ordering limit 0, 1';
$result = mysql_query($qry);
while($row = mysql_fetch_array($result)){
echo "<div dir='rtl' charset='utf8'><h2>"," hover cam: ",$row['hover_camera'],
"<br> stills: ",$row['stills'],
"<br> video_photographers: ",$row['video_photographers'],
"<br> increase: ",$row['increase'],
"<br> video_edit: ",$row['video_edit'],
"<br> digital_album: ",$row['digital_album'],
"<br> photo_album: ",$row['photo_album'],
"<br> small_digital_album: ",$row['small_digital_album'],
"<br> video_clip: ",$row['video_clip'],
"<br> magnets: ",$row['magnets'],
"<br> comments: ",$row['comments'],
"<br> date: ",$row['date'],
"<br><br></h2></div>";
}
$sql = "SELECT COUNT(userid) FROM ordering";
$result = mysql_query($sql,$link);
$row2 = mysql_fetch_row($result);
$total_records = $row2[0];
$total_pages = $total_records ;
for ($i=1; $i<=$total_pages; $i++) {
echo "<a href='table.php?page=".$i."'>".$i."</a> ";
};
?>CREATE TABLE IF NOT EXISTS `ordering` (
`userid` int(11) unsigned NOT NULL AUTO_INCREMENT,
`hover_camera` varchar(10) DEFAULT NULL,
`stills` int(5) NOT NULL,
`video_photographers` int(5) NOT NULL,
`increase` int(5) NOT NULL,
`video_edit` varchar(10) NOT NULL,
`digital_album` varchar(10) DEFAULT NULL,
`photo_album` varchar(10) DEFAULT NULL,
`small_digital_album` varchar(20) DEFAULT NULL,
`video_clip` varchar(10) DEFAULT NULL,
`magnets` int(10) NOT NULL,
`comments` text NOT NULL,
`date` date NOT NULL,
PRIMARY KEY (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;
the problem is that only the first row is displayed no matter which page i choose
and i want each page to display the row assigned to it (page 15 = row 15 etc...)
any suggestions?