a

<?php
error_reporting(E_All);
$MYSQL_server = "localhost";
$MYSQL_username = 'enactus_social' ;
$MYSQL_password = 'enactus_social' ;
$MYSQL_database = 'enactus_social' ;
$dbConnect=mysql_pconnect($MYSQL_server , $MYSQL_username, $MYSQL_password)
or die(mysql_error());

mysql_select_db($MYSQL_database , $dbConnect)
or die(mysql_error());

	if(isset($_POST['EDIT'])){

		foreach($_POST['id'] as $key=>$value){
			//echo $key.'=>'.$value;
			$sql = "UPDATE users set id='$value' WHERE user_id = '$key'";
			mysql_query($sql) or die(mysql_error());
			usleep(1000);
		}

	}
?>
<form method='post'>
	<table width="100%">
	<tr>
		<td width="50%"><p>Old Members</p></td>
		<td width="50%"><p>New Members</p></td>
	</tr>
		<tr>
			<td>
<table border="1">
<tr>
	<td width="5%">#</td>
	<td width="19%">Name</td>
	<td width="19%"><?php if($_GET['show'] == 'mobile') echo 'Mobile'; elseif($_GET['show'] == 'faculty') echo 'Faculty';   elseif($_GET['show'] == 'email') echo 'Email';  else echo 'ID Number';?></td>
</tr>
<?php
$i = 1;
$result = mysql_query("SELECT * FROM users ORDER BY first_name,last_name") or die(mysql_error());
while ($row = mysql_fetch_assoc($result)){
  //echo 'ID:'.$row['id'];
  echo "<tr>
  <td>
  ".$i."
  </td>
  if($_GET['show']=="mobile")
  <td>".$row['first_name']." ".$row['last_name']."</td>";
	echo "<td>".$row['mobile']."</td>";
  elseif($_GET['show']=="faculty")
	echo "<td>".$row['faculty']."</td>";
  elseif($_GET['show']=="email")
	echo "<td>".$row['email']."</td>";
  else
	echo "<td>".$row['id']."<!-- <input name='id[{$row['user_id']}]' /> --></td>";
  echo "</tr>";
  ++$i;
}

?>
</table>
</td>
<td valign="top">
<table border="1">
<tr>
	<td width="5%">#</td>
	<td width="19%">Name</td>
	<td width="19%">ID Number</td>
</tr>
<?php
$i = 1;
$result = mysql_query("SELECT * FROM users where user_id > 500 ORDER BY first_name,last_name") or die(mysql_error());
while ($row = mysql_fetch_assoc($result)){
  //echo 'ID:'.$row['id'];
  echo "<tr>
  <td>
  ".$i."
  </td>
  <td>".$row['first_name']." ".$row['last_name']."</td>";
  if($_GET['show']=="mobile")
	echo "<td>".$row['mobile']."</td>";
  elseif($_GET['show']=="faculty")
	echo "<td>".$row['faculty']."</td>";
  elseif($_GET['show']=="email")
	echo "<td>".$row['email']."</td>";
  else
	echo "<td>".$row['id'] . ' - '. $row['first_name']." ".$row['last_name'] ."<!-- <input name='id[{$row['user_id']}]' /> --></td>";
  echo "</tr>";
  ++$i;
}

?>
</table>
</td>
</tr>
</table>
<!-- <input type="submit" name="EDIT" /> -->
</form>