No Tour Available";break;} mysql_connect($server, $user, $pass); mysql_select_db($database) or die( "Unable to select database"); $vt_sql = "SELECT * FROM vt WHERE mls = $mls;"; $result = mysql_query($vt_sql); while (mysql_fetch_row($result)) /* Print the relevant information */ $i = 0; $number = mysql_num_rows($result); if ($number == 0){echo "

No Tour Available

";break;} $room1 = mysql_result($result,$i,"vt.room1"); $room2 = mysql_result($result,$i,"vt.room2"); $room3 = mysql_result($result,$i,"vt.room3"); $room4 = mysql_result($result,$i,"vt.room4"); $room5 = mysql_result($result,$i,"vt.room5"); $room6 = mysql_result($result,$i,"vt.room6"); $room7 = mysql_result($result,$i,"vt.room7"); $room1d = urldecode($room1); $room2d = urldecode($room2); $room3d = urldecode($room3); $room4d = urldecode($room4); $room5d = urldecode($room5); $room6d = urldecode($room6); $room7d = urldecode($room7); $agent_sql = "SELECT * FROM properties p, realtors r WHERE p.mls = $mls AND p.realtor = r.rid;"; $agent_result = mysql_query($agent_sql); $rname = mysql_result($agent_result,$i,'r.rname'); $rcompany = mysql_result($agent_result,$i,'r.rcompany'); $office = mysql_result($agent_result,$i,'r.office'); $remail = mysql_result($agent_result,$i,'r.remail'); $address = mysql_result($agent_result,$i,'p.address'); $map_result = mysql_query("SELECT p.mls, p.city, c.*, s.* FROM properties p, cities c, states s WHERE p.mls = $mls AND p.city = c.city_id AND c.state_id = s.state_id;"); $city_name = mysql_result($map_result,$i,'c.city'); $state = mysql_result($map_result,$i,'s.state_abbr'); $zip = mysql_result($agent_result,$i,'p.zip'); $planomatic = mysql_result($agent_result,$i,'p.planomatic'); $slideshow = mysql_result($agent_result,$i,'p.slideshow'); $address_d = urlencode($address); $city_d = urlencode($city_name); $sound = mysql_result($agent_result,$i,'p.sound'); ?>
Photo Gallery
Java not supported
";?> Java not supported
";?>


"; } } closedir($handle); } ?>