현재값의 wr_id 값의 좌우버튼 클릭시 그위에값을 찾을려면 쿼리 어떻게 짜나요?? 정보
현재값의 wr_id 값의 좌우버튼 클릭시 그위에값을 찾을려면 쿼리 어떻게 짜나요??본문
if($wr_id>=$max_spt){
$right_link="javascript:(alert('최상위 입니다.'));";
}else{
//$right_link="$_SERVER['PHP_SELF']?sca=$sca&wr_id=$wr_id+1&bo_table=$bo_table";
$right_link=$_SERVER['PHP_SELF']."?sca=".$sca."&wr_id=".($wr_id+1)."&bo_table=".$bo_table;
}
if($wr_id<=$min_spt){
$left_link="javascript:(alert('최하위 입니다.'));";
}else{
//$right_link="$_SERVER['PHP_SELF']?sca=$sca&wr_id=$wr_id+1&bo_table=$bo_table";
$left_link=$_SERVER['PHP_SELF']."?sca=".$sca."&wr_id=".($wr_id-1)."&bo_table=".$bo_table;
}
현재값의 wr_id 값의 좌우버튼 클릭시 그위에값을 찾을려면 쿼리 어떻게 짜나요??
$right_link="javascript:(alert('최상위 입니다.'));";
}else{
//$right_link="$_SERVER['PHP_SELF']?sca=$sca&wr_id=$wr_id+1&bo_table=$bo_table";
$right_link=$_SERVER['PHP_SELF']."?sca=".$sca."&wr_id=".($wr_id+1)."&bo_table=".$bo_table;
}
if($wr_id<=$min_spt){
$left_link="javascript:(alert('최하위 입니다.'));";
}else{
//$right_link="$_SERVER['PHP_SELF']?sca=$sca&wr_id=$wr_id+1&bo_table=$bo_table";
$left_link=$_SERVER['PHP_SELF']."?sca=".$sca."&wr_id=".($wr_id-1)."&bo_table=".$bo_table;
}
현재값의 wr_id 값의 좌우버튼 클릭시 그위에값을 찾을려면 쿼리 어떻게 짜나요??
댓글 전체
$table_name = $g4[write_prefix].$bo_table ;
if($wr_id>=$max_spt){
$right_link="javascript:(alert('최상위 입니다.'));";
}else{
//$right_link="$_SERVER['PHP_SELF']?sca=$sca&wr_id=$wr_id+1&bo_table=$bo_table";
$row2 = sql_fetch("select wr_id from $table_name where wr_id > '$wr_id'");
$right_link=$_SERVER['PHP_SELF']."?sca=".$sca."&wr_id=".($row2[wr_id])."&bo_table=".$bo_table;
}
if($wr_id<=$min_spt){
$left_link="javascript:(alert('최하위 입니다.'));";
}else{
//$right_link="$_SERVER['PHP_SELF']?sca=$sca&wr_id=$wr_id+1&bo_table=$bo_table";
$row2 = sql_fetch("select wr_id from $table_name where wr_id < '$wr_id'");
$left_link=$_SERVER['PHP_SELF']."?sca=".$sca."&wr_id=".($row2[wr_id])."&bo_table=".$bo_table;
}
if($wr_id>=$max_spt){
$right_link="javascript:(alert('최상위 입니다.'));";
}else{
//$right_link="$_SERVER['PHP_SELF']?sca=$sca&wr_id=$wr_id+1&bo_table=$bo_table";
$row2 = sql_fetch("select wr_id from $table_name where wr_id > '$wr_id'");
$right_link=$_SERVER['PHP_SELF']."?sca=".$sca."&wr_id=".($row2[wr_id])."&bo_table=".$bo_table;
}
if($wr_id<=$min_spt){
$left_link="javascript:(alert('최하위 입니다.'));";
}else{
//$right_link="$_SERVER['PHP_SELF']?sca=$sca&wr_id=$wr_id+1&bo_table=$bo_table";
$row2 = sql_fetch("select wr_id from $table_name where wr_id < '$wr_id'");
$left_link=$_SERVER['PHP_SELF']."?sca=".$sca."&wr_id=".($row2[wr_id])."&bo_table=".$bo_table;
}
감사드립니다~