problem: mysql tables rows - one row per page + condition

[moran1409]

hello i have a mysql table and i want to display each row in a different page with an added condition, the code:

	if (isset($_GET["page"])) { $page  = $_GET["page"]; } else { $page=1; }; 
  $start_from = $page-1; 

	$qry="SELECT * FROM ordering WHERE userid='$page' AND email='$email' 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='myorders.php?page=".$i."'>".$i."</a> "; 
}; 

 

the table is as so:

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,
  `fname` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  PRIMARY KEY (`userid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

 

now to the problem: this code displays all the userid as page numbers however, the email condition is good only for part of the rows

it's a little hard to explain, i'll try an example: suppose the email '[email protected]' is at rows 22,25 and 30 my code displays 30 page numbers and page 22 is user 22, page 25 is user 25 etc. what i want is to display only the page numbers of  the pages with the conditional email, and if possible to display them as 1,2,3 instead of 22,25,30

[aabid]

I am really not getting what you want, If you want 1 result to be displayed in one page then you have to increment the limit query for every page.

for example:-

$start

$limit .= 'LIMIT '.$start.', 1';

 

now only thing you have to do is to store value in variable which corresponds to the page user wants to view.

[moran1409]

i don't understand your reply, it's already displaying one result per page, it's the fact that it's not organized is what bothers me...

if there are three records with the same email i want to display only three pages numbered 1,2,3 each page will display a different result

how do i do that?