0) { $i=1; $txt.=''; while ($rs=mysql_fetch_array($re)) { $prop_name=$rs['prop_name']; $offer_name=strtoupper($rs['offer_name']); $description=stripslashes($rs['detailtop']); $thumbnail=$rs['pic']; $terms_conditions=stripslashes($rs['terms']); $link=stripslashes($rs['detailmid']); $nlink=strlen(strip_tags(trim($link))); if($nlink>0){ $regisbut='

'; }else{ $regisbut='

'; } $boxName = str_replace(' ', '_', $offer_name); $term=''; $nTerm=strlen(strip_tags(trim($terms_conditions))); if ($nTerm>0) { $term='

'.$regisbut.'

Terms & Conditions

'; } else { $term='

'.$regisbut.'

'; } $txt.='

'.$offer_name.'

'.$description.'

'.$term.'

'; $i++; } //end while } mysql_free_result($re); return $txt; } function offer_lav($GroupName){ global $conn; $sql="SELECT prop_name, offer_name, pic, detailtop, detailmid, terms FROM ".TBL_OFFER." WHERE is_active='1' and prop_id='LAVENDER' and group_name='$GroupName' ORDER BY sort_order "; $re=mysql_query($sql, $conn); $num=mysql_num_rows($re); if ($num>0) { $i=1; $txt.=''; while ($rs=mysql_fetch_array($re)) { $prop_name=$rs['prop_name']; $offer_name=strtoupper($rs['offer_name']); $description=stripslashes($rs['detailtop']); $thumbnail=$rs['pic']; $terms_conditions=stripslashes($rs['terms']); $link=stripslashes($rs['detailmid']); $nlink=strlen(strip_tags(trim($link))); if($nlink>0){ $regisbut='

'; }else{ $regisbut='

'; } $boxName = str_replace(' ', '_', $offer_name); $term=''; $nTerm=strlen(strip_tags(trim($terms_conditions))); if ($nTerm>0) { $term='

'.$regisbut.'

Terms & Conditions

'; } else { $term='

'.$regisbut.'

'; } $txt.='

'.$offer_name.'

'.$description.'

'.$term.'

'; $i++; } //end while } mysql_free_result($re); return $txt; } function offer_jalan($GroupName){ global $conn; $sql="SELECT prop_name, offer_name, pic, detailtop, detailmid, terms FROM ".TBL_OFFER." WHERE is_active='1' and prop_id='JALANBESAR' and group_name='$GroupName' ORDER BY sort_order "; $re=mysql_query($sql, $conn); $num=mysql_num_rows($re); if ($num>0) { $i=1; $txt.=''; while ($rs=mysql_fetch_array($re)) { $prop_name=$rs['prop_name']; $offer_name=strtoupper($rs['offer_name']); $description=stripslashes($rs['detailtop']); $thumbnail=$rs['pic']; $terms_conditions=stripslashes($rs['terms']); $link=stripslashes($rs['detailmid']); $nlink=strlen(strip_tags(trim($link))); if($nlink>0){ $regisbut='

'; }else{ $regisbut='

'; } $boxName = str_replace(' ', '_', $offer_name); $term=''; $nTerm=strlen(strip_tags(trim($terms_conditions))); if ($nTerm>0) { $term='

'.$regisbut.'

Terms & Conditions

'; } else { $term='

'.$regisbut.'

'; } $txt.='

'.$offer_name.'

'.$description.'

'.$term.'

'; $i++; } //end while } mysql_free_result($re); return $txt; } function offer_paya($GroupName){ global $conn; $sql="SELECT prop_name, offer_name, pic, detailtop, detailmid, terms FROM ".TBL_OFFER." WHERE is_active='1' and prop_id='PAYALEBAR' and group_name='$GroupName' ORDER BY sort_order "; $re=mysql_query($sql, $conn); $num=mysql_num_rows($re); if ($num>0) { $i=1; $txt.=''; while ($rs=mysql_fetch_array($re)) { $prop_name=$rs['prop_name']; $offer_name=strtoupper($rs['offer_name']); $description=stripslashes($rs['detailtop']); $thumbnail=$rs['pic']; $terms_conditions=stripslashes($rs['terms']); $link=stripslashes($rs['detailmid']); $nlink=strlen(strip_tags(trim($link))); if($nlink>0){ $regisbut='

'; }else{ $regisbut='

'; } $boxName = str_replace(' ', '_', $offer_name); $term=''; $nTerm=strlen(strip_tags(trim($terms_conditions))); if ($nTerm>0) { $term='

'.$regisbut.'

Terms & Conditions

'; } else { $term='

'.$regisbut.'

'; } $txt.='

'.$offer_name.'

'.$description.'

'.$term.'

'; $i++; } //end while } mysql_free_result($re); return $txt; } function offer_slideB($GroupName){ global $conn; $txt='AQUEEN BALESTIER HOTEL

'; $sql="SELECT prop_name, offer_name, pic, detailtop, detailmid, terms FROM ".TBL_OFFER." WHERE is_active='1' and prop_id='BALESTIER' and group_name='$GroupName' ORDER BY sort_order "; $re=mysql_query($sql, $conn); $num=mysql_num_rows($re); if ($num>0) { $i=1; $txt.=''; while ($rs=mysql_fetch_array($re)) { $prop_name=$rs['prop_name']; $offer_name=stripslashes($rs['offer_name']); $description=stripslashes($rs['detailtop']); $thumbnail=$rs['pic']; $terms_conditions=stripslashes($rs['terms']); $link=stripslashes($rs['detailmid']); $nlink=strlen(strip_tags(trim($link))); if($nlink>0){ $regisbut='

'; }else{ $regisbut='

'; } $term=''; $nTerm=strlen(strip_tags(trim($terms_conditions))); if ($nTerm>0) { $term=' Terms & Conditions
'.$terms_conditions.' '; } else { $term=''; } $txt.='

'.$prop_name.'
'.$offer_name.'

'; $i++; } //end while } mysql_free_result($re); return $txt; } function offer_slideL($GroupName){ global $conn; $txt='AQUEEN LAVENDER HOTEL

'; $sql="SELECT prop_name, offer_name, pic, detailtop, detailmid, terms FROM ".TBL_OFFER." WHERE is_active='1' and prop_id='LAVENDER' and group_name='$GroupName' ORDER BY sort_order "; $re=mysql_query($sql, $conn); $num=mysql_num_rows($re); if ($num>0) { $i=1; $txt.=''; while ($rs=mysql_fetch_array($re)) { $prop_name=$rs['prop_name']; $offer_name=stripslashes($rs['offer_name']); $description=stripslashes($rs['detailtop']); $thumbnail=$rs['pic']; $terms_conditions=stripslashes($rs['terms']); $link=stripslashes($rs['detailmid']); $nlink=strlen(strip_tags(trim($link))); if($nlink>0){ $regisbut='

'; }else{ $regisbut='

'; } $term=''; $nTerm=strlen(strip_tags(trim($terms_conditions))); if ($nTerm>0) { $term=' Terms & Conditions
'.$terms_conditions.' '; } else { $term=''; } $txt.='

'.$prop_name.'
'.$offer_name.'

'; $i++; } //end while } mysql_free_result($re); return $txt; } function offer_slideJ($GroupName){ global $conn; $txt='AQUEEN LAVENDER HOTEL

'; $sql="SELECT prop_name, offer_name, pic, detailtop, detailmid, terms FROM ".TBL_OFFER." WHERE is_active='1' and prop_id='JALANBESAR' and group_name='$GroupName' ORDER BY sort_order "; $re=mysql_query($sql, $conn); $num=mysql_num_rows($re); if ($num>0) { $i=1; $txt.=''; while ($rs=mysql_fetch_array($re)) { $prop_name=$rs['prop_name']; $offer_name=stripslashes($rs['offer_name']); $description=stripslashes($rs['detailtop']); $thumbnail=$rs['pic']; $terms_conditions=stripslashes($rs['terms']); $link=stripslashes($rs['detailmid']); $nlink=strlen(strip_tags(trim($link))); if($nlink>0){ $regisbut='

'; }else{ $regisbut='

'; } $term=''; $nTerm=strlen(strip_tags(trim($terms_conditions))); if ($nTerm>0) { $term=' Terms & Conditions
'.$terms_conditions.' '; } else { $term=''; } $txt.='

'.$prop_name.'
'.$offer_name.'

'; $i++; } //end while } mysql_free_result($re); return $txt; } function offer_slideP($GroupName){ global $conn; $txt='AQUEEN PAYA LEBAR HOTEL

'; $sql="SELECT prop_name, offer_name, pic, detailtop, detailmid, terms FROM ".TBL_OFFER." WHERE is_active='1' and prop_id='PAYALEBAR' and group_name='$GroupName' ORDER BY sort_order "; $re=mysql_query($sql, $conn); $num=mysql_num_rows($re); if ($num>0) { $i=1; $txt.=''; while ($rs=mysql_fetch_array($re)) { $prop_name=$rs['prop_name']; $offer_name=stripslashes($rs['offer_name']); $description=stripslashes($rs['detailtop']); $thumbnail=$rs['pic']; $terms_conditions=stripslashes($rs['terms']); $link=stripslashes($rs['detailmid']); $nlink=strlen(strip_tags(trim($link))); if($nlink>0){ $regisbut='

'; }else{ $regisbut='

'; } $term=''; $nTerm=strlen(strip_tags(trim($terms_conditions))); if ($nTerm>0) { $term=' Terms & Conditions
'.$terms_conditions.' '; } else { $term=''; } $txt.='

'.$prop_name.'
'.$offer_name.'

'; $i++; } //end while } mysql_free_result($re); return $txt; } ?> Singapore Hotel Discount| Aqueen Hotels | Hotel Offers and Promotions

Home > Offers > Best Available Rate

BEST AVAILABLE RATE

AQUEEN BALESTIER HOTEL

AQUEEN LAVENDER HOTEL

AQUEEN JALAN BESAR HOTEL

AQUEEN PAYA LEBAR HOTEL