$top_menu = "event";
$box_mode = "wo";
// Includes headers
include("../include/header.php");
if(isset($_SESSION['p_seq_no']) == false || !$_SESSION['p_seq_no']) {
include "../member/login_page.php";
} else {
$rows1 = select_qry("m_event","event_num",$anum,$connect);
$com_row = select_qry("job_company","seq_num",$rows1[seq_num],$connect);
$query_category = "SELECT * FROM m_scategory WHERE num='$rows1[cate_num]'";
//echo $query_category;
include("../include/category.php");
$grey_box = $grey_box_tag;
$green_box_img = "icon11.gif";
$green_box = $catename;
if($rows1[scatenum]>1000000 && $rows1[scatenum] <2000000)
$photo_url="/images/eve_pic02.gif";
elseif($rows1[scatenum]>2000000 && $rows1[scatenum] <3000000)
$photo_url="/images/eve_pic01.gif";
elseif($rows1[scatenum]>3000000 && $rows1[scatenum] <4000000)
$photo_url="/images/eve_pic03.gif";
else
$photo_url="/images/eve_pic04.gif";
if($rows1[event_state]) {
$location_row = select_qry("local_area","no",$rows1[event_location],$connect);
$location = $location_row['city_name'];
if($location_row['town_name']) {
$location .= "-".$location_row['town_name'];
}
$location .= ", ".$location_row[state_name];
} else {
$location = "Not Mentioned";
}
if($rows1[venue]) {
$venue = $rows1[venue];
} else {
$venue = "Not Mentioned";
}
?>
|
|
 |
|
|
if(isset($_SESSION['p_seq_no']) && $_SESSION['p_seq_no']){
$session=1;
$attend_qry="Select * from m_att_event where event_num=$rows1[event_num] and seq_num=$_SESSION[p_seq_no]";
$attend_result=mysqli_query($attend_qry,$connect);
$attend_total=mysqli_num_rows($attend_result);
if($attend_total>0)
$attended=1;
else
$attended=0;
}
else{
$session=0;
}
if ($attend_total>0) mysql_free_result($attend_result);
$join_qry="Select count(*) from m_att_event where event_num=$rows1[event_num]";
$join_result=mysqli_query($join_qry);
$join_row=mysqli_fetch_array($join_result);
$join_total-$join_row[0];
if($join_total>=$rows1[event_max])
$overjoin=1;
else
$overjoin=0;
?>
if(isset($_SESSION['p_seq_no']) && $_SESSION['p_seq_no']){
if($attended){
echo"
";
echo " | ";
echo " Joined | ";
} else if(!$rows1[event_max]) {
echo"
";
echo " | ";
echo " Not Available | ";
}
elseif($overjoin==0){
echo"
";
echo " | ";
echo " Join | ";
}
}
?>
|
|
|
|
$att_qry="select count(*) from m_att_event where event_num=$rows1[event_num]";
$att_result=mysqli_query($att_qry,$connect);
$att_total=mysqli_fetch_array($att_result);
mysql_free_result($att_result);
?>
|
Joined |
|
|
|
|
if($_SESSION[p_seq_no]==$rows1[seq_num]){
?>
|
|
}
?>
$create_day=date('d/m/Y',strtotime($rows1[create_day]));
?>
Listed:
|
|
|
|
|
Venue
|
|
|
| Location |
|
|
$due_day=date('d/m/Y',strtotime($rows1[event_day]));
?>
| Date |
|
|
| Contact |
|
$mem_qry="SELECT email,id from member WHERE seq_num=$rows1[seq_num]";
$mem_result=mysqli_query($mem_qry,$connect);
$mem_row=mysqli_fetch_array($mem_result);
$email=$mem_row[email];
$host_id=$mem_row['id'];
mysql_free_result($mem_result);
?>
|
| |
|
$rows1[mobile]?> |
| Details |
|
|
| Host ID |
|
|
| |
|
|
|
|
|
|
//delete here?>
|
include("qnastart.php");
?>
|
|
}
include("../include/footer.php");
?>
| |