01.<?php
02.$mn_select = "select * from cmb_menu ORDER BY mn_order ASC";
03.$result = mysql_query($mn_select);
04.$num_rows = mysql_num_rows($result);
05.
06.$prev_mn_id; $prev_mn_order;
07.$next_mn_id; $next_mn_order;
08.$row_number = 0;
09.for(;$row_number<$num_rows; $row_number++){
10.$prev_mn_id = 0;
11.$next_mn_id = 0;
12.if (@mysql_data_seek ($result , $row_number-1)) {
13.$prev_list = mysql_fetch_assoc($result);
14.$prev_mn_id = $prev_list["mn_id"];
15.$prev_mn_order = $prev_list["mn_order"];
16.}
17.if (@mysql_data_seek ($result , $row_number+1)) {
18.$next_list = mysql_fetch_assoc($result);
19.$next_mn_id = $next_list["mn_id"];
20.$next_mn_order = $next_list["mn_order"];
21.}
22.if (@mysql_data_seek ($result , $row_number)) {
23.$list = mysql_fetch_assoc($result);
24.}
25.?>
