Location: PHPKode > projects > Gsys > admin/pledge_roster.php
//Filename : pledge_roster.php
//Description : Roster of all pledges
//Author :  darc
//Last modified :  2006.12.20

    include '../includes/auth_pledge_ed.php';
    include '../includes/db.php';

//Select all the pledges from the database (where brothers.status == "pledge")
	$sql ="SELECT * FROM $table_name WHERE status = \"pledge\" ORDER BY l_name;";
	$result = mysql_query($sql,$connection) or die(mysql_error());

    $counter = 0;


<head><title>Current Pledge Roster</title></head>

<center><h2>Current Pledge Roster  ||  Generated <?php echo date("F j, Y, g:i a"); ?></h2></center>
<p><a href="pledge_man.php">Return to Pledge Administration</a></p>

<!-- Setup table to display results -->
<table width="100%" border="1" cellpadding="0" bordercolor="#CCCCCC" bgcolor="#FFFFFF">
<td width="6%"><strong>Index</strong></td>
<td><strong>Last Name</strong></td>
<td><strong>First Name</strong></td>

//Loop to print out all results
    while ($row =mysql_fetch_array($result))
		$l_name = $row['l_name'];
		$f_name = $row['f_name'];
        $id = $row['stu_num'];

<td><?php echo($counter); $counter++; ?></td>
<td><?php echo($l_name);?></td>
<td><?php echo($f_name);?></td>
<td><?php echo($id);?></td>

    } //Close loop


<p><a href="pledge_man.php">Return to Pledge Administration</a></p>


Return current item: Gsys