<?php include("includes/db_connection.php");


    if(isset($_GET['cat_id']))
    {
        $cat_id=$_GET['cat_id'];

            $query="SELECT * FROM tbl_radio
        where category_id='".$cat_id."' ORDER BY tbl_radio.id DESC ";

    }
    else if(isset($_GET['latest']))
    {
        $limit=$_GET['latest'];
        $query="SELECT * FROM tbl_radio
        ORDER BY tbl_radio.id DESC LIMIT $limit";
        }
    else
    {
 $query="SELECT cid,category_name,category_image FROM tbl_category ORDER BY tbl_category.cid DESC ";
    }

    $resouter = mysql_query($query);

    $set = array();

    $total_records = mysql_num_rows($resouter);
    if($total_records >= 1){

      while ($link = mysql_fetch_array($resouter, MYSQL_ASSOC)){

        $set['Radio App'][] = $link;
      }
    }

     echo $val= str_replace('\\/', '/', json_encode($set));


?>