$iss = 0;
$query = "SELECT news.spot1 FROM news, category where category.status2 = 1 and category.id = news.category order by news.id desc limit 16";
$result = mysql_query ($query) or die ("error");
while ($line = mysql_fetch_array($result)){?>
$iss = 0;
$query = "SELECT news.picture, news.image FROM news, category where category.status2 = 1 and category.id = news.category order by news.id desc limit 16";
$result = mysql_query ($query) or die ("error");
while ($line = mysql_fetch_array($result)){
?>
c>}else{?>}?>
}else{?>
c style="DISPLAY: none">}else{?>}?>
}?>
$iss = $iss+1;
}
?>
$iss = 0;
$ixx = 0;
$query = "SELECT news.id, news.subject, news.time, news.flash, news.video FROM news, category where category.status2 = 1 and category.id = news.category order by news.id desc limit 15";
$result = mysql_query ($query) or die ("error");
while ($line = mysql_fetch_array($result)){
$javahaber[] = $line[id];
?>
$query = "SELECT * FROM category where under = 1 order by id desc";
$result = mysql_query ($query) or die ("error");
while ($line = mysql_fetch_array($result)){$mansetalti[] = $line[id];}
$query = "SELECT id, subject, spot2, image, picture, video FROM news where category = $mansetalti[0] and id != $javahaber[0] and id != $javahaber[1] and id != $javahaber[2] and id != $javahaber[3] and id != $javahaber[4] and id != $javahaber[5] and id != $javahaber[6] and id != $javahaber[7] and id != $javahaber[8] and id != $javahaber[9] order by id desc limit 1";
$result = mysql_query ($query) or die ("error");
while ($line = mysql_fetch_array($result)){
?>
$query = "SELECT id, subject, spot2, image, picture, video FROM news where category = $mansetalti[1] and id != $javahaber[0] and id != $javahaber[1] and id != $javahaber[2] and id != $javahaber[3] and id != $javahaber[4] and id != $javahaber[5] and id != $javahaber[6] and id != $javahaber[7] and id != $javahaber[8] and id != $javahaber[9] order by id desc limit 1";
$result = mysql_query ($query) or die ("error");
while ($line = mysql_fetch_array($result)){
?>
$query = "SELECT id, subject, spot2, image, picture, video FROM news where category = $mansetalti[2] and id != $javahaber[0] and id != $javahaber[1] and id != $javahaber[2] and id != $javahaber[3] and id != $javahaber[4] and id != $javahaber[5] and id != $javahaber[6] and id != $javahaber[7] and id != $javahaber[8] and id != $javahaber[9] order by id desc limit 1";
$result = mysql_query ($query) or die ("error");
while ($line = mysql_fetch_array($result)){
?>
$query = "SELECT id, subject, spot2, image, picture, video FROM news where category = $mansetalti[3] and id != $javahaber[0] and id != $javahaber[1] and id != $javahaber[2] and id != $javahaber[3] and id != $javahaber[4] and id != $javahaber[5] and id != $javahaber[6] and id != $javahaber[7] and id != $javahaber[8] and id != $javahaber[9] order by id desc limit 1";
$result = mysql_query ($query) or die ("error");
while ($line = mysql_fetch_array($result)){
?>
$query = "SELECT * FROM category where status = 1 order by line";
$result = mysql_query ($query) or die ("table secemedim");
$i=1;
$ixx=1;
while ($line = mysql_fetch_array($result))
{
if ($i==1){echo "
$query2 = "SELECT id, subject, video FROM news where category = $line[id] order by id desc limit 5";
$result2 = mysql_query ($query2) or die ("error");
while ($line2 = mysql_fetch_array($result2)){
?>