Location: PHPKode > projects > EasyFest > new/assignRightsToEventHead.php
<?php
include_once("include/db_connection.php");
	header("Expires: Thu, 17 May 2001 10:17:17 GMT");    // Date in the past
	header ("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT"); // always modified
	header ("Cache-Control: no-cache, must-revalidate");  // HTTP/1.1
	header ("Pragma: no-cache");                          // HTTP/1.0              
	session_start();
		if($_SESSION["loggedIn"] == FALSE){
		header("Location:admin_login.php");
		exit;
		
	 }include_once("config.php");
$UserName=$_SESSION['UserName'];

	include('header1.php');
	$query1=mysql_fetch_array(mysql_query("select UserName FROM users WHERE Type='1' AND  UserName='$UserName'" ));
if($UserName==$query1['UserName'] ){
	 echo $UserName;
	 include('left_user.php');}
	 else{
	
	 include('left_coord.php');
	}?>

<!--<script type="text/javascript">
void click(EventAssociate,EventName)
{
var url="editCell.php?EventAssociate="+EventAssociate+"&EventName="+EventName;
window.location = url;
}
</script>	 -->


<?php

	$EventHead = $_GET['EventHead'];
	$sqlQuery = "SELECT * FROM rights where UserName='$EventHead'";
  	$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];

 ?><html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<title>assign rights to event head</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">Assign Rights</h2><br>
	    <div class="entry">
<form action="EventHead_editCell.php?EventHead=<?php echo "$EventHead"?>" method="POST" name="user_cell" > 
<table width="550" height="85" border="0" cellpadding="2" cellspacing="2" >
<tr>
  <td bgcolor="#E6E6E6">Eventname</td>
  <td bgcolor="#E6E6E6">Sponsorships</td><td bgcolor="#E6E6E6">EventAdministration</td><td bgcolor="#E6E6E6">Hospitality</td><td bgcolor="#E6E6E6">Accounting</td><td bgcolor="#E6E6E6">PublicRelations</td><td bgcolor="#E6E6E6">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];
	
 ?>

<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>  


<!--	
<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>
		 -->	

    </p>
				</div>
		  </div>
		</div>
        </div>
        <!-- end content -->
		<!-- start sidebars -->
		<!-- end sidebars -->
	  <div style="clear: both;">&nbsp;</div>
	</div>
	<!-- end page -->
</div>
</html>
<?php
	include('footer.php');
?>
Return current item: EasyFest