Conference

AIR : Artificial Intelligence Research >> fields ::: ALL [ ] ::
3) { echo""; $i = 1; } echo ""; } mysql_close($conn); ?>
=$cf_field_name [ $cnt_rows ]

"000") { $strsql="select * from cf_feed f, cf_subfield s where f.cf_field_no=s.cf_field_no and f.cf_field_no='$cf_field_no' and f.cf_status='Y' and s.cf_field_status='Y' order by f.cf_deadline desc"; } else { $strsql="select * from cf_feed f, cf_subfield s where f.cf_field_no=s.cf_field_no and f.cf_status='Y' and s.cf_field_status='Y' order by f.cf_deadline desc"; } $result = mysql_query($strsql,$conn); $num_rows = mysql_num_rows($result); if (!empty($num_rows)) { $pageno = $_GET["pageno"]; $per_page = 15; if(!$pageno) $pageno = 1; $prev_pageno = $pageno - 1; $next_pageno = $pageno + 1; $page_start = ($per_page*$pageno)-$per_page; if($num_rows <= $per_page) $num_pages = 1; else if (($num_rows%$per_page)==0) $num_pages = ($num_rows/$per_page); else $num_pages = ($num_rows/$per_page)+1; $num_pages = (int)$num_pages; if(($page>$num_pages) || ($page<0)) echo "จำนวน $page มากกว่า $num_pages"; $strsql .= " LIMIT $page_start, $per_page"; $result = mysql_query($strsql); echo ""; echo ""; $sql = "SELECT cf_field_name FROM cf_subfield where cf_field_no='$cf_field_no'"; $result2 = mysql_query($sql,$conn); $rs2 = mysql_fetch_array($result2); if($rs2) { $fieldname = $rs2["cf_field_name"]; } else { $fieldname = "ALL"; } echo ""; echo ""; echo ""; echo "
$fieldname : $num_rows Conference(s) / $num_pages page(s)"; if ($prev_pageno) echo "<< Previous"; echo" [$pageno/$num_pages] "; if ($pageno != $num_pages) echo "Next >>"; echo "
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $no = $page_start; while($rs = mysql_fetch_array($result)) { $cf_no = $rs["cf_no"]; $cf_title = $rs["cf_title"]; $cf_startdate = $rs["cf_startdate"]; $cf_enddate = $rs["cf_enddate"]; $cf_place = $rs["cf_place"]; $cf_deadline = $rs["cf_deadline"]; $startdate = engformatDate($cf_startdate); $enddate = engformatDate($cf_enddate); $deadline = engformatDate($cf_deadline); if($rs['cf_index_link']=="") $cf_link = $rs['cf_link']; else $cf_link = $rs['cf_index_link']; $today = date("Ymd"); if($cf_deadline<$today) { $deadline = "$deadline"; } else { $deadline = "$deadline"; } $no = $no+1; if ($color=='#EEEEEE') $color = 'ivory'; else $color = '#EEEEEE'; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "
No.TitleDatePlaceDeadline
$no$cf_title$startdate - $enddate$cf_place$deadline
"; echo "
"; if($prev_pageno) echo "<< Previous"; echo " [ "; for($i=1; $i<=$num_pages; $i++) { if($i != $pageno) echo " $i "; else echo " $i "; } echo " ] "; if($pageno != $num_pages) echo "Next >>"; } else { echo "


"; echo ""; echo "
"; echo "
DATA NOT FOUND !!

"; echo "
"; } echo"
"; ?>