fetch_array($result)){ $sql_check = "SELECT * FROM `attachment` WHERE `table_name` = 'job' AND `table_id` = '".$row['id']."'"; $result_check = mysql_query($sql_check); $count_check = mysql_num_rows($result_check); $list .= '
'.$row['year'].'
'.substr($row['e_content'],0,100).((strlen($row['e_content']) > 100)?'...':'').'
'.$row['client_name'].'
'.$row['work_nature'].'
'.(($count_check > 0)?'':'').'
'; } $rs = $db->query($sql); $total = mysql_num_rows($rs); $multipage = new MultiPage(); $multipage->total = $total; $multipage->perpage = $sys_perpage; $multipage->maxpage = $sys_maxpage; $multipage->offset = $sys_pageoffset; $multipage->curr_page = $page; $pagelists = $multipage->getpagelist(); $myval = ""; foreach($_GET as $key => $value) { if ($key != "page") $myval .= "&".$key."=".urlencode($value); } $pagelist = ""; $page_address = 'job.php'; //page list for ($i=0;$i 0) { $pagelist .= " | "; } if ($pagelists[$i] == $page) { $pagelist .= ''.$pagelists[$i].''; } else { $pagelist .= ''.$pagelists[$i].''; } } //prev page if ($multipage->getprev() != "") { $prevpage = '< PREV'; } else { $prevpage = '< PREV'; } //next page if ($multipage->getnext() != "") { $nextpage = 'NEXT >'; } else { $nextpage = 'NEXT >'; } //total page $totalpage = $multipage->gettotal(); ?> Vbond found =".$foundpos; $tmppage = "".substr($myBasePath, $foundpos+1); $tmppage=str_replace('.php','',$tmppage); //echo "
found =".$tmppage; if($_SERVER['QUERY_STRING']!=""){ // $tmppage.="?".$_SERVER['QUERY_STRING']; } $bannertype=$tmppage; ?>
Year
Description
Client Name
Work Nature