mysql结果< - 上一行和下一行，显示下一个确定

任何人都可以帮忙吗？


我查询数据库并在列引用上返回结果。

可能有7个列表。每行显示在一个表格中，

链接到详细信息页面。我正在制作一个之前的

记录和一个下一个记录。在详细信息页面上记录链接。


以下代码适用于下一个记录，通过在数组$ myarray中搜索变量$ ref的值

。然后它返回键值

值和键值，作为一个数字，扣除一个加上'

一个给我前一行和下一行。


返回下一行的值可以处理，但出于某种原因

前一行，扣除1，而它回显一个值屏幕，没有工作。


我会感激任何反馈，任何帮助。对于一个

的新手来说，这是一个挑战。


这是代码：


（查询数据库然后:)

// $ ref是一个进入页面的变量


$ num_rows = mysql_num_rows（$ result2）;


$ i = 0;

while（$ i< $ num_rows）{

$ next = mysql_result（$ result2， $ i，" reference"）;


++ $ i;


$ myarray = array（" $ i" => ;" $ next"）;

foreach（$ myarray as $ key => $ value）{

if（$ value ==" $ ref"） {


$ b =（$ key）;

$ c =（$ key + 1）;

$ a = （$ key-1）;


}}


if（$ a ==" 0"）{

echoNo Preceding Record;


} else {

if（$ key ==" $ a"）echo"< ;

href = .. / detail / index.php？name = $ value>上一条记录< / a>";

}


if（$ key ==" $ b"）e cho这是当前的记录;


if（$ num_rows< $ c）{

echo" Records End&quot ;;

} else {

if（$ key ==" $ c"） echo"< a href = .. / detail / index.php？name = $ value> Next

Record< / a>&quot ;;

}

}


}其他{

echo"抱歉，未找到任何记录&quot ;;

}


？>

Can anyone help?

I query a database and return a result on the column "reference".
There might be 7 listings. Each row is displayed in a table, with
links through to a detail page. I am working on having a "previous"
record and a "next" record link on the detail page.

This code below works, for the "next" record, by searching the values
in the array $myarray for the variable $ref. It then returns the key
value and the key value, as a number, is deducted by one and plus''d by
one to give me the previous row and the next row.

Returning the value of the next row works a treat, but for some reason
the previous row, deduct 1, while it echoes a value to screen, doesn''t
work.

I''d appreciate any feedback, any help. It''s been a challenge for a
newbie to sort this out.

This is the code:

(query database and then:)
//$ref is a variable carried into the page

$num_rows = mysql_num_rows($result2);

$i=0;
while ($i < $num_rows) {
$next=mysql_result($result2,$i,"reference");

++$i;

$myarray = array("$i"=>"$next");
foreach($myarray as $key=>$value) {
if ($value == "$ref"){

$b=($key);
$c=($key+1);
$a=($key-1);

}}

if ($a == "0") {
echo "No Preceding Record";

} else {
if ($key == "$a") echo "<a
href=../detail/index.php?name=$value>Previous Record</a>";
}

if ($key == "$b") echo "This is the current Record";

if ($num_rows < $c) {
echo "Records End";
} else {
if ($key == "$c") echo "<a href=../detail/index.php?name=$value>Next
Record</a>";
}
}

} else {
echo "Sorry, no records were found";
}

?>