Next previous links

[hcaz32000]

Hello,

I'm trying to recieve several hundred resullts from a database but I can't fugure out where to put my previous/next links so I can only have to program one page. Can you tell me were to insert my code from the following code that I already have done. Also could you insert the code into this that you would use.

Thanks for your help

	  <?
	  /* declare some relevant variables */
	  $DBhost = "";
	  $DBuser = "";
	  $DBpass = "";
	  $DBName = "";
	  $table = "";

	  mysql_connect($DBhost,$DBuser,$DBpass) or die("Unable toconnect to database");
	  @mysql_select_db("$DBName") or die("Unable to select database $DBName"); 
	  $sqlquery = "SELECT * FROM $table LIMIT 10";
	  $result = mysql_query($sqlquery);
	  $number = mysql_numrows($result);

	  $i = 0;

	  if ($number < 1) {
	  print "<CENTER><P>There Were No Results for Your Search</CENTER>";
	  }
	  else {
	  while ($number > $i) {
	  $id = mysql_result($result,$i,"id");
	  $url = mysql_result($result,$I,"url");
	  $space = mysql_result($result,$I,"space");
	  $email = mysql_result($result,$I,"email");
	  $upload = mysql_result($result,$I,"upload");
	  $ads = mysql_result($result,$I,"ads");
	  print "<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<b>url:</b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<b>space:</b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<B>email</b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<b>upload</b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<B> ads</b><BR><BR>
	  $url &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $space&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $email&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $upload&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $ads</p>";
	  $i++;
	  }
	  }
	  ?>