<?
$sql = "UPDATE `resortroom` SET `room_visit` = room_visit+1 WHERE `room_id` = '$room_id' ";
$rs = mysql_query($sql);
$sqlr="select * from resortroom where room_id = '$room_id' ";
$resultr=mysql_query($sqlr);
while($rowr=mysql_fetch_array($resultr))
{
$room_idroom = $rowr[room_idroom];
$room_type_id = $rowr[room_type_id];
$sqlt="select * from resorttyperoom where type_id = '$room_type_id' ";
$resultt=mysql_query($sqlt) or die ("notyperoom");
while($rowt=mysql_fetch_array($resultt))
{