Schools
|
$fetch_res = mysql_query("select * from school where competition='$COMP' order by school asc limit $offset,$entries_per_page");
if(mysql_num_rows($fetch_res)>0) {
$SlNo = 0;
while($rows_values = mysql_fetch_array($fetch_res)) {
$SlNo++;
foreach($rows_values as $K1=>$V1) $$K1 = $V1;
?>
|
} } ?>
if($num_rows > 15) { ?>
if($num_rows > 15) echo $pagination; ?> |
} ?>
if(mysql_num_rows($fetch_res)==0) { ?>
No Schools Found |
}
?>
|
Advertisment |
// for text
$fetch_planner = mysql_query("select * from ads where from_page='Results' and ad_text!='' order by id asc ");
mysql_num_rows($fetch_planner);
if(mysql_num_rows($fetch_planner)>0) {
while($rows = mysql_fetch_array($fetch_planner)) {
foreach($rows as $K1=>$V1) $$K1 = $V1;
if($to_page=='Latest Contest')
{
$display='list-latestcontest.php';
}
else if($to_page=='Results')
{
$display='list-competitions.php';
}
else if($to_page=='Events')
{
$display='list-events.php';
}
else if($to_page=='Art And Craft Club')
{
$display='idearoom.php?type=A';
}
else if($to_page=='Creative Corner')
{
$display='idearoom.php?type=C';
}
else if($to_page=='Art Products')
{
$display='boutique-category.php?type=A';
}
else if($to_page=='Other Products')
{
$display='boutique-category.php?type=O';
}
else if($to_page=='Training')
{
$display='list-artstudio.php?type=artstudio&stype=training';
}
else if($to_page=='Workshop')
{
$display='list-artstudio.php?type=artstudio&stype=workshops';
}
else if($to_page=='Demos')
{
$display='list-artstudio.php?type=artstudio&stype=demos';
}
else if($to_page=='Camp')
{
$display='list-artstudio.php?type=artstudio&stype=camp';
}
else if($to_page=='Photography')
{
$display='list-artstudio.php?type=artstudio&stype=Photography';
}
?>
|
} } ?>
// for text
$fetch_planner = mysql_query("select * from ads where from_page='Results' and ad_image!='' order by id asc ");
if(mysql_num_rows($fetch_planner)>0) {
while($rows = mysql_fetch_array($fetch_planner)) {
foreach($rows as $K1=>$V1) $$K1 = $V1;
if($to_page=='Latest Contest')
{
$display='list-latestcontest.php';
}
else if($to_page=='Results')
{
$display='list-competitions.php';
}
else if($to_page=='Events')
{
$display='list-events.php';
}
else if($to_page=='Art And Craft Club')
{
$display='idearoom.php?type=A';
}
else if($to_page=='Creative Corner')
{
$display='idearoom.php?type=C';
}
else if($to_page=='Art Products')
{
$display='boutique-category.php?type=A';
}
else if($to_page=='Other Products')
{
$display='boutique-category.php?type=O';
}
else if($to_page=='Training')
{
$display='list-artstudio.php?type=artstudio&stype=training';
}
else if($to_page=='Workshop')
{
$display='list-artstudio.php?type=artstudio&stype=workshops';
}
else if($to_page=='Demos')
{
$display='list-artstudio.php?type=artstudio&stype=demos';
}
else if($to_page=='Camp')
{
$display='list-artstudio.php?type=artstudio&stype=camp';
}
else if($to_page=='Photography')
{
$display='list-artstudio.php?type=artstudio&stype=Photography';
}
?>
$src_image=eregi_replace('boutique/','',$ad_image);?>
|
|
} } ?>
List of Competitions
|
$get_cat=mysql_query("SELECT * from competition order by year desc limit 10");
$n=mysql_num_rows($get_cat);
while($get_fetch=mysql_fetch_array($get_cat))
{
if($get_fetch['competition']!=$COMP)
{
?>
|
} }
?>
|
View More... |
|