$Hsql = $_POST['Query'];
$Tsql = $_POST['TQuery'];
$Newsql = $_POST['Query'];
$Newsql .= " order by";
$Newsql .= getOrderStr($_POST['a']);
$Newsql .= getOrderStr($_POST['b']);
$Newsql .= getOrderStr($_POST['c']);
$Newsql .= getOrderStr($_POST['d']);
$Newsql .= getOrderStr($_POST['e']);
$Newsql = rtrim($Newsql, ",");
$hotelArray = selectHotels2($Newsql, $Tsql);
} else {
$Hsql = genHotelQuery();
$Tsql = genRoomTypeQuery('###', '***');
//echo $Hsql;
$hotelArray = selectHotels($Hsql);
}
//echo "Here: $Hsql<hr>";
//echo "Here: $Tsql";
//echo "$startDate,$endDate";
// $types = array(
// array('A' ,'180','60'),
// array('B' ,'280','60'),
// array('C' ,'380','60')
// );
// $hotel = array(
// 'name' =>'Bohua Hotel' ,
// 'addr' =>'Prince George Park' ,
// 'ph' => '123-45678',
// 'rating' =>'3' ,
// 'types' => $types
$method = $_GET['r'];
switch ($method) {
case 'selectUser':
echo selectUser();
break;
case 'selectLastShare':
echo selectLastShare();
break;
case 'selectMyPrize':
echo selectMyPrize();
break;
case 'selectCredits':
echo selectCredits();
break;
case 'selectHotels':
echo selectHotels();
break;
case 'selectComments':
echo selectComments();
break;
case 'addComment':
echo addComment();
break;
case 'addUser':
echo addUser();
break;
case 'updateShareEvent1':
echo updateShareEvent1();
break;
case 'updateShareEvent2':
echo updateShareEvent2();
