[Resolved] Display Previous/Next by ID?

m_tCh

Anyone know how you could add links to display previous or next by ID? Example: Assume it is displaying record ID =198. The next link would load this page with ID=199. I'm not sure how to do this.

Thanks for your help!

include "functions.php";

//checkSession();

<html>

<head>

<title>Best Database</title>
<meta name="keywords" content="mitch">
<LINK href="cssstyle.css" rel="stylesheet" type="text/css">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"><style type="text/css">

</style>

</head>

              </tr>
              <tr class="right">

              </tr>
              <tr class="right">
                <td colspan="3" class="case"><img src="images/blank.gif" width="1" height="1"></td>
              </tr>

              <tr class="ro">
                <td width="1%" align="center" class="listdata style2 style12" <%=$bgcolor%>>&nbsp;</td>
                <td width="99%" class="listdata" <%=$bgcolor%>><%
	$passed_vars = array_merge($_POST,$_GET);
	$sql = "SELECT * FROM BEST WHERE ID = '$passed_vars[sel_record]'";

	$sql_result = mysql_query($sql) or die (mysql_error());
	if (!$sql_result) {
		echo "Something has gone wrong!";
	} else {

		while ($record = mysql_fetch_array($sql_result)) {
			$$xsel_record = $record['ID'];
			$Name = stripslashes($record['Name']);
			$Def = stripslashes($record['Def']);
			$Condition = stripslashes($record['Condition']);
			$Standards = stripslashes($record['Standards']);
			$Best = stripslashes($record['Best']);
			$Num = stripslashes($record['Num']);
			$Keyr = stripslashes($record['Keyr']);
			$Level = stripslashes($record['Level']);
			$Ksa = stripslashes($record['Ksa']);
			$Bloom = stripslashes($record['Bloom']);
			$Info = $record['Info'];
			$Ass1 = stripslashes($record['Ass1']);
			$Ass2 = stripslashes($record['Ass2']);
			$Ass3 = stripslashes($record['Ass3']);
			$Ass4 = stripslashes($record['Ass4']);
			$Ass5 = stripslashes($record['Ass5']);
			$Ass6 = stripslashes($record['Ass6']);
			$Ass7 = stripslashes($record['Ass7']);
			$Ass8 = stripslashes($record['Ass8']);
			$Sim1 = stripslashes($record['Sim1']);
			$Sim2 = stripslashes($record['Sim2']);
			$Sim3 = stripslashes($record['Sim3']);
			$Sim4 = stripslashes($record['Sim4']);
			$Sim5 = stripslashes($record['Sim5']);
			$Sim6 = stripslashes($record['Sim6']);
			$Sim7 = stripslashes($record['Sim7']);
			$Sim8 = stripslashes($record['Sim8']);
		}
		$ID = "$xsel_record";

   		echo "

		<FORM method=\"POST\" action=\"best_domodrecordpost.php\">
		<INPUT TYPE=\"hidden\" name=\"ID\" value=\"$xsel_record\">
		<P><strong>Name: $Name </a><br>
		<P><strong>Definition:  $Def<br>
        <P><strong>Condition:  $Condition<br>			
        <P><strong>Standards:  $Standards<br>			
		<P><strong>Best Practices:  $Best<br>
		<P><strong>Primary:  $Num<br>
		<P><strong>Secondary: $Ass1  $Ass2  $Ass3  $Ass4  $Ass5  $Ass6  $Ass7  $Ass8<br>
		<P><strong>Similar: $Sim1  $Sim2  $Sim3  $Sim4  $Sim5  $Sim6  $Sim7  $Sim8<br>
		<P><strong>Key Resp. Area:  $Keyr<br>
		<P><strong>Career Level:  $Level<br>
		<P><strong>Knowledge, Skill, or Ability:  $Ksa <br>
		<P><strong>Bloom's Level: $Bloom <br>
		<P><strong>File Location:  $Info <br>

		";

}
%> </td>

              </tr>

              <tr>
                <td height="19" colspan="3" class="baseline"><div align="center" class="ro"><a href="default.php">Home</a><P><FORM>

</P></div></td>
</tr>
</table></td>
</tr>
</table>
</div>
</div>
<div style="margin-bottom:10px;"></div>
</div>
</div>
<div align="center"> </div>
</div>

</body>

</html>

devinemke

assuming the current ID is in a variable called $current_id, you need to do the following 2 queries:

SELECT ID AS prev FROM BEST WHERE ID < $current_id ORDER BY ID DESC LIMIT 1
SELECT ID AS next FROM BEST WHERE ID > $current_id LIMIT 1

m_tCh

I'm trying to get it but its still not working. What am I doing wrong?

Thanks!

include "functions.php";

//checkSession();

<html>

<head>

}

</head>

              </tr>
              <tr class="right">

              </tr>
              <tr class="right">
                <td colspan="3" class="case"><img src="images/blank.gif" width="1" height="1"></td>
              </tr>

              <tr class="ro">
                <td width="1%" align="center" class="listdata style2 style12" <%=$bgcolor%>>&nbsp;</td>
                <td width="99%" class="listdata" <%=$bgcolor%>><%
	$passed_vars = array_merge($_POST,$_GET);
	$sql = "SELECT * FROM BEST WHERE ID = '$passed_vars[sel_record]'";

	$sql_result = mysql_query($sql) or die (mysql_error());
	if (!$sql_result) {
		echo "Something has gone wrong!";
	} else {

		while ($record = mysql_fetch_array($sql_result)) {
			$$xsel_record = $record['ID'];
			$Name = stripslashes($record['Name']);
			$Def = stripslashes($record['Def']);
			$Condition = stripslashes($record['Condition']);
			$Standards = stripslashes($record['Standards']);
			$Best = stripslashes($record['Best']);
			$Num = stripslashes($record['Num']);
			$Keyr = stripslashes($record['Keyr']);
			$Level = stripslashes($record['Level']);
			$Ksa = stripslashes($record['Ksa']);
			$Bloom = stripslashes($record['Bloom']);
			$Info = $record['Info'];
			$Ass1 = stripslashes($record['Ass1']);
			$Ass2 = stripslashes($record['Ass2']);
			$Ass3 = stripslashes($record['Ass3']);
			$Ass4 = stripslashes($record['Ass4']);
			$Ass5 = stripslashes($record['Ass5']);
			$Ass6 = stripslashes($record['Ass6']);
			$Ass7 = stripslashes($record['Ass7']);
			$Ass8 = stripslashes($record['Ass8']);
			$Sim1 = stripslashes($record['Sim1']);
			$Sim2 = stripslashes($record['Sim2']);
			$Sim3 = stripslashes($record['Sim3']);
			$Sim4 = stripslashes($record['Sim4']);
			$Sim5 = stripslashes($record['Sim5']);
			$Sim6 = stripslashes($record['Sim6']);
			$Sim7 = stripslashes($record['Sim7']);
			$Sim8 = stripslashes($record['Sim8']);
		}
		$ID = "$xsel_record";

   		echo "

		<FORM method=\"POST\" action=\"best_domodrecordpost.php\">
		<INPUT TYPE=\"hidden\" name=\"ID\" value=\"$xsel_record\">
		<P><strong>Name: $Name </a><br>
		<P><strong>Definition:  $Def<br>
        <P><strong>Condition:  $Condition<br>			
        <P><strong>Standards:  $Standards<br>			
		<P><strong>Best Practices:  $Best<br>
		<P><strong>Primary:  $Num<br>
		<P><strong>Secondary: $Ass1  $Ass2  $Ass3  $Ass4  $Ass5  $Ass6  $Ass7  $Ass8<br>
		<P><strong>Similar: $Sim1  $Sim2  $Sim3  $Sim4  $Sim5  $Sim6  $Sim7  $Sim8<br>
		<P><strong>Key Resp. Area:  $Keyr<br>
		<P><strong>Career Level:  $Level<br>
		<P><strong>Knowledge, Skill, or Ability:  $Ksa <br>
		<P><strong>Bloom's Level: $Bloom <br>
		<P><strong>File Location:  $Info <br>

		";

}
%>

</td>

              </tr>

              <tr>

<%
$passed_vars = array_merge($POST,$GET);

	$sql = "SELECT AS prev FROM BEST WHERE ID < '$passed_vars[sel_record]' ORDER BY ID DESC LIMIT 1";

	$result = execSQL($sql);

	while (list($xsel_record) = mysql_fetch_array($result)) {

	$ID = "$xsel_record";
		%>
   	 <a href="best_calc.php?sel_record=<%=$xsel_record%>">goto record</a>
	   <%

}

%>[/b]

                <td height="19" colspan="3" class="baseline"><div align="center" class="ro"><a href="default.php">Home</a><P><FORM>

</P></div></td>
</tr>
</table></td>
</tr>
</table>
</div>
</div>
<div style="margin-bottom:10px;"></div>
</div>
</div>
<div align="center"> </div>
</div>

</body>

</html>

m_tCh

anyone?

Thanks in advance!

Roger_Ramjet

Echo/print the sql so you can check your query. Echo out the result set if you get one so you can see what is being returned. Post them here along with any error messages.

m_tCh

Here is the error I get and what it does output.I want it to have a link to the next record by ID but I don't know how to get it to work. Thank you so much for the help. I really appreciate it.

Database error - the webmaster has been notified.

There was an error on a dynamic website page.

Page: [url]http://www.__________.com/best/best_domodrecord3.php[/url]
Error: You have an error in your SQL syntax near 'AS prev FROM BEST WHERE ID < '112' ORDER BY ID DESC LIMIT 1' at line 1
SQL: SELECT AS prev FROM BEST WHERE ID < '112' ORDER BY ID DESC LIMIT 1
User: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.0.3705)
Browser: 205.----------

File: SHS-SM.3.2.92.K.3

Name: ACCIDENT INVESTIGATION & RECOVERY (VEHICLE & PRODUCT)

Definition: Complete accident investigation and recovery per directives.

Condition: At the depot, in the depot territory.

Standards: 100% compliance with Corporate and Federal Directives, Regulations, Policies and Procedures.

Best Practices: 100% compliance with Corporate and Federal Directives, Regulations, Policies and Procedures.

Primary: SM

Secondary: FM RM

Similar: DRM-RSS DMP SFLP

Key Resp. Area: 3

Career Level: 2

Knowledge, Skill, or Ability: K

Bloom's Level: 3

File Location: SM Task Analysis1.doc

m_tCh

please...this is important

Roger_Ramjet

You need to select something so

SQL: SELECT id AS prev FROM BEST WHERE ID < '112' ORDER BY ID DESC LIMIT 1

m_tCh

Ahhh. Thank you so much!