Location: PHPKode > projects > Gsys > php/directory_alum_info.php
<?PHP
//Filename : directory_alum_info.php
//Description :  Script to display alum users full information
//Author :  darc
//Last modified :  2006.12.20
    include '../includes/auth.php';
    include '../includes/db.php';
	include '../includes/vars.php';

//if show_all was checked, show all brothers.
    if($_POST[show_all] == true)
	{
    	$sql ="SELECT *  FROM $table_name ORDER BY l_name;";
    	$result = mysql_query($sql,$connection) or die(mysql_error());
	}

else if($_POST[show_all] == false)

	{
    	$sql ="SELECT pin_num, l_name, m_name, f_name, full_name, business, phone, address, town, state, zip, initiation_date, email, status FROM $table_name WHERE pin_num='$_POST[more_info]';";
    	$result = mysql_query($sql,$connection) or die(mysql_error());

//set variables
        while($row =mysql_fetch_array($result))
        {
    		$id = $row['pin_num'];
    		$f_name = $row['f_name'];
			$m_name = $row['m_name'];
    		$l_name = $row['l_name'];
			$full_name = $row['full_name'];
			$business = $row['business'];
            $phone = $row['phone'];
            $email = $row['email'];
            $address = $row['address'];
            $town = $row['town'];
            $state = $row['state'];
            $zip = $row['zip'];
            $initiation_date = $row['initiation_date'];
			$status = $row['status'];
        }
    }

//define page title
	
	$title = "$full_name";
	
?>

<?php include ('../includes/header.php');?>

		<div align="center">
        <h1><font size="5">Detailed Information For: <br /><?php echo "$full_name" ?></font></h1>
        </center> 
		<center> 
        <table width="71%" style="table">
          <tr> 
            <td width="31%">Name: </td>
            <td width="69%"><?php echo "$full_name" ?></td>
          </tr>
		            <tr> 
            <td>Business: </td>
            <td><?php echo "$business" ?></td>
          </tr>
          <tr> 
            <td>Phone: </td>
            <td><?php echo "$phone" ?></td>
          </tr>
          <tr> 
            <td>E-Mail: </td>
            <td><?php echo "$email" ?></td>
          </tr>
          <tr> 
            <td>Address: </td>
            <td><?php echo "$address" ?><br> <?php echo "$town" ?>, <?php echo "$state" ?> 
              <?php echo "$zip" ?></td>
          </tr>
          <tr> 
            <td>Initiation Date: </td>
            <td><?php echo "$initiation_date" ?></td>
          </tr>
		  <tr>
		  <td>Current Status: </td>
		  <td><?php echo "$status" ?></td>
		  </tr>
        </table>
      	</div>
<?php include ('../includes/footer.php');?>
Return current item: Gsys