Please help with previous/next

[timsharpe]

<?php

$connection = mysql_connect ('localhost', 'user', 'pass');
if ($connection == false){
  echo mysql_errno().": ".mysql_error()."<BR>";
  exit;
}  



$query = "select * from jobs WHERE category='Accountant' limit 1";
$result = mysql_db_query ("employment", $query);



if ($result){


  $numOfRows = mysql_num_rows ($result);
  for ($i = 0; $i < $numOfRows; $i++){
    $job_title = mysql_result ($result, $i, "job_title");
	$description = mysql_result ($result, $i, "description");
	$employer = mysql_result ($result, $i, "employer");
	$address = mysql_result ($result, $i, "address");
	$city = mysql_result ($result, $i, "city");
	$province = mysql_result ($result, $i, "province");
	$telephone = mysql_result ($result, $i, "telephone");
	$email = mysql_result ($result, $i, "email");
	$website = mysql_result ($result, $i, "website");
	$experience = mysql_result ($result, $i, "experience");
	$salary = mysql_result ($result, $i, "salary");




echo "<table cellpadding=0 cellspacing=0 border=0><tr><td width=20></td><td 

width=500><font class=smalllogo2><b>Position</b> : $job_title<br>";
    echo "<b>Position Description</b> : $description<br>";
	 echo "<b>Street Address</b>: $address<br>";
	 echo "<b>City</b> : $city<br>";
	 echo "<b>Province</b> : $province<br>";
	 echo "<b>Telephone</b> : $telephone<br>";
	 echo "<b>Contact Person</b> : $email<br>";
	 echo "Website Address: <a href=http://$website>$website</a><br>";
	 echo "<b>Experience & Notes</b> : $experience<br>";
	 echo "<b>Salary</b> : $salary</td></tr></table><br><br>";
	include ("buildNav.php");


  }





}
else{
  echo mysql_errno().": ".mysql_error()."<BR>";
}

mysql_close ();
?>

Can someone please alter the above code so that there is a previous/next link?

[sijis]

and your problem is where or what specifically?

[timsharpe]

I need someone to show me how to insert a previous/next link to view files?

[devinemke]

Here's how I would do it (assuming your primary key field is an integer called job_id)
This is not tested but should give you the idea

<?
$connection = mysql_connect ('localhost', 'user', 'pass');
if (!$connection) {echo mysql_errno () . ': ' . mysql_error () . '<BR>'; exit;}
mysql_select_db ('employment');

extract (mysql_fetch_assoc (mysql_query ('SELECT MAX(job_id) AS max_job_id FROM jobs')));
extract (mysql_fetch_assoc (mysql_query ('SELECT MIN(job_id) AS min_job_id FROM jobs')));

if (!isset ($_GET['job_id'])) {$_GET['job_id'] = $min_job_id;}
$query = "SELECT * FROM jobs WHERE category = 'Accountant' AND job_id = " . $_GET['job_id'];}
$result = mysql_query ($query);

if ($result)
{
  extract (mysql_fetch_assoc ($result));

echo '
<table cellpadding=0 cellspacing=0 border=0>
	<tr>
		<td width=20></td>
		<td width=500>
			<font class=smalllogo2>
			<b>Position</b> : ' . $job_title . '<br>
			<b>Position Description</b> : ' . $description . '<br>
			<b>Street Address</b>: ' . $address . '<br>
			<b>City</b> : ' . $city<br> . '<br>
			<b>Province</b> : ' . $province . '<br>
			<b>Telephone</b> : ' . $telephone . '<br>
			<b>Contact Person</b> : ' . $email . '<br>
			Website Address: <a href=http://' . $website . '>' . $website . '</a><br>
			<b>Experience &amp Notes</b> : $experience . '<br>
			<b>Salary</b> : ' . $salary . '
		</td>
	</tr>
</table>
<br>
<br>
';

if ($job_id != $min_job_id) {extract (mysql_fetch_assoc (mysql_query ("SELECT job_id AS prev FROM jobs WHERE job_id < $job_id ORDER BY job_id DESC LIMIT 1")));}
else {$prev = '';}

if ($job_id != $max_job_id) {extract (mysql_fetch_assoc (mysql_query ("SELECT job_id AS next FROM jobs WHERE job_id > $job_id LIMIT 1")));}
else {$next = '';}

if ($prev) {echo '<a href="' . $_SERVER['PHP_SELF'] . '?job_id=' . $prev . '">PREV</a>;} else {echo '&nbsp;';} echo ' | '; if ($next) {echo '<a href="' . $_SERVER['PHP_SELF'] . '?job_id=' . $next . '">NEXT</a>';

  include ('buildNav.php');    

}

else {echo mysql_errno () . ': ' . mysql_error () . '<BR>';}
mysql_close ();
?>

[trooper]

Wander over to the articles section there is a very good article on building next / previous links

HTH

GM