require_once('../../Connections/obc.php'); $sound = $_GET['sound']; $video_id = $_GET['video_id']; mysql_select_db($database_obc,$obc); if ($sound != "off") { $sql= "select * from tb_situation_bgsound where used = '1'"; $result = mysql_query($sql, $obc) or die(mysql_error()); $record = mysql_fetch_array($result); $bgsound = "../../admin/room/situation/bgsound/files/$record[filename]"; } if ($video_id != "") { $sql1= "select * from tb_situation_multimedia where mul_id = '$video_id'"; $result1 = mysql_query($sql1, $obc) or die(mysql_error()); $record1 = mysql_fetch_array($result1); if ($record1[url] == "") { $multimedia = "../../admin/room/situation/multimedia/files/video/$record1[filename]"; } else { $multimedia = $record1[url]; } } $sql2= "select * from tb_situation_info where sit_id = '1'"; $result2 = mysql_query($sql2, $obc) or die(mysql_error()); $record2 = mysql_fetch_array($result2); $sql3= "select * from tb_situation_multimedia order by mul_id desc"; $result3 = mysql_query($sql3, $obc) or die(mysql_error()); ?>