|
|
query($sql728_2);
$resultn=mysqli_fetch_array($db_query);
$idb=$resultn[id];
$bannername=$resultn[bannername];
$owner=$resultn[owner];
$datetoset=$resultn[datetoset];
$datetoexpire=$resultn[datetoexpire];
$bannerfile=$resultn[bannerfile];
$bannertype=$resultn[bannertype];
$bannerurl=$resultn[bannerurl];
$bannerstxt=$resultn[bannerstxt];
$status=$resultn[status];
?>
 ";
}if ($bannertype == "img" and $bannerfile != "" and $bannerurl == "" and $bannerstxt == "" and $status == "99999")
{
echo " ";
}else if ($bannertype == "img" and $bannerfile == "" and $bannerurl == "" and $bannerstxt != "" and $status == "99999")
{
echo "$bannerstxt";
}else if ($bannertype == "fsh" and $bannerfile != "" and $bannerurl == "" and $bannerstxt == "" and $status == "99999")
{
?>
|
 |
|
query($select_type);
$num_rows=mysqli_num_rows($query_select);
if($num_rows<1){
echo "
ยังไม่มีกระทู้ใด ๆ เลยจ้า!";
}else{
$select="select * from jobs order by id desc";
$q_ry = $mysqli->query($select);
$num_rows=mysqli_num_rows($q_ry);
$pagesize=20;
$rt=$num_rows%$pagesize;
if($rt!=0)
{
$totalpage=floor($num_rows/$pagesize)+1;
}
else
{
$totalpage=floor($num_rows/$pagesize);
$toppic_id=1;
}
if(empty($page))
{
$page=1;
}
mysqli_free_result($q_ry);
$goto=($page-1)*$pagesize;
$sql_select_mem="Select * From jobs order by id desc limit $goto,$pagesize";
$fect=$mysqli->query($sql_select_mem);
if(!$fect)
{
("ติดต่อฐานข้อมูลไม่ได้".mysql_error());
exit;
}
$bgcount=0;
while($rows=mysqli_fetch_array($fect))
{
$idtopic =$rows['id'];
$topic =$rows['topic'];
$message =$rows['message'];
$read1 =$rows['read1'];
$dateregist =$rows['dateregist'];
$bgcount=$bgcount+1;
$bgmod=$bgcount%2;
if($bgmod==0){
$bgcolor="#ffffff";
}else{
$bgcolor="#CDCBCB";
}
$topic_show = mb_substr($topic,0,70,'UTF-8');
$sqlmem="select * from member where usermem='$userreply'";
$db_query=$mysqli->query($sqlmem);
$resultm=mysqli_fetch_array($db_query);
$idmember=$resultm[id];
$membername=$resultm[membername];
$point=$resultm[point];
$photoprivate=$resultm[photo];
?>
|
|
|
|
