<?php
include_once("include/db_connection.php");
session_start();
if($_SESSION["adminloggedIn"] == FALSE){
header("Location:admin_login.php");
exit;
}
include_once("config_admin.php");
checkLoggedIn("yes");
include('header.php');
include('left1.php');
?>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<title>assign cell</title>
<meta name="keywords" content="" />
<meta name="Premium Series" content="" />
<link href="default.css" rel="stylesheet" type="text/css" media="screen" />
<script language="JavaScript" src="gen_validatorv31.js" type="text/javascript"></script>
<title>Untitled Document</title>
</head>
<body>
<div id="wrapper">
<!-- start page -->
<div id="page">
<!-- start content -->
<div id="prtCnt" align="center">
<div id="content" align="center">
<div class="post">
<h2 class="title"> </h2>
<div class="entry">
<?php
$EventAssociate = $_GET['EventAssociate'];
$sqlQuery = "SELECT * FROM rights where UserName='$EventAssociate'";
$result = MYSQL_QUERY($sqlQuery);
$numberOfRows = MYSQL_NUM_ROWS($result);
//echo $numberOfRows;
$i = 0;
// $row=mysql_fetch_array($result);
// print_r($row);
// $row=mysql_fetch_array($result);
// echo $row[EventName];
?>
<form action="editCell.php?EventAssociate=<?php echo "$EventAssociate"?>" method="POST" name="user_cell" >
<table width="550" height="85" border="0" cellpadding="2" cellspacing="2" >
<tr><td>eventname</td><td>Sponsorships</td><td>EventAdministration</td><td>Hospitality</td><td>Accounting</td><td>PublicRelations</td><td>SMSAlerts</td></tr>
<?php
//$row=mysql_fetch_array($result);
//$EventName = $result1['EventName'];
// echo $i;
//echo $numberOfRows;
while($i<($numberOfRows))
{
//if (($i%2)==0) { $bgColor = "#FFFFFF"; } else { $bgColor = "#C3D4FF"; }
$row=mysql_fetch_array($result);
$EventName = $row[EventName];
// echo $row[EventName];
$Sponsorships = $row[Sponsorships];
echo $Sponsorships;
$EventAdministration = $row[EventAdministration];
$Hospitality = $row[Hospitality];
$Accounting = $row[Accounting];
$PublicRelations = $row[PublicRelations];
$SMSAlerts = $row[SMSAlerts];
if($EventName!=NULL){ ?>
<td><?php echo $EventName; ?></td>
<td>
<?php if($Sponsorships==1) { ?><input name="<?php echo "$EventName"."_" ?>Sponsorships" type="checkbox" value="1" checked /><?php } else { ?> <input name="<?php echo "$EventName"."_" ?>Sponsorships" type="checkbox" value="1" /><?php } ?> </td><td>
<?php if($EventAdministration==1) { ?><input name="<?php echo "$EventName"."_" ?>EventAdministration" type="checkbox" value="1" checked /><?php } else { ?> <input name="<?php echo "$EventName"."_" ?>EventAdministration" type="checkbox" value="1" /><?php } ?> </td><td>
<?php if($Hospitality==1) { ?><input name="<?php echo "$EventName"."_" ?>Hospitality" type="checkbox" value="1" checked="checked" /><?php } else { ?> <input name="<?php echo "$EventName"."_" ?>Hospitality" type="checkbox" value="1" /><?php } ?> </td><td>
<?php if($Accounting==1) { ?><input name="<?php echo "$EventName"."_" ?>Accounting" type="checkbox" value="1" checked="checked" /><?php } else { ?> <input name="<?php echo "$EventName"."_" ?>Accounting" type="checkbox" value="1" /><?php } ?> </td><td>
<?php if($PublicRelations==1) { ?><input name="<?php echo "$EventName"."_" ?>PublicRelations" type="checkbox" value="1" checked="checked" /><?php } else { ?> <input name="<?php echo "$EventName"."_" ?>PublicRelations" type="checkbox" value="1" /><?php } ?> </td><td>
<?php if($SMSAlerts==1) { ?><input name="<?php echo "$EventName"."_" ?>SMSAlerts" type="checkbox" value="1" checked="checked" /><?php } else { ?> <input name="<?php echo "$EventName"."_" ?>SMSAlerts" type="checkbox" value="1" /><?php } ?> </td>
</tr>
<?php
}
$i++; }
?>
<tr>
<td><div align="right">
<input type="submit" name="submit" value="update" onclick="return document.returnValue"/>
</div></td>
</tr>
</table>
</p>
</div>
</div>
</div>
</div>
<!-- end content -->
<!-- start sidebars -->
<!-- end sidebars -->
<div style="clear: both;"> </div>
</div>
<!-- end page -->
</div>
</body>
<!--
<td><?php if($Sponsorships==1) { $checked="checked" ;}else{$checked="";} ?> <input type="radio" name="<?php echo "Sponsorships_"."$EventName";?>" <?php echo $checked;?>/></td>
<td><?php if($eventAdministration==1) { $checked="checked" ;}else{$checked="";} ?> <input type="radio" name="<?php echo "eventAdministration_"."$EventName";?>"<?php echo $checked;?>/></td>
<td><?php if($Hospitality==1) { $checked="checked" ;}else{$checked="";} ?> <input type="radio" name="<?php echo "Hospitality_"."$EventName";?>"<?php echo $checked;?>/></td>
<td><?php if($Accounting==1) { $checked="checked" ;}else{$checked="";} ?> <input type="radio" name="<?php echo "Accounting_"."$EventName";?>" <?php echo $checked;?>/></td>
<td><?php if($PublicRelations==1) { $checked="checked" ;}else{$checked="";} ?> <input type="radio" name="<?php echo "PublicRelations_"."$EventName";?>" <?php echo $checked;?>/></td>
<td><?php if($SMSAlerts==1) { $checked="checked" ;}else{$checked="";} ?> <input type="radio" name="<?php echo "SMSAlerts_"."$EventName";?>" <?php echo $checked;?>/></td>
-->
<?php
include('footer.php');
?>