// fetch data from gallery category table order by g_id
$selectexhb=mysql_query("select * from gallery_category where type='$type' order by g_id desc limit $offset,$entries_per_page");
$num1=mysql_num_rows($selectexhb);
if($num1 > 0)
{
while($selectexhb_fetch = mysql_fetch_array($selectexhb))
{
$name_cat=$selectexhb_fetch['category_name'];
$get=mysql_query("select * from boutique where category_name='$name_cat' order by b_id desc limit 1");
$num=mysql_query("select * from boutique where category_name='$name_cat' order by b_id desc");
mysql_num_rows($num);
if(mysql_num_rows($num)>0)
{
$imgget_fetch=mysql_fetch_array($get);
// to display image for category
$src_image=eregi_replace('boutique/','',$imgget_fetch['image']);
echo ' ';
}
}
}
?>
|
|
if($num_rows > 9) echo $pagination; ?> |
|
Advertisment |
// for text
$fetch_planner = mysql_query("select * from ads where from_page='$type' 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='$type' 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);?>
|
|
} } ?>
|