creating Next and Previous buttons gained from a row of results....help!

[SpockBert]

Imagine you have a table of vehicles made up of different classes, say "cars","planes","bikes".

So if I did SELECT * from VEHICLES WHERE myClass = 'cars';

I get... "Ferrari, Porsche, Lambo,Lexus" etc

What I would like to know is there a way of counting so I know that in those returned rows "Porsche" is No.2?

Ultimately I'm trying to create NEXT and PREVIOUS buttons so for example if the page was on "Porsche" my NEXT would take me to "Lambo" and previous to "Ferrari".

I'm guessing to do that I need to do something clever with the offSet values, but I'm a little stumped as how to get Porsche to tell me its No.2 of all vehicles with the class of cars.

Any ideas, all feedback appreciated! 😉

[tommmmm]

Could you not put the data from the database into an array which you could then run through?

[SpockBert]

You mean dump "Ferrari, Porsche, Lambo,Lexus" into an array?

How would you figure out that "Porsche" was No.2 from that though?

[tommmmm]

If you were to put them into an array in the order you need then you could navigate between them by just calling the array with the correct key? That seems like it should be suitable for your needs as I undedrstand them.

[rajug]

Here is a function that i made for pagination. Please look it out:

	function PaginateData($start,$perPage,$total,$page){
		if($total >= 1){
			echo "<b>";
			//for previous
			$previous = $start - $perPage;
			if($start > 0 and $start < ($total - $perPage))
				echo " <a href=\"javascript:GoInfo('$page&start=$previous')\" class=\"A2\" title=\"Previous\">&laquo; Previous</a> ";
			else if($start > 0 and $start >= ($total - $perPage))
				echo " <a href=\"javascript:GoInfo('$page&start=$previous')\" class=\"A2\" title=\"Previous\">&laquo; Previous</a> ";
			//complete previous
			echo "Page : | ";
			$l = 1;
			for($i = 0; $i < $total; $i = $i + $perPage){
				if($i != $start)
					$a[$l] = "<a class=\"A2\" href=\"javascript:GoInfo('$page&start=$i')\">$l</a>&nbsp;";
				else
					$a[$l] = "$l&nbsp;";
				$l++;
			}
			foreach($a as $p=>$pp)
				echo $pp;
			//for next
			echo " | ";
			$next = $start + $perPage;
			if(($start == 0) and $total > $perPage)
				echo " <a class=\"A2\" href=\"javascript:GoInfo('$page&start=$next')\" title=\"Next\">Next &raquo;</a>";
			else if($start > 0 and $start < ($total - $perPage))
				echo " <a class=\"A2\" href=\"javascript:GoInfo('$page&start=$next')\" title=\"Next\">Next &raquo;</a>";	
			//complete next
		}
		echo "</b>";
	}

Put the following lines in your top of the page:

	//paging
	$perPage = 40;
	$total = 0;
	if(isset($_REQUEST['start'])){$start = $_REQUEST['start'];}
	else{$start = 0;}

Then you can call like this:

     //get the query two times like this one for total and one for limited rows.
	  $sqlC = "SELECT * FROM tblorganicpageload WHERE ProjectID='$_REQUEST[ProjectID]' $param GROUP BY IP";
	  $rsC = mysql_query($sqlC);
	  $total = mysql_num_rows($rsC);

  $sql = "SELECT * FROM tblorganicpageload WHERE ProjectID='$_REQUEST[ProjectID]' $param GROUP BY IP ORDER BY InsertTime DESC LIMIT $start, $perPage";
  $rs = mysql_query($sql) or die(mysql_error());
  $numRows = mysql_num_rows($rs);
while(loop){ //goes here
//print your rows
}
if($total >= 1){
if($total < $perPage){$perPage = $total;} 
echo "Displaying " . ($start + 1) . " - " . ($start + $numRows) . " of " . $total;
}
PaginateData_($start,$perPage,$total,"yourpage.php?urlstring=value");