| |
| Search Directory |
| More than just a dress, WeddingInTheSky.Com gives you full package of all your wedding needs. Your guide to easy access, faster search, array of choices of quality products and services – all just a click away ready to give you service. |
 |
 |
| Enter a keyword or select from the search options below. Leave it blank or unselected if not necessary. |
| |
Wedding in the Sky
Search result for: All ";
$query="SELECT * FROM wits_business WHERE $scategory $package bus_id > 0 and bus_searchactive=1 ORDER BY $scat;";
}
if(!empty($txtsearch))
{
print"Search result for: $txtsearch ";
$query="SELECT * FROM wits_business WHERE $scategory $package bus_searchactive = 1 and $scat like '%$txtsearch%' ORDER BY bus_name;";
}
$data=mysql_query($query);
$rows=mysql_num_rows($data);
print "![](\"images/line.gif\")
Search Found : $rows
";
if (!(isset($pagenum)))
{
$pagenum = 1;
}
$page_rows = 5;
$last = ceil($rows/$page_rows);
if ($pagenum < 1)
{
$pagenum = 1;
}
elseif ($pagenum > $last)
{
$pagenum = $last;
}
$max = 'limit ' .($pagenum - 1) * $page_rows .',' .$page_rows;
if(empty($txtsearch) and $rows!=0)
{
$query="SELECT * FROM wits_business WHERE $scategory $package bus_searchactive = 1 and bus_id > 0 ORDER BY $scat $max;";
}
if(!empty($txtsearch) and $rows!=0)
{
$query="SELECT * FROM wits_business WHERE $scategory $package bus_searchactive = 1 and $scat like '%$txtsearch%' ORDER BY bus_name $max;";
}
$result=mysql_query($query);
$num=mysql_num_rows($result);
$i=0;
while ($i < $num)
{
$bus_name=mysql_result($result,$i,"bus_name");
$bus_address=mysql_result($result,$i,"bus_address");
$bus_phone=mysql_result($result,$i,"bus_phone");
$bus_mobile=mysql_result($result,$i,"bus_mobile");
$bus_contactpersonel=mysql_result($result,$i,"bus_contactpersonel");
$bus_email=mysql_result($result,$i,"bus_email");
$bus_website=mysql_result($result,$i,"bus_website");
$bus_searchactive=mysql_result($result,$i,"bus_searchactive");
$bus_id=mysql_result($result,$i,"bus_id");
$bus_page=mysql_result($result,$i,"bus_page");
$bus_package =mysql_result($result,$i,"bus_package");
$bus_category =mysql_result($result,$i,"bus_category");
if($bus_package==1)
{
$bus_pack="Gold";
$color="GOLD";
}
if($bus_package==2)
{
$bus_pack="Silver";
$color="SILVER";
}
if($bus_package==3)
{
$bus_pack="Bronze";
$color="BRONZE";
}
if($bus_package==4)
{
$bus_pack="Free Listing";
$color="WHITE";
}
$bus_name=str_replace("$txtsearch", "$txtsearch", "$bus_name");
if($bus_package!="0")
{
$link="![](\"images/wits-left-arrow.jpg\") More Details";
}
else
{
$link="";
}
$cat_query="SELECT * FROM wits_categories WHERE cat_id=$bus_category";
$cat_result=mysql_query($cat_query);
$cat_num=mysql_num_rows($cat_result);
$cat_i=0;
while ($cat_i < $cat_num)
{
$cat_name=mysql_result($cat_result,$cat_i,"cat_name");
$cat_i++;
}
print" ";
print"| $bus_name | ";
print"| Package Type | : $bus_pack | ";
print"| Business Type | : $cat_name | ";
print"| Address | : $bus_address | ";
print"| Tel No(s). | : $bus_phone | ";
print"| Mobile No(s). | : $bus_mobile | ";
print"| Contact Person(s). | : $bus_contactpersonel | ";
print"| E-mail | : $bus_email | ";
print"| Website | : $bus_website | ";
print"| $link | ";
print" ";
print"![](\"images/dots.gif\") ";
$i++;
}
print"";
$numlimit=12;
$icount=0;
$plink=$pagenum-6;
if($plink <= 0)
{
$plink=1;
}
while($icount < $numlimit)
{
if($plink < $last)
{
$bplink=$plink;
if($bplink==$pagenum)
{
$bplink="$bplink";
}
print"$bplink ";
$plink=$plink+1;
}
$icount++;
}
print"
";
//Switch
if ($pagenum == 1 or $rows==0)
{
}
else
{
echo " First ";
print" Page $pagenum of $last ";
$previous = $pagenum-1;
echo " Previous ";
}
if ($pagenum == $last or $rows==0)
{
}
else {
$next = $pagenum+1;
echo" Next ";
print" Page $pagenum of $last ";
echo" Last ";
}
}
//Switch
print"";
?>
Wedding In The Sky Search is Not Available Please Visit Later Press This to Continue
|
| |
Philippine wedding directory of WeddingInTheSky.Com gives you access and faster search to different business and establishments as well as group and individuals that offer services that will fit for you wedding needs. It includes wedding caterers, websites, destination and venues, accessories, banquets and balloons, wedding planner and coordinator, stylist, photographers and videographers, musicians and choirs, instrumentalist, confetti and fireworks, invitations and other more services.
Also, some establishments like churches, hotels, bar and restaurants, golf courses, conference and training centers are also on its listings. The listing includes all the information about companies, business establishments and individuals from the location, contact number, e-mails and websites.
Some of the finest companies like Towns Delight – The Caterer, Chef Mateo Catering Services, Republic of Cavite Restaurant and those listed at our Philippine wedding vendors page are also included on the directory list.
WeddingInTheSky.Com directory listing offers the best way of planning your wedding. |
|
|
| |
|
