include("header.php")?>
$mid=$_REQUEST[mid];
$sqlst="select * from sub_menu where sub_id=$mid";
mysql_query($sqlst);
if($sqlarr=mysql_query($sqlst))
{
while($sqlrow=mysql_fetch_array($sqlarr))
{
$name=$sqlrow[sub_name];
$menu_id=$sqlrow[menu_id];
$descrd=$sqlrow[sub_discrbtion];
$sqlstd="select * from description where desc_id=$descrd";
mysql_query($sqlsdt);
if($sqlarrd=mysql_query($sqlstd))
{
while($sqlrowd=mysql_fetch_array($sqlarrd))
{
$descr=$sqlrowd[desc_details];
$introduction=$sqlrowd[introduction];
$objective=$sqlrowd[objective];
$target=$sqlrowd[target];
$outline=$sqlrowd[outline];
}}
$sqlstdma="select * from menu where menu_id=$menu_id";
mysql_query($sqlsdtma);
if($sqlarrdma=mysql_query($sqlstdma))
{
while($sqlrowdma=mysql_fetch_array($sqlarrdma))
{
$menu_name=$sqlrowdma[menu_name];
}}
}
}
?>
echo $name; ?>
if($descr==""){}else{?>
Description
echo $descr; ?>
} ?>
if($introduction==""){}else{?>
Introduction
echo $introduction; ?>
} ?>
if($objective==""){}else{?>
Objectives
echo $objective; ?>
} ?>
if($target==""){}else{?>
Target Audience
echo $target; ?>
} ?>
if($outline==""){}else{?>
echo $menu_name; ?> Outline
echo $outline; ?>
} ?>
Ref |
Location |
From |
To |
Cost |
$sqlst="select * from sub_menu where sub_id=$mid";
mysql_query($sqlst);
if($sqlarr=mysql_query($sqlst))
{
while($sqlrow=mysql_fetch_array($sqlarr))
{
$place=$sqlrow[place_id];
$name=$sqlrow[sub_name];
$sub_code=$sqlrow[sub_code];
$sub_from=$sqlrow[sub_from];
$sub_to=$sqlrow[sub_to];
}}
$sqlst2="select * from sub_menu where sub_name='$name' order by sub_from asc";
mysql_query($sqlst2);
if($sqlarr2=mysql_query($sqlst2))
{
while($sqlrow2=mysql_fetch_array($sqlarr2))
{
$sub_day=$sqlrow2[sub_day];
$sub_month=$sqlrow2[sub_month];
$sub_year=$sqlrow2[sub_year];
$sub_day_to=$sqlrow2[sub_day_to];
$sub_month_to=$sqlrow2[sub_month_to];
$sub_year_to=$sqlrow2[sub_year_to];
$datefrom=$sub_day."-".$sub_month."-".$sub_year;
$dateto=$sub_day_to."-".$sub_month_to."-".$sub_year_to;
$sub_price=$sqlrow2[sub_price];
$finalplace=$sqlrow2[place_id];
$sqlst3="select * from place where place_id=$finalplace";
mysql_query($sqlst3);
if($sqlarr3=mysql_query($sqlst3))
{
while($sqlrow3=mysql_fetch_array($sqlarr3))
{
?>
echo $sqlrow2[sub_code]; ?> |
echo $sqlrow3[place_name]; ?> |
echo $datefrom;?> |
echo $dateto;?> |
echo $sub_price;?> |
}}}}
?>
include("footer.php")?>