$page_title="リンク - 株式会社ドリームクリエーション"?>
$pan_list="> リンク"?>
include "db_connect.inc";
$query = " select category_no,category,date_format(insert_date,'%Y/%m/%d') as insert_date2,date_format(update_date,'%Y/%m/%d') as update_date2 ".
" from link_category_table ".
" where view_kbn='1' ".
" and language='1' ".
" order by jyunban ";
$result = mysql_query($query);
$query = " select link_no,link_name,link_url,explanation,category_no,view_kbn,date_format(insert_date,'%Y/%m/%d') as insert_date2,date_format(update_date,'%Y/%m/%d') as update_date2 ".
" from link_table ".
" where view_kbn='1' ".
" and language='1' ".
" order by category_no,jyunban ";
$result2 = mysql_query($query);
if(mysql_num_rows($result2)>=0){
while($rc2=mysql_fetch_object($result2)){
$count[$rc2->category_no]=intval($count[$rc2->category_no])+1;
$link_no[$rc2->category_no][$count[$rc2->category_no]]=$rc2->link_no;
$link_name[$rc2->category_no][$count[$rc2->category_no]]=$rc2->link_name;
$link_url[$rc2->category_no][$count[$rc2->category_no]]=$rc2->link_url;
$explanation[$rc2->category_no][$count[$rc2->category_no]]=$rc2->explanation;
}
}
?>
if(mysql_num_rows($result)>=0){
while($rc=mysql_fetch_object($result)){
?>
category)?>
|
|
if($count[$rc->category_no]>=0){
?>
for($i=1;$i<=$count[$rc->category_no];$i++){
?>
category_no][$i])?>
|
if($explanation[$rc->category_no][$i]!=""){ ?>
|
} ?>
|
}
?>
}
?>
}
}
?>
|
|
|