CHANNEL LIST CATEGORY WISE
$q3="SELECT Title FROM SMS_CATEGORY where Status=1 and id in (11,13,14,15,16,18,19,20,21,17,12)";
$stmt = $pdo->prepare($q3);
$stmt->execute();
$user = $stmt->fetchAll();
foreach($user as $value => $row){
$title = $row['Title']; ;
if(1==1)
{
?>
Notice: Undefined variable: title in E:\xampp\htdocs\channellist.php on line 50
}
else{
?>
Notice: Undefined variable: title in E:\xampp\htdocs\channellist.php on line 54
}
?>
$q2 ="SELECT w.Id as ChannelId,w.CategoryId,w.ChannelName,round(w.Price,0,2) as Price,c.Id,LogoExt,w.NCF FROM SMS_CHANNEL w
left outer join SMS_CATEGORY c on c.Id=w.CategoryId
where w.Status=1 and c.Title='".$title."'";
$stmt = $pdo->prepare($q2);
$stmt->execute();
$num_of_channels = $stmt->fetchAll();
$m = 0;
foreach($num_of_channels as $value => $row){
if($row['Id'] == "") break;
$channel_name=$row['ChannelName'];
$channel_Rate=$row['Price'];
$channel_LCN=$row['NCF'];
$logo="channel_".$row['ChannelId'];
$logoext=$row['LogoExt'];
if($m==0) echo "
}//for
?>
Notice: Undefined variable: title in E:\xampp\htdocs\channellist.php on line 50
Notice: Undefined variable: title in E:\xampp\htdocs\channellist.php on line 54
" . $channel_name . " MRP - " . $channel_Rate . " LCN - " . $channel_LCN . " | ";
$m++;
}//for
?>