$news_id=$_GET["news_id"];
$SQL = "SELECT subject,title,detail,ppic,ppics from news where news_id=$news_id and online=1 and lang_id=$lang_id "; // echo $SQL;
$result = mysqli_query($Conn, $SQL) or die ("xc2ไม่สามารถเรียกดููข้อมูในเทเบิลได้");
$num_rows = mysqli_num_rows($result);
$fetcharr = mysqli_fetch_array($result);
$num_rowss=$num_rows-1;
$subject= $fetcharr["subject"]; $subjectO= $fetcharr["subject"]; $subjectO=str_replace('"',"''",$subjectO);
$title= $fetcharr["title"];
$detail= $fetcharr["detail"];
$ppic= $fetcharr["ppic"];
$ppics= $fetcharr["ppics"];
?>
$tb="news";
$SQL2 = "SELECT pic.*,subject FROM pic,pic_desc where pic.id=pic_desc.id and pid=$news_id and tb='$tb' and picsub=1 and lang_id=$lang_id order by pic.id ";
//echo $SQL2 ;
$result2 = mysqli_query($Conn, $SQL2) or die ("ไม่สามารถเรียกดููข้อมูลในเทเบิลได้");
$num_rows2 = mysqli_num_rows($result2);
$fetcharr2 = mysqli_fetch_array($result2);
$num_rowss2=$num_rows2-1;
$b=0;
while($b<$num_rows2)
{
$idpic = $fetcharr2["id"];
$ppic = $fetcharr2["ppic"];
$subject = $fetcharr2["subject"];
?>
if ($b < $num_rowss2 or $b == $num_rowss2){
$b++;
if ($b < $num_rowss2 or $b == $num_rowss2){
$fetcharr2 = mysqli_fetch_array($result2);
$idpic = $fetcharr2["id"];
$ppic = $fetcharr2["ppic"];
$subject = $fetcharr2["subject"];
?>
}
}?>
if ($b < $num_rowss2 or $b == $num_rowss2){
$b++;
if ($b < $num_rowss2 or $b == $num_rowss2){
$fetcharr2 = mysqli_fetch_array($result2);
$idpic = $fetcharr2["id"];
$ppic = $fetcharr2["ppic"];
$subject = $fetcharr2["subject"];
?>
}
}?>
if ($b < $num_rowss2 or $b == $num_rowss2){
$b++;
if ($b < $num_rowss2 or $b == $num_rowss2){
$fetcharr2 = mysqli_fetch_array($result2);
$idpic = $fetcharr2["id"];
$ppic = $fetcharr2["ppic"];
$subject = $fetcharr2["subject"];
?>
}
}?>
$fetcharr2= mysqli_fetch_array($result2);?>
$b++;}?>