session_start();
global $scode;
$linkID = mysql_connect("localhost", "root", "zangtang");
mysql_select_db("SciPark");
$Std = $_GET["StdNo"]; //$Std = "7";
$_SESSION["LN"] = "";
?>
SCP :: BRAIN TEASERS
//bgcolor="#C0C0C0" ?>
|
|
<<Back
|
BRAIN TEASERS |
| "Food for Thought" |
| |
|
$_SESSION["Cnt"] = 0;
$qry = "SELECT * FROM BrainTeaser where Tag = 'A' order by VidCode";
$result0 = mysql_db_query("SCPVideos", $qry) or die ("could not query1" . mysql_error());
$tung0=mysql_affected_rows();
$i=1;
if($tung0 != 0)
{
while ($r = mysql_fetch_array($result0))
{
$VidCode = $r["VidCode"];
$TopicName = $r["TopicName"];
$SubTopicName = $r["SubTopicName"]; // if($StdNo == "Select") $StdNo = "";
$CurrentVidNo = $r["CurrentVidNo"];
$VidDescription = $r["VidDescription"];
$VidLanguage = $r["VidLanguage"];
$PresenterName = $r["PresenterName"];
$VidURL = $r["VidURL"];
$VidDuration = $r["VidDuration"];
$VidDurationWebGo = $r["VidDurationWebGo"];
$SuppInfoDesc = $r["SuppInfoDesc"];
$RefLinks = $r["RefLinks"];
$Date = $r["Date"];
$Tag = $r["Tag"];
switch($VidLanguage)
{
case 'EN': $vl = "English"; break;
case 'MA': $vl = "Marathi"; break;
case 'HI': $vl = "Hindi"; break;
case 'EM': $vl = "English-Marathi"; break;
case 'EH': $vl = "English-Hindi"; break;
case 'MH': $vl = "Marathi-Hindi"; break;
} ?>
|
. |
| |
| |
| | |
if($SuppInfoDesc != "")
{
$qry1 = "SELECT * FROM Refdatabase where VidCode = '".$VidCode."'";
$result1 = mysql_db_query("SCPVideos", $qry1) or die ("could not queryN" . mysql_error());
$tung1=mysql_affected_rows();
if($tung1 != 0)
{
while ($r = mysql_fetch_array($result1))
{
$RefDesc[1]= $r["Desc1"]; $RefDesc[2]= $r["Desc2"]; $RefDesc[5]= $r["Desc5"]; $RefDesc[3]= $r["Desc3"]; $RefDesc[4]= $r["Desc4"];
$RefDesc[6]= $r["Desc6"]; $RefDesc[7]= $r["Desc7"]; $RefDesc[8]= $r["Desc8"]; $RefDesc[9]= $r["Desc9"]; $RefDesc[10]= $r["Desc10"];
$RefLink[1]= $r["Link1"]; $RefLink[2]= $r["Link2"]; $RefLink[5]= $r["Link5"]; $RefLink[3]= $r["Link3"]; $RefLink[4]= $r["Link4"];
$RefLink[6]= $r["Link6"]; $RefLink[7]= $r["Link7"]; $RefLink[8]= $r["Link8"]; $RefLink[9]= $r["Link9"]; $RefLink[10]= $r["Link10"];
$k=1;
for($z=0;$z<=10;$z++)
{
if($RefDesc[$z] !="" || $RefLink[$z] !="") { ?>
.
$k++; }
}
}
} }?>
| |
| |
$i++; }
} ?>
|
|