// fetch data from gallery category table order by g_id
$selectexhb=mysql_query("select * from gallery_category where type='Gallery' order by g_id desc limit $offset,$entries_per_page");
$num=mysql_num_rows($selectexhb);
if($num > 0)
{
while($selectexhb_fetch = mysql_fetch_array($selectexhb))
{
$name_cat=$selectexhb_fetch['category_name'];
$get=mysql_query("select * from gallery_images where category_name='$name_cat' order by g_id desc limit 1");
$num=mysql_query("select * from gallery_images where category_name='$name_cat' order by g_id");
if(mysql_num_rows($get)>0)
{
$imgget_fetch=mysql_fetch_array($get);
// to display image for category
$src_image=eregi_replace('boutique/','',$imgget_fetch['image']);
echo '
| '.$imgget_fetch['category_name'].' | ('.mysql_num_rows($num).' images) |
';
}
}
}
?>
|
|
if($num_rows > 9) { ?>
if($num_rows > 9) echo $pagination; ?> |
} if($num_rows ==0) { ?>
No Gallery Category Present |
} ?>
|
Event Planner |
$fetch_planner = mysql_query("select * from planner_artstudio where type='planner' and subtype='planner' order by startdate desc limit 5");
if(mysql_num_rows($fetch_planner)>0) {
while($rows = mysql_fetch_array($fetch_planner)) {
foreach($rows as $K1=>$V1) $$K1 = $V1;
?>
|
if($startdate !='') { ?>
Start Date:
$sd=explode('-',$startdate); echo $sd[2].'/'.$sd[1].'/'.$sd[0]; ?>
} ?> |
if($enddate !='') { ?>
End Date:
$ed=explode('-',$enddate); echo $ed[2].'/'.$ed[1].'/'.$ed[0]; ?>
} ?> |
|
}} ?>
|