=$dateString;?>
|
|
|
|
|
] fade=[on]">
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$RSLatest = mysql_query("Select ContentID, Data5, Title, BasePath, Case When COALESCE(UrduTitle,'')='' Then Title Else UrduTitle End As Caption , ContentName,Case When COALESCE(fkParentSectionID,0)=0 Then fkSectionID Else fkParentSectionID End As Section From TblContents Where isEnabled=1 And COALESCE(fkParentSectionID,0)<>73 And COALESCE(fkSectionID,0)<>73 And COALESCE(fkParentSectionID,0)<>76 And COALESCE(fkSectionID,0)<>76 And DateLastModified >= '2100-01-01' Order By DateLastModified Desc, ContentID Desc Limit 0,5") or die ("No New updates. " . mysql_error());
if (mysql_num_rows($RSLatest) <= 0)
{
//echo("Record $p_bl_no not found");
//mysql_close($connect);
}
else
{
$rowBG=0;
while($rowArticle = mysql_fetch_object($RSLatest))
{
$ico="ar_y";
if($rowArticle->Section >=1 && $rowArticle->Section <= 6)
$ico="ar_r";
if($rowArticle->Section >=19 && $rowArticle->Section <= 28)
$ico="ar_b";
if($rowArticle->Section ==52)
$ico="ar_g";
?>
"> |
|
|
}
}
?>
|
|
|
$RSLatest = mysql_query("Select ContentID, Data5, Title, BasePath, Case When COALESCE(UrduTitle,'')='' Then Title Else UrduTitle End As Caption , ContentName,Case When COALESCE(fkParentSectionID,0)=0 Then fkSectionID Else fkParentSectionID End As Section From TblContents Where isEnabled=1 And COALESCE(fkParentSectionID,0)<>73 And COALESCE(fkSectionID,0)<>73 And COALESCE(fkParentSectionID,0)<>76 And COALESCE(fkSectionID,0) NOT IN (76,80,81,82) And DateLastModified < '2100-01-01' Order By DateLastModified Desc, ContentID Desc Limit 0,17") or die ("No New updates. " . mysql_error());
if (mysql_num_rows($RSLatest) <= 0)
{
//echo("Record $p_bl_no not found");
//mysql_close($connect);
}
else
{
$rowBG=0;
while($rowArticle = mysql_fetch_object($RSLatest))
{
$ico="ar_y";
if($rowArticle->Section >=1 && $rowArticle->Section <= 6)
$ico="ar_r";
if($rowArticle->Section >=19 && $rowArticle->Section <= 28)
$ico="ar_b";
if($rowArticle->Section ==52)
$ico="ar_g";
?>
"> |
|
|
}
}
$RSSplash = mysql_query("Select ContentID, Data6, Data5, Title, BasePath, Case When COALESCE(UrduTitle,'')='' Then Title Else UrduTitle End As Caption , ContentName,Case When COALESCE(fkParentSectionID,0)=0 Then fkSectionID Else fkParentSectionID End As Section From TblContents Where isEnabled=1 And COALESCE(Data6, '') <> '' Limit 0,1") or die ("No New updates. " . mysql_error());
if(mysql_num_rows($RSSplash) <= 0)
{
//echo("Record $p_bl_no not found");
//mysql_close($connect);
}
else
{
$rowSplash = mysql_fetch_object($RSSplash);
$splashUrdu = $rowSplash->Caption;
$splashEnglish = $rowSplash->Title;
$splashLink = MakeLink($rowSplash->ContentID,$rowSplash->BasePath,$rowSplash->Data5);
$splashBG = $rowSplash->Data6;
}
?>
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$RSMAS = mysql_query("Select EnglishTitle, UrduTitle, Venu, Filename, DATE_FORMAT(Dated, '%D %b %Y') As Batareekh, Duration, Filesize From TblBayan Where fkMuqarrirID=17 And COALESCE(UrduTitle,'')<>'' Order By BayanId Desc Limit 0,2") or die ("No New bayan. " . mysql_error());
$rowMAS = mysql_fetch_object($RSMAS);
?>
|
|
|
|
|
|
|
|
|
|
|
$RSMAS = mysql_query("Select EnglishTitle, UrduTitle, Venu, Filename, DATE_FORMAT(Dated, '%D %b %Y') As Batareekh, Duration, Filesize From TblBayan Where fkMuqarrirID=4 And COALESCE(UrduTitle,'')<>'' Order By Dated Desc Limit 0,4") or die ("No New bayan. " . mysql_error());
while($rowMAS = mysql_fetch_object($RSMAS))
{
?>
|
|
|
} ?>
|
|
$RSMTU = mysql_query("Select EnglishTitle, UrduTitle, Venu, Filename, DATE_FORMAT(Dated, '%D %b %Y') As Batareekh, Duration, Filesize From TblBayan Where fkMuqarrirID=3 And COALESCE(UrduTitle,'')<>'' Order By Dated Desc Limit 0,4") or die ("No New bayan. " . mysql_error());
while($rowMTU = mysql_fetch_object($RSMTU))
{
?>
|
|
|
} ?>
|
|
|
|
$RSMRU = mysql_query("Select EnglishTitle, UrduTitle, Venu, Filename, DATE_FORMAT(Dated, '%D %b %Y') As Batareekh, Duration, Filesize From TblBayan Where fkMuqarrirID=6 And COALESCE(UrduTitle,'')<>'' Order By Dated Desc Limit 0,2") or die ("No New bayan. " . mysql_error());
$rowMRU = mysql_fetch_object($RSMRU);
?>
$rowMRU = mysql_fetch_object($RSMRU);
?> |
|
|
|
|
|
|
|
$RSMTJ = mysql_query("Select EnglishTitle, UrduTitle, Venu, Filename, DATE_FORMAT(Dated, '%D %b %Y') As Batareekh, Duration, Filesize From TblBayan Where fkMuqarrirID=5 And COALESCE(UrduTitle,'')<>'' Order By Dated Desc Limit 0,2") or die ("No New bayan. " . mysql_error());
$rowMTJ = mysql_fetch_object($RSMTJ);
?>
$rowMTJ = mysql_fetch_object($RSMTJ);
?> |
|
|
|
|
|
|
|
|
|
|
$RSMAS = mysql_query("Select n.EnglishTitle, n.UrduTitle, n.Album, n.Filename, n.AudioCategory, tm.BasePath, n.Filesize, tm.UrduName From nasheeds n Inner Join TblMuqarrir tm On n.fkMuqarrirID=tm.MuqarrirID Order By DateModified Desc Limit 0,2") or die ("No New bayan. " . mysql_error());
while($rowMAS = mysql_fetch_object($RSMAS))
{
?>
|
|
|
} ?>
|
|
$RSMTU = mysql_query("Select EnglishTitle, UrduTitle, Venu, Filename, DATE_FORMAT(Dated, '%D %b %Y') As Batareekh, Duration, Filesize From TblBayan Where fkMuqarrirID=16 And COALESCE(UrduTitle,'')<>'' Order By Dated Desc Limit 0,2") or die ("No New bayan. " . mysql_error());
while($rowMTU = mysql_fetch_object($RSMTU))
{
?>
|
|
|
} ?>
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$RSMAS = mysql_query("Select EnglishTitle, UrduTitle, Venu, Filename, DATE_FORMAT(Dated, '%D %b %Y') As Batareekh, Duration, Filesize From TblBayan Where fkMuqarrirID=7 And COALESCE(UrduTitle,'')<>'' Order By BayanId Desc Limit 0,2") or die ("No New bayan. " . mysql_error());
$rowMAS = mysql_fetch_object($RSMAS);
?>
$rowMAS = mysql_fetch_object($RSMAS);
?> |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|