// fetch data from gallery category table order by id
$get=mysql_query("select * from gallery_images where category_name='$catname' order by g_id desc limit $offset,$entries_per_page");
if(mysql_num_rows($get)>0)
{
while($imgget_fetch=mysql_fetch_array($get))
{
// to display image for category
$src_image=eregi_replace('boutique/','',$imgget_fetch['image']);
echo '
| '.$imgget_fetch['title'].' |
';
}
}
?>
|
if($num_rows > 9) { ?>
if($num_rows > 9) echo $pagination; ?> |
} if($num_rows ==0) { ?>
No Gallery Images 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];?> } ?> |
|
}} ?>
List of Gallery categories
|
|
$get_cat=mysql_query("select * from gallery_category where type='Gallery' order by g_id limit 12");
$n=mysql_num_rows($get_cat);
while($get_fetch=mysql_fetch_array($get_cat))
{
if($get_fetch['category_name']!=$catname)
{
?>
|
|
} }
?>
|
View More... |
|
|