include("mysql_header.php");
$query="select * from reviews where reviewtrue = '1' order by id asc";
$result=MYSQL_QUERY($query);
$number=MYSQL_NUMROWS($result);
$number=$number-1;
$sa1=mysql_result($result,$number,"subject");
$sa2=mysql_result($result,$number,"review");
$sa3=mysql_result($result,$number,"name");
$sa4=mysql_result($result,$number,"hotel_id");
//echo "-->".$sa4."<--";
$cv="select * from hotels_table where id=$sa4 ";
$res=MYSQL_QUERY($cv);
$nomara=0;
$sa5=mysql_result($res,$nomara,"name");
$cd="select name,max(viewed) from hotels_table group by viewed ";
$res1=MYSQL_QUERY($cd);
$nomara1=MYSQL_NUMROWS($res1);
$nomara1--;
$sa6=mysql_result($res1,$nomara1,"name");
$sa7=mysql_result($res1,$nomara1,"max(viewed)");
// uzun yazılar kısaltılıyor
//$sayi=30;
//while (($rest = substr($sa1, $sayi, 1)) != " ")
//{
//$sayi--;
//}
//$sa1 = substr($sa1, 0, $sayi);
//$sayi=1;
//while (($rest = substr($sa2, $sayi, 1)) != " ")
//{
//$sayi--;
//}
//$sa2 = substr($sa2, 0, $sayi) ;
//$sayi=20;
//while (($rest = substr($sa3, $sayi, 1)) != " ")
//{
//$sayi--;
//}
//$sa3 = substr($sa3, 0, $sayi);
?>
include("mysql_header.php");
$cd2="select id,max(viewed) from hotels_table group by viewed ";
$res2=MYSQL_QUERY($cd2);
$nomara2=MYSQL_NUMROWS($res2);
$nomara2--;
$sa8=mysql_result($res2,$nomara2,"id");
?>
print $sa6; ?>