Dunya TV Latest Video - pakistan
$rss_eng=mysql_query("select * from news_main where news_id=".$_GET["id"]);
$rss_eng_data=mysql_fetch_array($rss_eng);
$rss=mysql_query("select news_related_video_name from news_images where news_id=".$_GET["id"]);
$rows=mysql_fetch_object($rss);
$video =$rows->news_related_video_name;
// $pieces = explode("/", $video);
// $vname1 = $pieces[0];
// $vname = $pieces[1];
$vdo_testname=explode(".",$video);
$vdo_testname=$vdo_testname[0];
?>
print $rss_eng_data['news_eng_heading'];?>
//print $vdo_testname;?>
$select_rimages=mysql_query("select topic_id from news_topic where news_id=".$_GET["id"]);
while($select_rimages_data=mysql_fetch_array($select_rimages))
{
$topic_array[]=$select_rimages_data['topic_id'];
}
if(sizeof($topic_array)!=0)
{
$topic_array2=implode(',',$topic_array);
//print_r($topic_array2);
$select_r_news=mysql_query("select distinct news_id from news_topic where topic_id in(".$topic_array2.") and news_id!=".$_GET["id"]);
$count=0;
// print "select distinct news_id from news_topic where topic_id in(".$topic_array2.") and news_id!=".$_GET["id"]";
while($select_r_news_data=mysql_fetch_array($select_r_news))
{
$select_images=mysql_query("select * from news_images where news_id=".$select_r_news_data['news_id']);
$select_images_data=mysql_fetch_array($select_images);
//print "select * from news_images where news_id=".$select_r_news_data['news_id']." ";
if($select_images_data['news_related_video_name']!='' and $select_images_data['news_img_related_videos_first_image']!='')
{
$st=strrchr($select_images_data['news_related_video_name'],'.');
if($select_images_data['news_related_video_name']!='' and $st=='.flv')
{
if($count==6)
{
break;
}
$count=$count+1;
echo"