11 Replies - 679 Views - Last Post: 12 December 2012 - 07:07 PM Rate Topic: -----

#1 lwaters  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 7
  • Joined: 11-December 12

Print records that are checked off

Posted 11 December 2012 - 07:02 PM

I am using Dreamweaver and PHP to create a list of students with checkboxes next to their names. When a user checks off a series of checkboxes and hits submit, I need a page to load where it grabs all of the content for that user's ID and print's out their profiles for each of the selected users. Is this possible using Dreamweaver and PHP?

Right now I have the form with the checkboxes that is set to the student ID number. These numbers are passed in the url. Then in the second page, it runs a query on the table where the ID equals the url ID and it displays the data in a nice report format. I tried to apply a repeat region to the data but, it won't allow me to have nested repeat regions so, I only get one of the student's data on the screen even though both student IDs were passed in the url.

I am not sure if there is a Dreamweaver extension that I can use or just hand-code this functionality. I am a newbie so, any help with this would be greatly appreciated. Thanks

Is This A Good Question/Topic? 0
  • +

Replies To: Print records that are checked off

#2 Dormilich  Icon User is offline

  • 痛覚残留
  • member icon

Reputation: 3541
  • View blog
  • Posts: 10,236
  • Joined: 08-June 10

Re: Print records that are checked off

Posted 11 December 2012 - 07:05 PM

without code, there is nothing we can help.

this is surely possible even without Dreamweaver.
Was This Post Helpful? 0
  • +
  • -

#3 lwaters  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 7
  • Joined: 11-December 12

Re: Print records that are checked off

Posted 11 December 2012 - 07:07 PM

I understand. I will post the code tomorrow since I don't have access to my work computer right now. Thanks again for your quick response. :)
Was This Post Helpful? 0
  • +
  • -

#4 lwaters  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 7
  • Joined: 11-December 12

Re: Print records that are checked off

Posted 12 December 2012 - 05:42 AM

Here is the coded for the form:

<form action="printable_version2_test.php" method="get"><fieldset id="el11">
                  <legend><strong>Search Results</strong></legend>
                  <table width="100%" border="0" cellspacing="1" cellpadding="6">
                    <tr>
                      <td valign="top"><?php do { ?>
                            <?php if ($totalRows_results > 0) { // Show if recordset not empty ?>
  <a href="profile.php?UID=<?php echo $row_results['UID']; ?>&amp;GCID=<?php echo $_GET['GCID']; ?>"> <?php echo $row_results['FNAME']; ?> <?php echo $row_results['LNAME']; ?></a> <input name="UID" type="checkbox" id="record" value="<?php echo $row_results['UID']; ?>" /><br />
  <?php } // Show if recordset not empty ?>
<?php } while ($row_results = mysql_fetch_assoc($results)); ?>
<?php if ($totalRows_results == 0) { // Show if recordset empty ?>
  <p>No applicants were found. <a href="search.php?GCID=<?php echo $_GET['GCID']; ?>">Search again</a>.
    <?php } // Show if recordset empty ?><input name="submit" type="submit" id="submit" value="Print" /></td>
                    </tr>
                  </table>
                  </fieldset></form>




Here is the code for the page with printable display:

<?php
date_default_timezone_set('America/New_York');
?>
<?php require_once('../../Connections/connect.php'); ?>
<?php
if (!isset($_SESSION)) {
  session_start();
}
$MM_authorizedUsers = "0,2,3,4,5,6,7";
$MM_donotCheckaccess = "false";

// *** Restrict Access To Page: Grant or deny access to this page
function isAuthorized($strUsers, $strGroups, $UserName, $UserGroup) { 
  // For security, start by assuming the visitor is NOT authorized. 
  $isValid = False; 

  // When a visitor has logged into this site, the Session variable MM_Username set equal to their username. 
  // Therefore, we know that a user is NOT logged in if that Session variable is blank. 
  if (!empty($UserName)) { 
    // Besides being logged in, you may restrict access to only certain users based on an ID established when they login. 
    // Parse the strings into arrays. 
    $arrUsers = Explode(",", $strUsers); 
    $arrGroups = Explode(",", $strGroups); 
    if (in_array($UserName, $arrUsers)) { 
      $isValid = true; 
    } 
    // Or, you may restrict access to only certain users based on their username. 
    if (in_array($UserGroup, $arrGroups)) { 
      $isValid = true; 
    } 
    if (($strUsers == "") && false) { 
      $isValid = true; 
    } 
  } 
  return $isValid; 
}

$MM_restrictGoTo = "error2.php";
if (!((isset($_SESSION['MM_Username'])) && (isAuthorized("",$MM_authorizedUsers, $_SESSION['MM_Username'], $_SESSION['MM_UserGroup'])))) {   
  $MM_qsChar = "?";
  $MM_referrer = $_SERVER['PHP_SELF'];
  if (strpos($MM_restrictGoTo, "?")) $MM_qsChar = "&";
  if (isset($_SERVER['QUERY_STRING']) && strlen($_SERVER['QUERY_STRING']) > 0) 
  $MM_referrer .= "?" . $_SERVER['QUERY_STRING'];
  $MM_restrictGoTo = $MM_restrictGoTo. $MM_qsChar . "accesscheck=" . urlencode($MM_referrer);
  header("Location: ". $MM_restrictGoTo); 
  exit;
}
?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {
  $insertSQL = sprintf("INSERT INTO stu_status (`UID`, SCHOLSEL, APP_STATUS) VALUES (%s, %s, %s) ON DUPLICATE KEY UPDATE APP_STATUS = ('$_POST[APP_STATUS]'), SCHOLSEL = ('$_POST[SCHOLSEL]')",
                       GetSQLValueString($_POST['UID'], "int"),
                       GetSQLValueString($_POST['SCHOLSEL'], "text"),
                       GetSQLValueString($_POST['APP_STATUS'], "text"));

  mysql_select_db($database_connect, $connect);
  $Result1 = mysql_query($insertSQL, $connect) or die(mysql_error());

  $insertGoTo = "../main_page.php?UID=" . $_GET['UID'] . "";
  if (isset($_SERVER['QUERY_STRING'])) {
    $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
    $insertGoTo .= $_SERVER['QUERY_STRING'];
  }
  header(sprintf("Location: %s", $insertGoTo));
}

$colname_your_sources = "-1";
if (isset($_GET['UID'])) {
  $colname_your_sources = $_GET['UID'];
}
mysql_select_db($database_connect, $connect);
$query_your_sources = sprintf("SELECT * FROM finaid WHERE `UID` = %s", GetSQLValueString($colname_your_sources, "int"));
$your_sources = mysql_query($query_your_sources, $connect) or die(mysql_error());
$row_your_sources = mysql_fetch_assoc($your_sources);
$totalRows_your_sources = mysql_num_rows($your_sources);

$colname_your_colleges1 = "-1";
if (isset($_GET['UID'])) {
  $colname_your_colleges1 = $_GET['UID'];
}
mysql_select_db($database_connect, $connect);
$query_your_colleges1 = sprintf("SELECT * FROM coll_exp WHERE `UID` = %s", GetSQLValueString($colname_your_colleges1, "int"));
$your_colleges1 = mysql_query($query_your_colleges1, $connect) or die(mysql_error());
$row_your_colleges1 = mysql_fetch_assoc($your_colleges1);
$totalRows_your_colleges1 = mysql_num_rows($your_colleges1);

$colname_your_application = "-1";
if (isset($_GET['UID'])) {
  $colname_your_application = $_GET['UID'];
}
mysql_select_db($database_connect, $connect);
$query_your_application = sprintf("SELECT * FROM stu_app2008 WHERE `UID` = %s", GetSQLValueString($colname_your_application, "int"));
$your_application = mysql_query($query_your_application, $connect) or die(mysql_error());
$row_your_application = mysql_fetch_assoc($your_application);
$totalRows_your_application = mysql_num_rows($your_application);

$colname_your_finances = "-1";
if (isset($_GET['UID'])) {
  $colname_your_finances = $_GET['UID'];
}
mysql_select_db($database_connect, $connect);
$query_your_finances = sprintf("SELECT * FROM fin_app WHERE `UID` = %s", GetSQLValueString($colname_your_finances, "int"));
$your_finances = mysql_query($query_your_finances, $connect) or die(mysql_error());
$row_your_finances = mysql_fetch_assoc($your_finances);
$totalRows_your_finances = mysql_num_rows($your_finances);

$colname_your_employ = "-1";
if (isset($_GET['UID'])) {
  $colname_your_employ = $_GET['UID'];
}
mysql_select_db($database_connect, $connect);
$query_your_employ = sprintf("SELECT * FROM employ WHERE `UID` = %s", GetSQLValueString($colname_your_employ, "int"));
$your_employ = mysql_query($query_your_employ, $connect) or die(mysql_error());
$row_your_employ = mysql_fetch_assoc($your_employ);
$totalRows_your_employ = mysql_num_rows($your_employ);

$colname_your_activities = "-1";
if (isset($_GET['UID'])) {
  $colname_your_activities = $_GET['UID'];
}
mysql_select_db($database_connect, $connect);
$query_your_activities = sprintf("SELECT * FROM activities WHERE `UID` = %s", GetSQLValueString($colname_your_activities, "int"));
$your_activities = mysql_query($query_your_activities, $connect) or die(mysql_error());
$row_your_activities = mysql_fetch_assoc($your_activities);
$totalRows_your_activities = mysql_num_rows($your_activities);

$colname_your_scholarships = "-1";
if (isset($_GET['UID'])) {
  $colname_your_scholarships = $_GET['UID'];
}
mysql_select_db($database_connect, $connect);
$query_your_scholarships = sprintf("SELECT * FROM users, activities, coll_exp, employ, fin_app, finaid, stu_app2008, stu_special WHERE users.`UID` = %s and stu_app2008.UID = %s and activities.UID = %s and employ.UID = %s and fin_app.UID = %s and finaid.UID = %s and coll_exp.UID = %s AND stu_special.`UID` = %s ORDER BY users.REG", GetSQLValueString($colname_your_scholarships, "int"),GetSQLValueString($colname_your_scholarships, "int"),GetSQLValueString($colname_your_scholarships, "int"),GetSQLValueString($colname_your_scholarships, "int"),GetSQLValueString($colname_your_scholarships, "int"),GetSQLValueString($colname_your_scholarships, "int"),GetSQLValueString($colname_your_scholarships, "int"),GetSQLValueString($colname_your_scholarships, "int"));
$your_scholarships = mysql_query($query_your_scholarships, $connect) or die(mysql_error());
$row_your_scholarships = mysql_fetch_assoc($your_scholarships);
$totalRows_your_scholarships = mysql_num_rows($your_scholarships);

$colname_scholarships = "-1";
if (isset($_GET['UID'])) {
  $colname_scholarships = $_GET['UID'];
}
mysql_select_db($database_connect, $connect);
$query_scholarships = sprintf("SELECT * FROM stu_schol, scholarships WHERE `UID` = %s and stu_schol.ID = scholarships.ID group by scholarships.ID ORDER BY scholarships.NAME", GetSQLValueString($colname_scholarships, "int"));
$scholarships = mysql_query($query_scholarships, $connect) or die(mysql_error());
$row_scholarships = mysql_fetch_assoc($scholarships);
$totalRows_scholarships = mysql_num_rows($scholarships);

$colname2_winners = "-1";
if (isset($_GET['UID'])) {
  $colname2_winners = $_GET['UID'];
}
mysql_select_db($database_connect, $connect);
$query_winners = sprintf("SELECT * FROM winners, scholarships WHERE winners.WINNERS = 'Y' and winners.ID = scholarships.ID and (APPLICANT1 = %s or APPLICANT2 = %s or APPLICANT3 = %s or APPLICANT4 = %s or APPLICANT5 = %s or APPLICANT6 = %s or APPLICANT7 = %s or APPLICANT8 = %s)", GetSQLValueString($colname2_winners, "int"),GetSQLValueString($colname2_winners, "int"),GetSQLValueString($colname2_winners, "int"),GetSQLValueString($colname2_winners, "int"),GetSQLValueString($colname2_winners, "int"),GetSQLValueString($colname2_winners, "int"),GetSQLValueString($colname2_winners, "int"),GetSQLValueString($colname2_winners, "int"));
$winners = mysql_query($query_winners, $connect) or die(mysql_error());
$row_winners = mysql_fetch_assoc($winners);
$totalRows_winners = mysql_num_rows($winners);

$colname_guidance = "-1";
if (isset($_GET['UID'])) {
  $colname_guidance = $_GET['UID'];
}
mysql_select_db($database_connect, $connect);
$query_guidance = sprintf("SELECT * FROM users, gc_codes WHERE `UID` = %s and gc_codes.GCID = users.GC", GetSQLValueString($colname_guidance, "int"));
$guidance = mysql_query($query_guidance, $connect) or die(mysql_error());
$row_guidance = mysql_fetch_assoc($guidance);
$totalRows_guidance = mysql_num_rows($guidance);

$colname_collegetotal1 = "-1";
if (isset($_GET['UID'])) {
  $colname_collegetotal1 = $_GET['UID'];
}
mysql_select_db($database_connect, $connect);
$query_collegetotal1 = sprintf("SELECT *, SUM(TUITION+TRANSPORT+PERSONAL+ROOMBD) FROM coll_exp WHERE UID = %s", GetSQLValueString($colname_collegetotal1, "int"));
$collegetotal1 = mysql_query($query_collegetotal1, $connect) or die(mysql_error());
$row_collegetotal1 = mysql_fetch_assoc($collegetotal1);
$totalRows_collegetotal1 = mysql_num_rows($collegetotal1);

$colname_collegetotal2 = "-1";
if (isset($_GET['UID'])) {
  $colname_collegetotal2 = $_GET['UID'];
}
mysql_select_db($database_connect, $connect);
$query_collegetotal2 = sprintf("SELECT *, SUM(TUITION2+TRANSPORT2+PERSONAL2+ROOMBD2) FROM coll_exp WHERE UID = %s", GetSQLValueString($colname_collegetotal2, "int"));
$collegetotal2 = mysql_query($query_collegetotal2, $connect) or die(mysql_error());
$row_collegetotal2 = mysql_fetch_assoc($collegetotal2);
$totalRows_collegetotal2 = mysql_num_rows($collegetotal2);

$colname_collegetotal3 = "-1";
if (isset($_GET['UID'])) {
  $colname_collegetotal3 = $_GET['UID'];
}
mysql_select_db($database_connect, $connect);
$query_collegetotal3 = sprintf("SELECT *, SUM(TUITION3+TRANSPORT3+PERSONAL3+ROOMBD3) FROM coll_exp WHERE UID = %s", GetSQLValueString($colname_collegetotal3, "int"));
$collegetotal3 = mysql_query($query_collegetotal3, $connect) or die(mysql_error());
$row_collegetotal3 = mysql_fetch_assoc($collegetotal3);
$totalRows_collegetotal3 = mysql_num_rows($collegetotal3);

$colname_special_attach = "-1";
if (isset($_GET['UID'])) {
  $colname_special_attach = $_GET['UID'];
}
$colname2_special_attach = "-1";
if (isset($_GET['ID'])) {
  $colname2_special_attach = $_GET['ID'];
}
mysql_select_db($database_connect, $connect);
$query_special_attach = sprintf("SELECT * FROM stu_special, scholarships WHERE `UID` = %s and stu_special.ID = %s and scholarships.id = %s", GetSQLValueString($colname_special_attach, "int"),GetSQLValueString($colname2_special_attach, "int"),GetSQLValueString($colname2_special_attach, "int"));
$special_attach = mysql_query($query_special_attach, $connect) or die(mysql_error());
$row_special_attach = mysql_fetch_assoc($special_attach);
$totalRows_special_attach = mysql_num_rows($special_attach);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
	<meta name="description" content="Cambridge Public Schools: Public schools built on a foundation of academic excellence and committed to promoting an environment of social justice.">
	<meta name="keywords" content="cambridge, massachusetts, ma, mass, public, school, district, k-12, public schools, cambridge public schools, school registration, cambridge schools, ma public schools, rindge and latin school, amigos school, morse school, tobin school, peabody school, fletcher-maynard academy, kennedy-longfellow, rindge school of technical arts, baldwin school, cambridgeport, graham & parks, haggerty school, martin luther king jr. school, cambridge rindge and latin, crls, falcon sports, superintendent young, cps">
	<meta name="robots" content="noarchive">
<link rel="shortcut icon" href="http://www3.cpsd.us/media/ImageElements/theme/CPS%20Redesign/favicon.ico?rev=1">
<link rel="stylesheet" type="text/css" href="https://secure2.cpsd.us/scholarship/form_styles.css" />
<style type="text/css">td img {display: block;}</style>
<style type="text/css">td img {margin: 0;}</style>
<link href="../text.css" rel="stylesheet" type="text/css" />
<title>Cambridge Rindge &amp; Latin School | 2012 Scholarship Standard Application</title>
<script TYPE="text/javascript">
<!--
function popup(mylink, windowname)
{
if (! window.focus)return true;
var href;
if (typeof(mylink) == 'string')
   href=mylink;
else
   href=mylink.href;
window.open(href, windowname, 'width=600,height=500,scrollbars=yes');
return false;
}
//-->
</SCRIPT>

</head>

<body>
<?php do { ?>
<table border="0" cellspacing="0" cellpadding="0" width="960px" align="center">
  <tbody>
<tr>
  <td colspan="3" valign="top">
  
  <table style="width: 100%;" border="0" cellspacing="0" cellpadding="5">
  <tbody>
  <tr>
  <td width="100%" valign="top">
    <table width="95%" border="0" align="center" cellpadding="0" cellspacing="0">
      <tbody>
        <tr>
          <td valign="top"><?php echo $row_your_scholarships['FNAME']; ?>&nbsp;<?php echo $row_your_scholarships['LNAME']; ?> | <?php echo $row_your_scholarships['NAME']; ?></td>
        </tr>
        <tr>
          <td width="100%" valign="top"><br>
            <h6>2012 Scholarship Standard Application</h6>
            <table width="100%" border="0" cellspacing="0" cellpadding="0">
              
              <tr>
                <td colspan="7" valign="top"><table width="98%" border="0" align="center" cellpadding="5" cellspacing="2">
                  <tr>
                    <td width="200%" colspan="2" valign="top"><fieldset id="el11"><legend><strong>Section 1: Applicant Information</strong></legend>
                      <table width="100%" border="0" cellspacing="1" cellpadding="6">
                        <tr bgcolor="#cccccc">
                          <td width="33%" valign="top"><strong>Name: </strong><?php echo $row_your_scholarships['FNAME']; ?>&nbsp;<?php echo $row_your_scholarships['LNAME']; ?></strong></font></strong></td>
                          <td valign="top"><strong>Gender: </strong><?php echo $row_your_scholarships['GENDER']; ?></strong></font></strong></td>
                          <td valign="top"><strong>SID: </strong><?php echo $row_your_scholarships['SID']; ?></strong></font></strong></td>
                          </tr>
                        <tr>
                          <td colspan="2" valign="top" bgcolor="#FFFFFF"><strong>Address: </strong><?php echo $row_your_scholarships['ADDRESS']; ?></strong></font></strong></td>
                          <td valign="top" bgcolor="#FFFFFF"><strong>Homeroom: </strong><?php echo $row_your_scholarships['HR']; ?></strong></font></strong></td>
                          </tr>
                        <tr bgcolor="#cccccc">
                          <td valign="top"><strong>Telephone: </strong><?php echo $row_your_scholarships['TEL']; ?></strong></font></strong></td>
                          <td valign="top"><strong>LC: </strong><?php echo $row_your_scholarships['LC']; ?></strong></font></strong></td>
                          <td valign="top"><strong>GC: </strong><?php echo $row_guidance['NAME']; ?></strong></font></strong></td>
                          </tr>
                        <tr>
                          <td valign="top" bgcolor="#FFFFFF"><strong>Email: </strong><?php echo $row_your_scholarships['UNAME']; ?></strong></font></strong></td>
                          <td colspan="2" valign="top" bgcolor="#FFFFFF"><strong>Elementary School:</strong> <?php echo $row_your_scholarships['ELEM']; ?></td>
                          </tr>
                        </table></fieldset></td>
                    </tr>
                  <tr>
                    <td colspan="2" valign="top"><fieldset id="el11">
                      <legend><strong>Section 2: Parent / Guardian Information</strong></legend><table width="100%" border="0" cellspacing="1" cellpadding="6">
                        <tr>
                          <td colspan="2" valign="top"><strong>PARENT / GUARDIAN #1</strong></td>
                          <td colspan="2" valign="top" bgcolor="#cccccc"><strong>PARENT / GUARDIAN #2</strong></td>
                          </tr>
                        <tr>
                          <td width="19%" valign="top"><strong>Name: </strong></td>
                          <td width="30%" valign="top"><label for="Name"><?php echo $row_your_scholarships['PARENT_A']; ?></label></td>
                          <td width="19%" valign="top" bgcolor="#cccccc"><strong>Name: </strong></td>
                          <td width="30%" valign="top" bgcolor="#cccccc"><?php echo $row_your_scholarships['PARENT_B']; ?></td>
                          </tr>
                        <tr>
                          <td valign="top"><strong>Address:</strong></td>
                          <td valign="top"><?php echo $row_your_scholarships['PAR_A_ADD']; ?></td>
                          <td valign="top" bgcolor="#cccccc"><strong>Address:</strong></td>
                          <td valign="top" bgcolor="#cccccc"><?php echo $row_your_scholarships['PAR_B_ADD']; ?></td>
                          </tr>
                        <tr>
                          <td valign="top"><strong>Telephone:</strong></td>
                          <td valign="top"><?php echo $row_your_scholarships['PAR_A_TEL']; ?></td>
                          <td valign="top" bgcolor="#cccccc"><strong>Telephone:</strong></td>
                          <td valign="top" bgcolor="#cccccc"><?php echo $row_your_scholarships['PAR_B_TEL']; ?></td>
                          </tr>
                        <tr>
                          <td valign="top"><strong>Relationship to Applicant:</strong></td>
                          <td valign="top"><?php echo $row_your_scholarships['PAR_A_REL']; ?></td>
                          <td valign="top" bgcolor="#cccccc"><strong>Relationship to Applicant:</strong></td>
                          <td valign="top" bgcolor="#cccccc"><?php echo $row_your_scholarships['PAR_B_REL']; ?></td>
                          </tr>
                        <tr>
                          <td valign="top"><strong>Occupation:</strong></td>
                          <td valign="top"><?php echo $row_your_scholarships['PAR_A_OCC']; ?></td>
                          <td valign="top" bgcolor="#cccccc"><strong>Occupation:</strong></td>
                          <td valign="top" bgcolor="#cccccc"><?php echo $row_your_scholarships['PAR_B_OCC']; ?></td>
                          </tr>
                        </table>
                      </fieldset></td>
                    </tr>
                  <tr>
                    <td colspan="2" valign="top"><fieldset id="el11">
                      <legend><strong>Section 3: School and Community Involvement</strong></legend><table width="100%" border="0" cellspacing="1" cellpadding="6"><tr>
                        <td width="45%" valign="top"><strong>Community Service Hours Completed to Date: </strong></td>
                        <td width="55%" valign="top"><?php echo $row_your_scholarships['COMMUNITY_SERVICE_HOURS']; ?></td>
                        </tr>
                        <tr>
                        <td colspan="2" valign="top">Below list the activities in which the student participated both in and out of school.</td>
                        </tr>
                        </table>
                      <table width="100%" border="0" cellspacing="1" cellpadding="6">
                        <tr bgcolor="#cccccc">
                          <td width="157" valign="top"><strong>Organization or Activity</strong></td>
                          <td width="127" valign="top"><strong>Grade 9</strong></td>
                          <td width="127" valign="top"><strong>Grade 10</strong></td>
                          <td width="127" valign="top" bgcolor="#cccccc"><strong>Grade 11</strong></td>
                          <td width="127" valign="top"><strong>Grade 12</strong></td>
                          <td width="154" valign="top"><strong>Position, Commendations, Honors, Awards</strong></td>
                          </tr>
                        <tr>
                          <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['ACTNAME']; ?></td>
                          <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['GR09']; ?></td>
                          <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['GR10']; ?></td>
                          <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['GR11']; ?></td>
                          <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['GR12']; ?></td>
                          <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['POSITION']; ?></td>
                          </tr>
                        <tr>
                          <?php /*START_PHP_SIRFCIT*/ if ($row_your_activities['ACTNAME2']<>""){ ?>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['ACTNAME2']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['GR09_2']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['GR10_2']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['GR11_2']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['GR12_2']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['POSITION2']; ?></td>
                            <?php } /*END_PHP_SIRFCIT*/ ?>
                          </tr>
                        <tr>
                          <?php /*START_PHP_SIRFCIT*/ if ($row_your_activities['ACTNAME3']<>""){ ?>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['ACTNAME3']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['GR09_3']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['GR10_3']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['GR11_3']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['GR12_3']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['POSITION3']; ?></td>
                            <?php } /*END_PHP_SIRFCIT*/ ?>
                          </tr>
                        <tr>
                          <?php /*START_PHP_SIRFCIT*/ if ($row_your_activities['ACTNAME4']<>""){ ?>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['ACTNAME4']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['GR09_4']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['GR10_4']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['GR11_4']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['GR12_4']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['POSITION4']; ?></td>
                            <?php } /*END_PHP_SIRFCIT*/ ?>
                          </tr>
                        <tr>
                          <?php /*START_PHP_SIRFCIT*/ if ($row_your_activities['ACTNAME5']<>""){ ?>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['ACTNAME5']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['GR09_5']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['GR10_5']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['GR11_5']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['GR12_5']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['POSITION5']; ?></td>
                            <?php } /*END_PHP_SIRFCIT*/ ?>
                          </tr>
                        <tr>
                          <?php /*START_PHP_SIRFCIT*/ if ($row_your_activities['ACTNAME6']<>""){ ?>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['ACTNAME6']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['GR09_6']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['GR10_6']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['GR11_6']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['GR12_6']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['POSITION6']; ?></td>
                            <?php } /*END_PHP_SIRFCIT*/ ?>
                        </tr>
                        <tr>
                          <?php /*START_PHP_SIRFCIT*/ if ($row_your_activities['ACTNAME7']<>""){ ?>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['ACTNAME7']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['GR09_7']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['GR10_7']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['GR11_7']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['GR12_7']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['POSITION7']; ?></td>
                            <?php } /*END_PHP_SIRFCIT*/ ?>
                        </tr>
                        <tr>
                          <?php /*START_PHP_SIRFCIT*/ if ($row_your_activities['ACTNAME8']<>""){ ?>
                          <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['ACTNAME8']; ?></td>
                          <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['GR09_8']; ?></td>
                          <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['GR10_8']; ?></td>
                          <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['GR11_8']; ?></td>
                          <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['GR12_8']; ?></td>
                          <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['POSITION8']; ?></td>
                          <?php } /*END_PHP_SIRFCIT*/ ?>
                        </tr>
                        </table>
                      </fieldset></td>
                    </tr>
                  <tr>
                    <td colspan="2" valign="top">&nbsp;</td>
                    </tr>
                  <tr>
                    <td colspan="2" valign="top"><fieldset id="el11">
                      <legend><strong>Section 4: Work Experience</strong></legend><?php do { ?><table width="100%" border="0" cellspacing="1" cellpadding="6">
                        <tr>
                          <td colspan="3" valign="top" bgcolor="#cccccc"><strong>EMPLOYER</strong></td>
                          </tr>
                        <tr>
                          <td width="33%" valign="top" bgcolor="#FFFFFF"><strong>Name</strong></td>
                          <td width="33%" valign="top" bgcolor="#FFFFFF"><strong>Position</strong></td>
                          <td width="33%" valign="top" bgcolor="#FFFFFF"><strong>Hours per Week</strong></td>
                          </tr>
                        <tr>
                          <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['EMPLOYER']; ?></td>
                          <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['JOBPOS']; ?></td>
                          <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['HRS_WK']; ?></td>
                          </tr>
                        <tr>
                          <td valign="top" bgcolor="#FFFFFF"><strong>Start Date</strong></td>
                          <td valign="top" bgcolor="#FFFFFF"><strong>End Date</strong></td>
                          <td valign="top" bgcolor="#FFFFFF"><strong>Pay per Hour</strong></td>
                          </tr>
                        <tr>
                          <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['START_MO']; ?>&nbsp;<?php echo $row_your_scholarships['START_YR']; ?></td>
                          <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['END_MO']; ?>&nbsp;<?php echo $row_your_scholarships['END_YR']; ?></td>
                          <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['PAY_HR']; ?></td>
                          </tr>
                        <?php /*START_PHP_SIRFCIT*/ if ($row_your_employ['EMPLOYER2']<>""){ ?>
                          <tr>
                            <td colspan="3" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
                              <tr>
                                <td height="1" valign="top" bgcolor="#706d66"><img src="../../images/spacer.png" alt="" width="1" height="1" /></td>
                                </tr>
                              </table></td>
                            </tr>
                          <tr>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Name</strong></td>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Position</strong></td>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Hours per Week</strong></td>
                            </tr>
                          <tr>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['EMPLOYER2']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['JOBPOS2']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['HRS_WK2']; ?></td>
                            </tr>
                          <tr>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Start Date</strong></td>
                            <td valign="top" bgcolor="#FFFFFF"><strong>End Date</strong></td>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Pay per Hour</strong></td>
                            </tr>
                          <tr>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['START_MO2']; ?>&nbsp;<?php echo $row_your_scholarships['START_YR2']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['END_MO2']; ?>&nbsp;<?php echo $row_your_scholarships['END_YR2']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['PAY_HR2']; ?></td>
                            </tr>
                          <?php } /*END_PHP_SIRFCIT*/ ?>
                        <?php /*START_PHP_SIRFCIT*/ if ($row_your_employ['EMPLOYER3']<>""){ ?>
                          <tr>
                            <td colspan="3" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
                              <tr>
                                <td height="1" valign="top" bgcolor="#706d66"><img src="../../images/spacer.png" alt="" width="1" height="1" /></td>
                                </tr>
                              </table></td>
                            </tr>
                          <tr>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Name</strong></td>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Position</strong></td>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Hours per Week</strong></td>
                            </tr>
                          <tr>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['EMPLOYER3']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['JOBPOS3']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['HRS_WK3']; ?></td>
                            </tr>
                          <tr>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Start Date</strong></td>
                            <td valign="top" bgcolor="#FFFFFF"><strong>End Date</strong></td>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Pay per Hour</strong></td>
                            </tr>
                          <tr>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['START_MO3']; ?>&nbsp;<?php echo $row_your_scholarships['START_YR3']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['END_MO3']; ?>&nbsp;<?php echo $row_your_scholarships['END_YR3']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['PAY_HR3']; ?></td>
                            </tr>
                          <?php } /*END_PHP_SIRFCIT*/ ?>
                        <?php /*START_PHP_SIRFCIT*/ if ($row_your_employ['EMPLOYER4']<>""){ ?>
                          <tr>
                            <td colspan="3" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
                              <tr>
                                <td height="1" valign="top" bgcolor="#706d66"><img src="../../images/spacer.png" alt="" width="1" height="1" /></td>
                                </tr>
                              </table></td>
                            </tr>
                          <tr>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Name</strong></td>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Position</strong></td>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Hours per Week</strong></td>
                            </tr>
                          <tr>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['EMPLOYER4']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['JOBPOS4']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['HRS_WK4']; ?></td>
                            </tr>
                          <tr>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Start Date</strong></td>
                            <td valign="top" bgcolor="#FFFFFF"><strong>End Date</strong></td>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Pay per Hour</strong></td>
                            </tr>
                          <tr>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['START_MO4']; ?>&nbsp;<?php echo $row_your_scholarships['START_YR4']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['END_MO4']; ?>&nbsp;<?php echo $row_your_scholarships['END_YR4']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['PAY_HR4']; ?></td>
                            </tr>
                          <?php } /*END_PHP_SIRFCIT*/ ?>
                        <?php /*START_PHP_SIRFCIT*/ if ($row_your_employ['EMPLOYER5']<>""){ ?>
                          <tr>
                            <td colspan="3" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
                              <tr>
                                <td height="1" valign="top" bgcolor="#706d66"><img src="../../images/spacer.png" alt="" width="1" height="1" /></td>
                                </tr>
                              </table></td>
                            </tr>
                          <tr>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Name</strong></td>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Position</strong></td>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Hours per Week</strong></td>
                            </tr>
                          <tr>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['EMPLOYER5']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['JOBPOS5']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['HRS_WK5']; ?></td>
                            </tr>
                          <tr>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Start Date</strong></td>
                            <td valign="top" bgcolor="#FFFFFF"><strong>End Date</strong></td>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Pay per Hour</strong></td>
                            </tr>
                          <tr>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['START_MO5']; ?>&nbsp;<?php echo $row_your_scholarships['START_YR5']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['END_MO5']; ?>&nbsp;<?php echo $row_your_scholarships['END_YR5']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['PAY_HR5']; ?></td>
                            </tr>
                          <?php } /*END_PHP_SIRFCIT*/ ?>
                        <?php /*START_PHP_SIRFCIT*/ if ($row_your_employ['EMPLOYER6']<>""){ ?>
                          <tr>
                            <td colspan="3" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
                              <tr>
                                <td height="1" valign="top" bgcolor="#706d66"><img src="../../images/spacer.png" alt="" width="1" height="1" /></td>
                                </tr>
                              </table></td>
                            </tr>
                          <tr>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Name</strong></td>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Position</strong></td>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Hours per Week</strong></td>
                            </tr>
                          <tr>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['EMPLOYER6']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['JOBPOS6']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['HRS_WK6']; ?></td>
                            </tr>
                          <tr>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Start Date</strong></td>
                            <td valign="top" bgcolor="#FFFFFF"><strong>End Date</strong></td>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Pay per Hour</strong></td>
                            </tr>
                          <tr>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['START_MO6']; ?>&nbsp;<?php echo $row_your_scholarships['START_YR6']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['END_MO6']; ?>&nbsp;<?php echo $row_your_scholarships['END_YR6']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['PAY_HR6']; ?></td>
                            </tr>
                          <?php } /*END_PHP_SIRFCIT*/ ?>
                        <?php /*START_PHP_SIRFCIT*/ if ($row_your_employ['EMPLOYER7']<>""){ ?>
                          <tr>
                            <td colspan="3" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
                              <tr>
                                <td height="1" valign="top" bgcolor="#706d66"><img src="../../images/spacer.png" alt="" width="1" height="1" /></td>
                                </tr>
                              </table></td>
                            </tr>
                          <tr>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Name</strong></td>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Position</strong></td>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Hours per Week</strong></td>
                            </tr>
                          <tr>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['EMPLOYER7']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['JOBPOS7']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['HRS_WK7']; ?></td>
                            </tr>
                          <tr>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Start Date</strong></td>
                            <td valign="top" bgcolor="#FFFFFF"><strong>End Date</strong></td>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Pay per Hour</strong></td>
                            </tr>
                          <tr>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['START_MO7']; ?>&nbsp;<?php echo $row_your_scholarships['START_YR7']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['END_MO7']; ?>&nbsp;<?php echo $row_your_scholarships['END_YR7']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['PAY_HR7']; ?></td>
                            </tr>
                          <?php } /*END_PHP_SIRFCIT*/ ?>
                        <?php /*START_PHP_SIRFCIT*/ if ($row_your_employ['EMPLOYER8']<>""){ ?>
                          <tr>
                            <td colspan="3" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
                              <tr>
                                <td height="1" valign="top" bgcolor="#706d66"><img src="../../images/spacer.png" alt="" width="1" height="1" /></td>
                                </tr>
                              </table></td>
                            </tr>
                          <tr>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Name</strong></td>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Position</strong></td>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Hours per Week</strong></td>
                            </tr>
                          <tr>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['EMPLOYER8']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['JOBPOS8']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['HRS_WK8']; ?></td>
                            </tr>
                          <tr>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Start Date</strong></td>
                            <td valign="top" bgcolor="#FFFFFF"><strong>End Date</strong></td>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Pay per Hour</strong></td>
                            </tr>
                          <tr>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['START_MO8']; ?>&nbsp;<?php echo $row_your_scholarships['START_YR8']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['END_MO8']; ?>&nbsp;<?php echo $row_your_scholarships['END_YR8']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['PAY_HR8']; ?></td>
                            </tr>
                          <?php } /*END_PHP_SIRFCIT*/ ?>
                        </table>
                        <?php } while ($row_your_employ = mysql_fetch_assoc($your_employ)); ?>
                      </fieldset></td>
                    </tr>
                  <tr>
                    <td colspan="2" valign="top">&nbsp;</td>
                    </tr>
                  <tr>
                    <td colspan="2" valign="top"><fieldset id="el11">
                      <legend><strong>Section 5: Aspirations and Goals</strong></legend><table width="100%" border="0" cellspacing="1" cellpadding="6">
                        <tr bgcolor="#cccccc">
                          <td width="328" valign="top" align="right"><strong>In what do you intend to major?</strong></td>
                          <td width="538" valign="top" bgcolor="cccccc"><label for="textfield"></label>
                            <?php echo $row_your_scholarships['MAJOR']; ?></td>
                          </tr>
                        <tr>
                          <td align="right" valign="top" bgcolor="#FFFFFF"><strong>In what career are you most interested?</strong></td>
                          <td valign="top" bgcolor="#FFFFFF"><label for="textarea3"></label>
                            <?php echo $row_your_scholarships['CAREER']; ?></td>
                          </tr>
                        <tr bgcolor="#cccccc">
                          <td valign="top" align="right"><strong>Describe briefly any special <br />
                            
                            talents you may have?</strong></td>
                          <td valign="top" bgcolor="cccccc"><label for="textarea2"></label>
                            <?php echo $row_your_scholarships['TALENT']; ?></td>
                          </tr>
                        </table></fieldset></td>
                    </tr>
                  <tr>
                    <td colspan="2" valign="top">&nbsp;</td>
                    </tr>
                  <tr>
                    <td colspan="2" valign="top"><fieldset id="el11">
                      <legend><strong>Section 6: Personal Statement</strong></legend><table width="100%" border="0" cellspacing="1" cellpadding="6">
                        <tr>
                          <td width="99%" valign="top"><p><?php echo $row_your_scholarships['PERS_ST']; ?></p></td>
                          </tr>
                        </table></fieldset></td>
                    </tr>
                  <tr>
                    <td colspan="2" valign="top">&nbsp;</td>
                    </tr>
                  <tr>
                    <td colspan="2" valign="top"><fieldset id="el11">
                      <legend><strong>Section 7A: Financial Information | Anticipated College Expenses</strong></legend><table width="100%" border="0" cellspacing="1" cellpadding="6">
                        <tr bgcolor="#cccccc">
                          <td width="866" valign="top"><strong>Expenses</strong></td>
                          <td align="center" width="866" valign="top"><strong>1</strong></td>
                          <td width="866" align="center" valign="top"><strong>2</strong></td>
                          <td width="866" align="center" valign="top"><strong>3</strong></td>
                          </tr>
                        <tr>
                          <td valign="top" bgcolor="#FFFFFF">Name of College</td>
                          <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['COLLNAME']; ?></td>
                          <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['COLLNAME2']; ?></td>
                          <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['COLLNAME3']; ?></td>
                          </tr>
                        <tr bgcolor="#cccccc">
                          <td valign="top">Tuition, fees, book expenses</td>
                          <td valign="top">$<?php echo $row_your_scholarships['TUITION']; ?></td>
                          <td valign="top">$<?php echo $row_your_scholarships['TUITION2']; ?></td>
                          <td valign="top">$<?php echo $row_your_scholarships['TUITION3']; ?></td>
                          </tr>
                        <tr>
                          <td valign="top" bgcolor="#FFFFFF">Transportation expenses</td>
                          <td valign="top" bgcolor="#FFFFFF">$<?php echo $row_your_scholarships['TRANSPORT']; ?></td>
                          <td valign="top" bgcolor="#FFFFFF">$<?php echo $row_your_scholarships['TRANSPORT2']; ?></td>
                          <td valign="top" bgcolor="#FFFFFF">$<?php echo $row_your_scholarships['TRANSPORT3']; ?></td>
                          </tr>
                        <tr bgcolor="#cccccc">
                          <td valign="top">Personal Expenses</td>
                          <td valign="top">$<?php echo $row_your_scholarships['PERSONAL']; ?></td>
                          <td valign="top">$<?php echo $row_your_scholarships['PERSONAL2']; ?></td>
                          <td valign="top">$<?php echo $row_your_scholarships['PERSONAL3']; ?></td>
                          </tr>
                        <tr>
                          <td valign="top" bgcolor="#FFFFFF">Room and Board</td>
                          <td valign="top" bgcolor="#FFFFFF">$<?php echo $row_your_scholarships['ROOMBD']; ?></td>
                          <td valign="top" bgcolor="#FFFFFF">$<?php echo $row_your_scholarships['ROOMBD2']; ?></td>
                          <td valign="top" bgcolor="#FFFFFF">$<?php echo $row_your_scholarships['ROOMBD3']; ?></td>
                        </tr>
                        <tr bgcolor="#cccccc">
                          <td valign="top" bgcolor="#CCCCCC"><strong>TOTAL</strong></td>
                          <td valign="top" bgcolor="#CCCCCC"><strong>$<?php echo $row_collegetotal1['SUM(TUITION+TRANSPORT+PERSONAL+ROOMBD)']; ?></strong></td>
                          <td valign="top" bgcolor="#CCCCCC"><strong>$<?php echo $row_collegetotal2['SUM(TUITION2+TRANSPORT2+PERSONAL2+ROOMBD2)']; ?></strong></td>
                          <td valign="top" bgcolor="#CCCCCC"><strong>$<?php echo $row_collegetotal3['SUM(TUITION3+TRANSPORT3+PERSONAL3+ROOMBD3)']; ?></strong></td>
                        </tr>
                        </table>
                    </fieldset></td>
                    </tr>
                  <tr>
                    <td colspan="2" valign="top"><table width="100%" border="0" cellspacing="2" cellpadding="2">
                      <tr>
                        <td width="149%" valign="top"><p><fieldset id="el11">
                          <legend><strong>Section 7B: Financial Information | Financial Aid</strong></legend><table width="100%" border="0" cellspacing="1" cellpadding="6">
                            <tr bgcolor="#cccccc">
                              <td width="48%" valign="top" bgcolor="#cccccc"><strong>Description/Source</strong></td>
                              <td width="52%" valign="top"><strong>Amount</strong></td>
                              </tr>
                            <tr>
                              <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['DESCRIPTION']; ?></td>
                              <td valign="top" bgcolor="#FFFFFF">$ <?php echo $row_your_scholarships['AMOUNT']; ?></td>
                              </tr>
                            <tr bgcolor="#cccccc">
                              <?php /*START_PHP_SIRFCIT*/ if ($row_your_sources['AMOUNT2']>"0"){ ?>
                                <td valign="top"><?php echo $row_your_scholarships['DESCRIPTION2']; ?></td>
                                <td valign="top">$ <?php echo $row_your_scholarships['AMOUNT2']; ?></td>
                                <?php } /*END_PHP_SIRFCIT*/ ?>
                              </tr>
                            <tr>
                              <?php /*START_PHP_SIRFCIT*/ if ($row_your_sources['AMOUNT3']>"0"){ ?>
                                <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['DESCRIPTION3']; ?></td>
                                <td valign="top" bgcolor="#FFFFFF">$ <?php echo $row_your_scholarships['AMOUNT3']; ?></td>
                                <?php } /*END_PHP_SIRFCIT*/ ?>
                              </tr>
                            <tr bgcolor="#cccccc">
                              <?php /*START_PHP_SIRFCIT*/ if ($row_your_sources['AMOUNT4']>"0"){ ?>
                                <td valign="top"><?php echo $row_your_scholarships['DESCRIPTION4']; ?></td>
                                <td valign="top">$ <?php echo $row_your_scholarships['AMOUNT4']; ?></td>
                                <?php } /*END_PHP_SIRFCIT*/ ?>
                              </tr>
                            <tr>
                              <?php /*START_PHP_SIRFCIT*/ if ($row_your_sources['AMOUNT5']>"0"){ ?>
                                <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['DESCRIPTION5']; ?></td>
                                <td valign="top" bgcolor="#FFFFFF">$ <?php echo $row_your_scholarships['AMOUNT5']; ?></td>
                                <?php } /*END_PHP_SIRFCIT*/ ?>
                              </tr>
                            </table></fieldset></p></td>
                        </tr>
                      </table>
                      <table width="100%" border="0" cellspacing="2" cellpadding="2">
                        <tr>
                          <td width="99%" valign="top"><fieldset id="el11">
                            <legend><strong>Section 7C: Financial Information | Special Circumstances</strong></legend><table width="100%" border="0" cellspacing="1" cellpadding="6">
                              <tr>
                                <td width="149%" valign="top"><p>
                                  <label for="textarea"></label>
                                  <?php echo $row_your_scholarships['SPEC_CIRC']; ?></p></td>
                                </tr>
                              </table></fieldset></td>
                          </tr>
                        <tr>
                          <td align="right" valign="top">&nbsp;</td>
                          </tr>
                        </table>
                      <?php if ($totalRows_special_attach > 0) { // Show if recordset not empty ?>
  <table width="100%" border="0" cellspacing="2" cellpadding="2">
    <tr>
      <td width="866" valign="top"><fieldset id="el11">
        <legend><strong>Income Verification</strong></legend>
        <table width="100%" border="0" cellspacing="1" cellpadding="6">
          <tr>
            <td width="51%" valign="top" align="right"><strong>Person financially responsible for applicant:</strong></td>
            <td width="49%" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
              <tr>
                <td valign="top">Self
                  <input <?php if (!(strcmp($row_your_finances['FIN_RESP'],"1"))) {echo "checked=\"checked\"";} ?> type="radio" name="FIN_RESP" value="1" id="FIN_RESP_0" /></td>
                <td valign="top">Parent/Guardian
                  <input <?php if (!(strcmp($row_your_finances['FIN_RESP'],"2"))) {echo "checked=\"checked\"";} ?> type="radio" name="FIN_RESP" value="2" id="FIN_RESP_1" /></td>
                <td valign="top">Other
                  <input <?php if (!(strcmp($row_your_finances['FIN_RESP'],"3"))) {echo "checked=\"checked\"";} ?> type="radio" name="FIN_RESP" value="3" id="FIN_RESP_2" /></td>
                <td><?php echo $row_your_scholarships['FIN_RESP_OTHER']; ?></td>
                </tr>
              </table></td>
            </tr>
          <tr>
            <td valign="top" align="right"><strong>2010 Federal Income Tax Return Field?</strong></td>
            <td valign="top"><?php echo $row_your_scholarships['FED_RTN']; ?></td>
            </tr>
          <tr>
            <td valign="top" align="right"><strong>Adjusted Gross Income:</strong></td>
            <td valign="top">$<?php echo $row_your_scholarships['INCOME']; ?></td>
            </tr>
          <tr>
            <td align="right" valign="top"><strong>Family Financial Support Explanation:</strong></td>
            <td valign="top"><?php echo $row_your_scholarships['ZERO_INC']; ?></td>
            </tr>
          <tr>
            <td valign="top" align="right"><strong>Present market value of home (if owned):</strong></td>
            <td valign="top">$<?php echo $row_your_scholarships['MKTVAL_HOME']; ?></td>
            </tr>
          <tr>
            <td valign="top" align="right"><strong>Annual Mortgage Payment (if owned):</strong></td>
            <td valign="top">$<?php echo $row_your_scholarships['MORTGAGE']; ?></td>
            </tr>
          <tr>
            <td valign="top" align="right"><strong>Annual rental payment (non-homeowner):</strong></td>
            <td valign="top">$<?php echo $row_your_scholarships['RENT']; ?></td>
            </tr>
          <tr>
            <td valign="top" align="right"><strong>Medical and Dental expenses:</strong></td>
            <td valign="top">$<?php echo $row_your_scholarships['MED_DENT']; ?></td>
            </tr>
          <tr>
            <td valign="top" align="right"><strong>Total number of children living<br />
              in the home or receiving support:</strong></td>
            <td valign="top"><?php echo $row_your_scholarships['TOT_CHILD']; ?></td>
            </tr>
          <tr>
            <td valign="top" align="right"><strong>Total children currently attending college:</strong></td>
            <td valign="top"><?php echo $row_your_scholarships['SIB_COLLEGE']; ?></td>
            </tr>
          </table>
        </fieldset></td>
    </tr>
    <tr>
      <td valign="top"><fieldset id="el11">
        <legend><strong>Special Attachment Essay</strong></legend>
        <table width="100%" border="0" cellspacing="1" cellpadding="6">
          <tr>
            <td width="149%" valign="top"><p> <strong><?php echo $row_your_scholarships['ESSAY']; ?></strong></p>
              <p><?php echo $row_your_scholarships['STU_ESSAY']; ?></p></td>
          </tr>
        </table></fieldset></td>
    </tr>
    <?php if ($totalRows_winners > 0) { // Show if recordset not empty ?>
      <?php } // Show if recordset not empty ?>
  </table>
  <?php } // Show if recordset not empty ?></td>
                    </tr>
                  <tr>
                    <td colspan="2" valign="top"></td>
                    </tr><tr>
          <td valign="top"><?php echo $row_your_scholarships['FNAME']; ?>&nbsp;<?php echo $row_your_scholarships['LNAME']; ?> | <?php echo $row_your_scholarships['NAME']; ?></td>
        </tr>
                  </table></td>
                </tr>
              </table></td>
          
          </tr>
        </tbody>
      </table>
  </td>
  </tr>
  </tbody>
  </table>
  </td>
</tr>
</tbody>
</table><?php } while ($row_your_scholarships = mysql_fetch_assoc($your_scholarships)); ?>
<div class="ContentFooter"> </div>
	</div>
</body>
</html>
<?php
mysql_free_result($your_sources);
mysql_free_result($scholarships);

mysql_free_result($winners);

mysql_free_result($guidance);

mysql_free_result($collegetotal1);

mysql_free_result($collegetotal2);

mysql_free_result($collegetotal3);

mysql_free_result($special_attach);

mysql_free_result($your_colleges1);

mysql_free_result($your_application);

mysql_free_result($your_finances);

mysql_free_result($your_employ);

mysql_free_result($your_activities);

mysql_free_result($your_scholarships);
?>



thanks
Was This Post Helpful? 0
  • +
  • -

#5 Dormilich  Icon User is offline

  • 痛覚残留
  • member icon

Reputation: 3541
  • View blog
  • Posts: 10,236
  • Joined: 08-June 10

Re: Print records that are checked off

Posted 12 December 2012 - 06:00 AM

oh, my Ö what a mess (well, thatís DW for you).

OK, problem point: <input name="UID" type="checkbox" id="record" value="Ö">. no matter how many such text fields there are, only the last one makes it to PHP. for getting every fields through, you need them define as array via <input name="UID[]" type="checkbox" id="record" value="Ö"> (note the square brackets in the name).

PS. the mysql_* functions are outdated, use MySQLi or PDO instead (and with Prepared Statements you donít even have to worry about SQL Injection)
Was This Post Helpful? 0
  • +
  • -

#6 Atli  Icon User is offline

  • D.I.C Lover
  • member icon

Reputation: 3719
  • View blog
  • Posts: 5,990
  • Joined: 08-June 10

Re: Print records that are checked off

Posted 12 December 2012 - 06:14 AM

Is that really how Dreamweaver generates PHP code? I remember it being bad, but damn!
Was This Post Helpful? 0
  • +
  • -

#7 lwaters  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 7
  • Joined: 11-December 12

Re: Print records that are checked off

Posted 12 December 2012 - 06:29 AM

Ok, I have made that change to the form adding the brackets. Now since it is an array, there needs to be some adjustments on the other page. Since I am a newbie, I have no idea what they need to be. Here is what I have right now and the error message I get is: Warning: mysql_real_escape_string() expects parameter 1 to be string, array given in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\Scholarship\admin\printable_version2_test.php on line 58


<?php
date_default_timezone_set('America/New_York');
?>
<?php require_once('../../Connections/connect.php'); ?>
<?php
if (!isset($_SESSION)) {
  session_start();
}
$MM_authorizedUsers = "0,2,3,4,5,6,7";
$MM_donotCheckaccess = "false";

// *** Restrict Access To Page: Grant or deny access to this page
function isAuthorized($strUsers, $strGroups, $UserName, $UserGroup) { 
  // For security, start by assuming the visitor is NOT authorized. 
  $isValid = False; 

  // When a visitor has logged into this site, the Session variable MM_Username set equal to their username. 
  // Therefore, we know that a user is NOT logged in if that Session variable is blank. 
  if (!empty($UserName)) { 
    // Besides being logged in, you may restrict access to only certain users based on an ID established when they login. 
    // Parse the strings into arrays. 
    $arrUsers = Explode(",", $strUsers); 
    $arrGroups = Explode(",", $strGroups); 
    if (in_array($UserName, $arrUsers)) { 
      $isValid = true; 
    } 
    // Or, you may restrict access to only certain users based on their username. 
    if (in_array($UserGroup, $arrGroups)) { 
      $isValid = true; 
    } 
    if (($strUsers == "") && false) { 
      $isValid = true; 
    } 
  } 
  return $isValid; 
}

$MM_restrictGoTo = "error2.php";
if (!((isset($_SESSION['MM_Username'])) && (isAuthorized("",$MM_authorizedUsers, $_SESSION['MM_Username'], $_SESSION['MM_UserGroup'])))) {   
  $MM_qsChar = "?";
  $MM_referrer = $_SERVER['PHP_SELF'];
  if (strpos($MM_restrictGoTo, "?")) $MM_qsChar = "&";
  if (isset($_SERVER['QUERY_STRING']) && strlen($_SERVER['QUERY_STRING']) > 0) 
  $MM_referrer .= "?" . $_SERVER['QUERY_STRING'];
  $MM_restrictGoTo = $MM_restrictGoTo. $MM_qsChar . "accesscheck=" . urlencode($MM_referrer);
  header("Location: ". $MM_restrictGoTo); 
  exit;
}
?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

$colname_your_scholarships = "-1";
if (isset($_GET['UID'])) {
  $colname_your_scholarships = $_GET['UID'];
}
mysql_select_db($database_connect, $connect);
$query_your_scholarships = sprintf("SELECT * FROM users, activities, coll_exp, employ, fin_app, finaid, stu_app2008, stu_special WHERE users.`UID` = %s and stu_app2008.UID = %s and activities.UID = %s and employ.UID = %s and fin_app.UID = %s and finaid.UID = %s and coll_exp.UID = %s AND stu_special.`UID` = %s ORDER BY users.REG", GetSQLValueString($colname_your_scholarships, "int"),GetSQLValueString($colname_your_scholarships, "int"),GetSQLValueString($colname_your_scholarships, "int"),GetSQLValueString($colname_your_scholarships, "int"),GetSQLValueString($colname_your_scholarships, "int"),GetSQLValueString($colname_your_scholarships, "int"),GetSQLValueString($colname_your_scholarships, "int"),GetSQLValueString($colname_your_scholarships, "int"));
$your_scholarships = mysql_query($query_your_scholarships, $connect) or die(mysql_error());
$row_your_scholarships = mysql_fetch_assoc($your_scholarships);
$totalRows_your_scholarships = mysql_num_rows($your_scholarships);
?>
<?php  $lastTFM_nest = "";?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
	<meta name="description" content="Cambridge Public Schools: Public schools built on a foundation of academic excellence and committed to promoting an environment of social justice.">
	<meta name="keywords" content="cambridge, massachusetts, ma, mass, public, school, district, k-12, public schools, cambridge public schools, school registration, cambridge schools, ma public schools, rindge and latin school, amigos school, morse school, tobin school, peabody school, fletcher-maynard academy, kennedy-longfellow, rindge school of technical arts, baldwin school, cambridgeport, graham & parks, haggerty school, martin luther king jr. school, cambridge rindge and latin, crls, falcon sports, superintendent young, cps">
	<meta name="robots" content="noarchive">
<link rel="shortcut icon" href="http://www3.cpsd.us/media/ImageElements/theme/CPS%20Redesign/favicon.ico?rev=1">
<link rel="stylesheet" type="text/css" href="https://secure2.cpsd.us/scholarship/form_styles.css" />
<style type="text/css">td img {display: block;}</style>
<style type="text/css">td img {margin: 0;}</style>
<link href="../text.css" rel="stylesheet" type="text/css" />
<title>Cambridge Rindge &amp; Latin School | 2012 Scholarship Standard Application</title>
<script TYPE="text/javascript">
<!--
function popup(mylink, windowname)
{
if (! window.focus)return true;
var href;
if (typeof(mylink) == 'string')
   href=mylink;
else
   href=mylink.href;
window.open(href, windowname, 'width=600,height=500,scrollbars=yes');
return false;
}
//-->
</SCRIPT>

</head>

<body>
<?php $TFM_nest = $row_your_scholarships['REG'];
if ($lastTFM_nest != $TFM_nest) { 
	$lastTFM_nest = $TFM_nest; ?>
<table border="0" cellspacing="0" cellpadding="0" width="960px" align="center">
  <tbody>
<tr>
  <td colspan="3" valign="top">
  
  <table style="width: 100%;" border="0" cellspacing="0" cellpadding="5">
  <tbody>
  <tr>
  <td width="100%" valign="top">
    <table width="95%" border="0" align="center" cellpadding="0" cellspacing="0">
      <tbody>
        <tr>
          <td valign="top"><?php echo $row_your_scholarships['FNAME']; ?>&nbsp;<?php echo $row_your_scholarships['LNAME']; ?> | <?php echo $row_your_scholarships['NAME']; ?></td>
        </tr>
        <tr>
          <td width="100%" valign="top"><br>
            <h6>2012 Scholarship Standard Application</h6>
            <table width="100%" border="0" cellspacing="0" cellpadding="0">
              
              <tr>
                <td colspan="7" valign="top"><table width="98%" border="0" align="center" cellpadding="5" cellspacing="2">
                  <tr>
                    <td width="200%" colspan="2" valign="top"><fieldset id="el11"><legend><strong>Section 1: Applicant Information</strong></legend>
                      <table width="100%" border="0" cellspacing="1" cellpadding="6">
                        <tr bgcolor="#cccccc">
                          <td width="33%" valign="top"><strong>Name: </strong><?php echo $row_your_scholarships['FNAME']; ?>&nbsp;<?php echo $row_your_scholarships['LNAME']; ?></strong></font></strong></td>
                          <td valign="top"><strong>Gender: </strong><?php echo $row_your_scholarships['GENDER']; ?></strong></font></strong></td>
                          <td valign="top"><strong>SID: </strong><?php echo $row_your_scholarships['SID']; ?></strong></font></strong></td>
                          </tr>
                        <tr>
                          <td colspan="2" valign="top" bgcolor="#FFFFFF"><strong>Address: </strong><?php echo $row_your_scholarships['ADDRESS']; ?></strong></font></strong></td>
                          <td valign="top" bgcolor="#FFFFFF"><strong>Homeroom: </strong><?php echo $row_your_scholarships['HR']; ?></strong></font></strong></td>
                          </tr>
                        <tr bgcolor="#cccccc">
                          <td valign="top"><strong>Telephone: </strong><?php echo $row_your_scholarships['TEL']; ?></strong></font></strong></td>
                          <td valign="top"><strong>LC: </strong><?php echo $row_your_scholarships['LC']; ?></strong></font></strong></td>
                          <td valign="top"><strong>GC: </strong><?php echo $row_guidance['NAME']; ?></strong></font></strong></td>
                          </tr>
                        <tr>
                          <td valign="top" bgcolor="#FFFFFF"><strong>Email: </strong><?php echo $row_your_scholarships['UNAME']; ?></strong></font></strong></td>
                          <td colspan="2" valign="top" bgcolor="#FFFFFF"><strong>Elementary School:</strong> <?php echo $row_your_scholarships['ELEM']; ?></td>
                          </tr>
                        </table></fieldset></td>
                    </tr>
                  <tr>
                    <td colspan="2" valign="top"><fieldset id="el11">
                      <legend><strong>Section 2: Parent / Guardian Information</strong></legend><table width="100%" border="0" cellspacing="1" cellpadding="6">
                        <tr>
                          <td colspan="2" valign="top"><strong>PARENT / GUARDIAN #1</strong></td>
                          <td colspan="2" valign="top" bgcolor="#cccccc"><strong>PARENT / GUARDIAN #2</strong></td>
                          </tr>
                        <tr>
                          <td width="19%" valign="top"><strong>Name: </strong></td>
                          <td width="30%" valign="top"><label for="Name"><?php echo $row_your_scholarships['PARENT_A']; ?></label></td>
                          <td width="19%" valign="top" bgcolor="#cccccc"><strong>Name: </strong></td>
                          <td width="30%" valign="top" bgcolor="#cccccc"><?php echo $row_your_scholarships['PARENT_B']; ?></td>
                          </tr>
                        <tr>
                          <td valign="top"><strong>Address:</strong></td>
                          <td valign="top"><?php echo $row_your_scholarships['PAR_A_ADD']; ?></td>
                          <td valign="top" bgcolor="#cccccc"><strong>Address:</strong></td>
                          <td valign="top" bgcolor="#cccccc"><?php echo $row_your_scholarships['PAR_B_ADD']; ?></td>
                          </tr>
                        <tr>
                          <td valign="top"><strong>Telephone:</strong></td>
                          <td valign="top"><?php echo $row_your_scholarships['PAR_A_TEL']; ?></td>
                          <td valign="top" bgcolor="#cccccc"><strong>Telephone:</strong></td>
                          <td valign="top" bgcolor="#cccccc"><?php echo $row_your_scholarships['PAR_B_TEL']; ?></td>
                          </tr>
                        <tr>
                          <td valign="top"><strong>Relationship to Applicant:</strong></td>
                          <td valign="top"><?php echo $row_your_scholarships['PAR_A_REL']; ?></td>
                          <td valign="top" bgcolor="#cccccc"><strong>Relationship to Applicant:</strong></td>
                          <td valign="top" bgcolor="#cccccc"><?php echo $row_your_scholarships['PAR_B_REL']; ?></td>
                          </tr>
                        <tr>
                          <td valign="top"><strong>Occupation:</strong></td>
                          <td valign="top"><?php echo $row_your_scholarships['PAR_A_OCC']; ?></td>
                          <td valign="top" bgcolor="#cccccc"><strong>Occupation:</strong></td>
                          <td valign="top" bgcolor="#cccccc"><?php echo $row_your_scholarships['PAR_B_OCC']; ?></td>
                          </tr>
                        </table>
                      </fieldset></td>
                    </tr>
                  <tr>
                    <td colspan="2" valign="top"><fieldset id="el11">
                      <legend><strong>Section 3: School and Community Involvement</strong></legend><table width="100%" border="0" cellspacing="1" cellpadding="6"><tr>
                        <td width="45%" valign="top"><strong>Community Service Hours Completed to Date: </strong></td>
                        <td width="55%" valign="top"><?php echo $row_your_scholarships['COMMUNITY_SERVICE_HOURS']; ?></td>
                        </tr>
                        <tr>
                        <td colspan="2" valign="top">Below list the activities in which the student participated both in and out of school.</td>
                        </tr>
                        </table>
                      <table width="100%" border="0" cellspacing="1" cellpadding="6">
                        <tr bgcolor="#cccccc">
                          <td width="157" valign="top"><strong>Organization or Activity</strong></td>
                          <td width="127" valign="top"><strong>Grade 9</strong></td>
                          <td width="127" valign="top"><strong>Grade 10</strong></td>
                          <td width="127" valign="top" bgcolor="#cccccc"><strong>Grade 11</strong></td>
                          <td width="127" valign="top"><strong>Grade 12</strong></td>
                          <td width="154" valign="top"><strong>Position, Commendations, Honors, Awards</strong></td>
                          </tr>
                        <tr>
                          <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['ACTNAME']; ?></td>
                          <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['GR09']; ?></td>
                          <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['GR10']; ?></td>
                          <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['GR11']; ?></td>
                          <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['GR12']; ?></td>
                          <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['POSITION']; ?></td>
                          </tr>
                        <tr>
                          <?php /*START_PHP_SIRFCIT*/ if ($row_your_activities['ACTNAME2']<>""){ ?>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['ACTNAME2']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['GR09_2']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['GR10_2']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['GR11_2']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['GR12_2']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['POSITION2']; ?></td>
                            <?php } /*END_PHP_SIRFCIT*/ ?>
                          </tr>
                        <tr>
                          <?php /*START_PHP_SIRFCIT*/ if ($row_your_activities['ACTNAME3']<>""){ ?>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['ACTNAME3']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['GR09_3']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['GR10_3']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['GR11_3']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['GR12_3']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['POSITION3']; ?></td>
                            <?php } /*END_PHP_SIRFCIT*/ ?>
                          </tr>
                        <tr>
                          <?php /*START_PHP_SIRFCIT*/ if ($row_your_activities['ACTNAME4']<>""){ ?>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['ACTNAME4']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['GR09_4']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['GR10_4']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['GR11_4']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['GR12_4']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['POSITION4']; ?></td>
                            <?php } /*END_PHP_SIRFCIT*/ ?>
                          </tr>
                        <tr>
                          <?php /*START_PHP_SIRFCIT*/ if ($row_your_activities['ACTNAME5']<>""){ ?>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['ACTNAME5']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['GR09_5']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['GR10_5']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['GR11_5']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['GR12_5']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['POSITION5']; ?></td>
                            <?php } /*END_PHP_SIRFCIT*/ ?>
                          </tr>
                        <tr>
                          <?php /*START_PHP_SIRFCIT*/ if ($row_your_activities['ACTNAME6']<>""){ ?>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['ACTNAME6']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['GR09_6']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['GR10_6']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['GR11_6']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['GR12_6']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['POSITION6']; ?></td>
                            <?php } /*END_PHP_SIRFCIT*/ ?>
                        </tr>
                        <tr>
                          <?php /*START_PHP_SIRFCIT*/ if ($row_your_activities['ACTNAME7']<>""){ ?>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['ACTNAME7']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['GR09_7']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['GR10_7']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['GR11_7']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['GR12_7']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['POSITION7']; ?></td>
                            <?php } /*END_PHP_SIRFCIT*/ ?>
                        </tr>
                        <tr>
                          <?php /*START_PHP_SIRFCIT*/ if ($row_your_activities['ACTNAME8']<>""){ ?>
                          <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['ACTNAME8']; ?></td>
                          <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['GR09_8']; ?></td>
                          <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['GR10_8']; ?></td>
                          <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['GR11_8']; ?></td>
                          <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['GR12_8']; ?></td>
                          <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['POSITION8']; ?></td>
                          <?php } /*END_PHP_SIRFCIT*/ ?>
                        </tr>
                        </table>
                      </fieldset></td>
                    </tr>
                  <tr>
                    <td colspan="2" valign="top">&nbsp;</td>
                    </tr>
                  <tr>
                    <td colspan="2" valign="top"><fieldset id="el11">
                      <legend><strong>Section 4: Work Experience</strong></legend><?php do { ?><table width="100%" border="0" cellspacing="1" cellpadding="6">
                        <tr>
                          <td colspan="3" valign="top" bgcolor="#cccccc"><strong>EMPLOYER</strong></td>
                          </tr>
                        <tr>
                          <td width="33%" valign="top" bgcolor="#FFFFFF"><strong>Name</strong></td>
                          <td width="33%" valign="top" bgcolor="#FFFFFF"><strong>Position</strong></td>
                          <td width="33%" valign="top" bgcolor="#FFFFFF"><strong>Hours per Week</strong></td>
                          </tr>
                        <tr>
                          <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['EMPLOYER']; ?></td>
                          <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['JOBPOS']; ?></td>
                          <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['HRS_WK']; ?></td>
                          </tr>
                        <tr>
                          <td valign="top" bgcolor="#FFFFFF"><strong>Start Date</strong></td>
                          <td valign="top" bgcolor="#FFFFFF"><strong>End Date</strong></td>
                          <td valign="top" bgcolor="#FFFFFF"><strong>Pay per Hour</strong></td>
                          </tr>
                        <tr>
                          <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['START_MO']; ?>&nbsp;<?php echo $row_your_scholarships['START_YR']; ?></td>
                          <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['END_MO']; ?>&nbsp;<?php echo $row_your_scholarships['END_YR']; ?></td>
                          <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['PAY_HR']; ?></td>
                          </tr>
                        <?php /*START_PHP_SIRFCIT*/ if ($row_your_employ['EMPLOYER2']<>""){ ?>
                          <tr>
                            <td colspan="3" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
                              <tr>
                                <td height="1" valign="top" bgcolor="#706d66"><img src="../../images/spacer.png" alt="" width="1" height="1" /></td>
                                </tr>
                              </table></td>
                            </tr>
                          <tr>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Name</strong></td>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Position</strong></td>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Hours per Week</strong></td>
                            </tr>
                          <tr>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['EMPLOYER2']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['JOBPOS2']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['HRS_WK2']; ?></td>
                            </tr>
                          <tr>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Start Date</strong></td>
                            <td valign="top" bgcolor="#FFFFFF"><strong>End Date</strong></td>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Pay per Hour</strong></td>
                            </tr>
                          <tr>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['START_MO2']; ?>&nbsp;<?php echo $row_your_scholarships['START_YR2']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['END_MO2']; ?>&nbsp;<?php echo $row_your_scholarships['END_YR2']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['PAY_HR2']; ?></td>
                            </tr>
                          <?php } /*END_PHP_SIRFCIT*/ ?>
                        <?php /*START_PHP_SIRFCIT*/ if ($row_your_employ['EMPLOYER3']<>""){ ?>
                          <tr>
                            <td colspan="3" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
                              <tr>
                                <td height="1" valign="top" bgcolor="#706d66"><img src="../../images/spacer.png" alt="" width="1" height="1" /></td>
                                </tr>
                              </table></td>
                            </tr>
                          <tr>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Name</strong></td>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Position</strong></td>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Hours per Week</strong></td>
                            </tr>
                          <tr>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['EMPLOYER3']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['JOBPOS3']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['HRS_WK3']; ?></td>
                            </tr>
                          <tr>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Start Date</strong></td>
                            <td valign="top" bgcolor="#FFFFFF"><strong>End Date</strong></td>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Pay per Hour</strong></td>
                            </tr>
                          <tr>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['START_MO3']; ?>&nbsp;<?php echo $row_your_scholarships['START_YR3']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['END_MO3']; ?>&nbsp;<?php echo $row_your_scholarships['END_YR3']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['PAY_HR3']; ?></td>
                            </tr>
                          <?php } /*END_PHP_SIRFCIT*/ ?>
                        <?php /*START_PHP_SIRFCIT*/ if ($row_your_employ['EMPLOYER4']<>""){ ?>
                          <tr>
                            <td colspan="3" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
                              <tr>
                                <td height="1" valign="top" bgcolor="#706d66"><img src="../../images/spacer.png" alt="" width="1" height="1" /></td>
                                </tr>
                              </table></td>
                            </tr>
                          <tr>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Name</strong></td>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Position</strong></td>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Hours per Week</strong></td>
                            </tr>
                          <tr>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['EMPLOYER4']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['JOBPOS4']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['HRS_WK4']; ?></td>
                            </tr>
                          <tr>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Start Date</strong></td>
                            <td valign="top" bgcolor="#FFFFFF"><strong>End Date</strong></td>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Pay per Hour</strong></td>
                            </tr>
                          <tr>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['START_MO4']; ?>&nbsp;<?php echo $row_your_scholarships['START_YR4']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['END_MO4']; ?>&nbsp;<?php echo $row_your_scholarships['END_YR4']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['PAY_HR4']; ?></td>
                            </tr>
                          <?php } /*END_PHP_SIRFCIT*/ ?>
                        <?php /*START_PHP_SIRFCIT*/ if ($row_your_employ['EMPLOYER5']<>""){ ?>
                          <tr>
                            <td colspan="3" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
                              <tr>
                                <td height="1" valign="top" bgcolor="#706d66"><img src="../../images/spacer.png" alt="" width="1" height="1" /></td>
                                </tr>
                              </table></td>
                            </tr>
                          <tr>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Name</strong></td>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Position</strong></td>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Hours per Week</strong></td>
                            </tr>
                          <tr>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['EMPLOYER5']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['JOBPOS5']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['HRS_WK5']; ?></td>
                            </tr>
                          <tr>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Start Date</strong></td>
                            <td valign="top" bgcolor="#FFFFFF"><strong>End Date</strong></td>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Pay per Hour</strong></td>
                            </tr>
                          <tr>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['START_MO5']; ?>&nbsp;<?php echo $row_your_scholarships['START_YR5']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['END_MO5']; ?>&nbsp;<?php echo $row_your_scholarships['END_YR5']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['PAY_HR5']; ?></td>
                            </tr>
                          <?php } /*END_PHP_SIRFCIT*/ ?>
                        <?php /*START_PHP_SIRFCIT*/ if ($row_your_employ['EMPLOYER6']<>""){ ?>
                          <tr>
                            <td colspan="3" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
                              <tr>
                                <td height="1" valign="top" bgcolor="#706d66"><img src="../../images/spacer.png" alt="" width="1" height="1" /></td>
                                </tr>
                              </table></td>
                            </tr>
                          <tr>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Name</strong></td>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Position</strong></td>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Hours per Week</strong></td>
                            </tr>
                          <tr>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['EMPLOYER6']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['JOBPOS6']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['HRS_WK6']; ?></td>
                            </tr>
                          <tr>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Start Date</strong></td>
                            <td valign="top" bgcolor="#FFFFFF"><strong>End Date</strong></td>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Pay per Hour</strong></td>
                            </tr>
                          <tr>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['START_MO6']; ?>&nbsp;<?php echo $row_your_scholarships['START_YR6']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['END_MO6']; ?>&nbsp;<?php echo $row_your_scholarships['END_YR6']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['PAY_HR6']; ?></td>
                            </tr>
                          <?php } /*END_PHP_SIRFCIT*/ ?>
                        <?php /*START_PHP_SIRFCIT*/ if ($row_your_employ['EMPLOYER7']<>""){ ?>
                          <tr>
                            <td colspan="3" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
                              <tr>
                                <td height="1" valign="top" bgcolor="#706d66"><img src="../../images/spacer.png" alt="" width="1" height="1" /></td>
                                </tr>
                              </table></td>
                            </tr>
                          <tr>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Name</strong></td>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Position</strong></td>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Hours per Week</strong></td>
                            </tr>
                          <tr>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['EMPLOYER7']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['JOBPOS7']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['HRS_WK7']; ?></td>
                            </tr>
                          <tr>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Start Date</strong></td>
                            <td valign="top" bgcolor="#FFFFFF"><strong>End Date</strong></td>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Pay per Hour</strong></td>
                            </tr>
                          <tr>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['START_MO7']; ?>&nbsp;<?php echo $row_your_scholarships['START_YR7']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['END_MO7']; ?>&nbsp;<?php echo $row_your_scholarships['END_YR7']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['PAY_HR7']; ?></td>
                            </tr>
                          <?php } /*END_PHP_SIRFCIT*/ ?>
                        <?php /*START_PHP_SIRFCIT*/ if ($row_your_employ['EMPLOYER8']<>""){ ?>
                          <tr>
                            <td colspan="3" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
                              <tr>
                                <td height="1" valign="top" bgcolor="#706d66"><img src="../../images/spacer.png" alt="" width="1" height="1" /></td>
                                </tr>
                              </table></td>
                            </tr>
                          <tr>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Name</strong></td>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Position</strong></td>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Hours per Week</strong></td>
                            </tr>
                          <tr>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['EMPLOYER8']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['JOBPOS8']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['HRS_WK8']; ?></td>
                            </tr>
                          <tr>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Start Date</strong></td>
                            <td valign="top" bgcolor="#FFFFFF"><strong>End Date</strong></td>
                            <td valign="top" bgcolor="#FFFFFF"><strong>Pay per Hour</strong></td>
                            </tr>
                          <tr>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['START_MO8']; ?>&nbsp;<?php echo $row_your_scholarships['START_YR8']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['END_MO8']; ?>&nbsp;<?php echo $row_your_scholarships['END_YR8']; ?></td>
                            <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['PAY_HR8']; ?></td>
                            </tr>
                          <?php } /*END_PHP_SIRFCIT*/ ?>
                        </table>
                        <?php } while ($row_your_employ = mysql_fetch_assoc($your_employ)); ?>
                      </fieldset></td>
                    </tr>
                  <tr>
                    <td colspan="2" valign="top">&nbsp;</td>
                    </tr>
                  <tr>
                    <td colspan="2" valign="top"><fieldset id="el11">
                      <legend><strong>Section 5: Aspirations and Goals</strong></legend><table width="100%" border="0" cellspacing="1" cellpadding="6">
                        <tr bgcolor="#cccccc">
                          <td width="328" valign="top" align="right"><strong>In what do you intend to major?</strong></td>
                          <td width="538" valign="top" bgcolor="cccccc"><label for="textfield"></label>
                            <?php echo $row_your_scholarships['MAJOR']; ?></td>
                          </tr>
                        <tr>
                          <td align="right" valign="top" bgcolor="#FFFFFF"><strong>In what career are you most interested?</strong></td>
                          <td valign="top" bgcolor="#FFFFFF"><label for="textarea3"></label>
                            <?php echo $row_your_scholarships['CAREER']; ?></td>
                          </tr>
                        <tr bgcolor="#cccccc">
                          <td valign="top" align="right"><strong>Describe briefly any special <br />
                            
                            talents you may have?</strong></td>
                          <td valign="top" bgcolor="cccccc"><label for="textarea2"></label>
                            <?php echo $row_your_scholarships['TALENT']; ?></td>
                          </tr>
                        </table></fieldset></td>
                    </tr>
                  <tr>
                    <td colspan="2" valign="top">&nbsp;</td>
                    </tr>
                  <tr>
                    <td colspan="2" valign="top"><fieldset id="el11">
                      <legend><strong>Section 6: Personal Statement</strong></legend><table width="100%" border="0" cellspacing="1" cellpadding="6">
                        <tr>
                          <td width="99%" valign="top"><p><?php echo $row_your_scholarships['PERS_ST']; ?></p></td>
                          </tr>
                        </table></fieldset></td>
                    </tr>
                  <tr>
                    <td colspan="2" valign="top">&nbsp;</td>
                    </tr>
                  <tr>
                    <td colspan="2" valign="top"><fieldset id="el11">
                      <legend><strong>Section 7A: Financial Information | Anticipated College Expenses</strong></legend><table width="100%" border="0" cellspacing="1" cellpadding="6">
                        <tr bgcolor="#cccccc">
                          <td width="866" valign="top"><strong>Expenses</strong></td>
                          <td align="center" width="866" valign="top"><strong>1</strong></td>
                          <td width="866" align="center" valign="top"><strong>2</strong></td>
                          <td width="866" align="center" valign="top"><strong>3</strong></td>
                          </tr>
                        <tr>
                          <td valign="top" bgcolor="#FFFFFF">Name of College</td>
                          <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['COLLNAME']; ?></td>
                          <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['COLLNAME2']; ?></td>
                          <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['COLLNAME3']; ?></td>
                          </tr>
                        <tr bgcolor="#cccccc">
                          <td valign="top">Tuition, fees, book expenses</td>
                          <td valign="top">$<?php echo $row_your_scholarships['TUITION']; ?></td>
                          <td valign="top">$<?php echo $row_your_scholarships['TUITION2']; ?></td>
                          <td valign="top">$<?php echo $row_your_scholarships['TUITION3']; ?></td>
                          </tr>
                        <tr>
                          <td valign="top" bgcolor="#FFFFFF">Transportation expenses</td>
                          <td valign="top" bgcolor="#FFFFFF">$<?php echo $row_your_scholarships['TRANSPORT']; ?></td>
                          <td valign="top" bgcolor="#FFFFFF">$<?php echo $row_your_scholarships['TRANSPORT2']; ?></td>
                          <td valign="top" bgcolor="#FFFFFF">$<?php echo $row_your_scholarships['TRANSPORT3']; ?></td>
                          </tr>
                        <tr bgcolor="#cccccc">
                          <td valign="top">Personal Expenses</td>
                          <td valign="top">$<?php echo $row_your_scholarships['PERSONAL']; ?></td>
                          <td valign="top">$<?php echo $row_your_scholarships['PERSONAL2']; ?></td>
                          <td valign="top">$<?php echo $row_your_scholarships['PERSONAL3']; ?></td>
                          </tr>
                        <tr>
                          <td valign="top" bgcolor="#FFFFFF">Room and Board</td>
                          <td valign="top" bgcolor="#FFFFFF">$<?php echo $row_your_scholarships['ROOMBD']; ?></td>
                          <td valign="top" bgcolor="#FFFFFF">$<?php echo $row_your_scholarships['ROOMBD2']; ?></td>
                          <td valign="top" bgcolor="#FFFFFF">$<?php echo $row_your_scholarships['ROOMBD3']; ?></td>
                        </tr>
                        <tr bgcolor="#cccccc">
                          <td valign="top" bgcolor="#CCCCCC"><strong>TOTAL</strong></td>
                          <td valign="top" bgcolor="#CCCCCC"><strong>$<?php echo $row_collegetotal1['SUM(TUITION+TRANSPORT+PERSONAL+ROOMBD)']; ?></strong></td>
                          <td valign="top" bgcolor="#CCCCCC"><strong>$<?php echo $row_collegetotal2['SUM(TUITION2+TRANSPORT2+PERSONAL2+ROOMBD2)']; ?></strong></td>
                          <td valign="top" bgcolor="#CCCCCC"><strong>$<?php echo $row_collegetotal3['SUM(TUITION3+TRANSPORT3+PERSONAL3+ROOMBD3)']; ?></strong></td>
                        </tr>
                        </table>
                    </fieldset></td>
                    </tr>
                  <tr>
                    <td colspan="2" valign="top"><table width="100%" border="0" cellspacing="2" cellpadding="2">
                      <tr>
                        <td width="149%" valign="top"><p><fieldset id="el11">
                          <legend><strong>Section 7B: Financial Information | Financial Aid</strong></legend><table width="100%" border="0" cellspacing="1" cellpadding="6">
                            <tr bgcolor="#cccccc">
                              <td width="48%" valign="top" bgcolor="#cccccc"><strong>Description/Source</strong></td>
                              <td width="52%" valign="top"><strong>Amount</strong></td>
                              </tr>
                            <tr>
                              <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['DESCRIPTION']; ?></td>
                              <td valign="top" bgcolor="#FFFFFF">$ <?php echo $row_your_scholarships['AMOUNT']; ?></td>
                              </tr>
                            <tr bgcolor="#cccccc">
                              <?php /*START_PHP_SIRFCIT*/ if ($row_your_sources['AMOUNT2']>"0"){ ?>
                                <td valign="top"><?php echo $row_your_scholarships['DESCRIPTION2']; ?></td>
                                <td valign="top">$ <?php echo $row_your_scholarships['AMOUNT2']; ?></td>
                                <?php } /*END_PHP_SIRFCIT*/ ?>
                              </tr>
                            <tr>
                              <?php /*START_PHP_SIRFCIT*/ if ($row_your_sources['AMOUNT3']>"0"){ ?>
                                <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['DESCRIPTION3']; ?></td>
                                <td valign="top" bgcolor="#FFFFFF">$ <?php echo $row_your_scholarships['AMOUNT3']; ?></td>
                                <?php } /*END_PHP_SIRFCIT*/ ?>
                              </tr>
                            <tr bgcolor="#cccccc">
                              <?php /*START_PHP_SIRFCIT*/ if ($row_your_sources['AMOUNT4']>"0"){ ?>
                                <td valign="top"><?php echo $row_your_scholarships['DESCRIPTION4']; ?></td>
                                <td valign="top">$ <?php echo $row_your_scholarships['AMOUNT4']; ?></td>
                                <?php } /*END_PHP_SIRFCIT*/ ?>
                              </tr>
                            <tr>
                              <?php /*START_PHP_SIRFCIT*/ if ($row_your_sources['AMOUNT5']>"0"){ ?>
                                <td valign="top" bgcolor="#FFFFFF"><?php echo $row_your_scholarships['DESCRIPTION5']; ?></td>
                                <td valign="top" bgcolor="#FFFFFF">$ <?php echo $row_your_scholarships['AMOUNT5']; ?></td>
                                <?php } /*END_PHP_SIRFCIT*/ ?>
                              </tr>
                            </table></fieldset></p></td>
                        </tr>
                      </table>
                      <table width="100%" border="0" cellspacing="2" cellpadding="2">
                        <tr>
                          <td width="99%" valign="top"><fieldset id="el11">
                            <legend><strong>Section 7C: Financial Information | Special Circumstances</strong></legend><table width="100%" border="0" cellspacing="1" cellpadding="6">
                              <tr>
                                <td width="149%" valign="top"><p>
                                  <label for="textarea"></label>
                                  <?php echo $row_your_scholarships['SPEC_CIRC']; ?></p></td>
                                </tr>
                              </table></fieldset></td>
                          </tr>
                        <tr>
                          <td align="right" valign="top">&nbsp;</td>
                          </tr>
                        </table>
                      <?php if ($totalRows_special_attach > 0) { // Show if recordset not empty ?>
  <table width="100%" border="0" cellspacing="2" cellpadding="2">
    <tr>
      <td width="866" valign="top"><fieldset id="el11">
        <legend><strong>Income Verification</strong></legend>
        <table width="100%" border="0" cellspacing="1" cellpadding="6">
          <tr>
            <td width="51%" valign="top" align="right"><strong>Person financially responsible for applicant:</strong></td>
            <td width="49%" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
              <tr>
                <td valign="top">Self
                  <input <?php if (!(strcmp($row_your_finances['FIN_RESP'],"1"))) {echo "checked=\"checked\"";} ?> type="radio" name="FIN_RESP" value="1" id="FIN_RESP_0" /></td>
                <td valign="top">Parent/Guardian
                  <input <?php if (!(strcmp($row_your_finances['FIN_RESP'],"2"))) {echo "checked=\"checked\"";} ?> type="radio" name="FIN_RESP" value="2" id="FIN_RESP_1" /></td>
                <td valign="top">Other
                  <input <?php if (!(strcmp($row_your_finances['FIN_RESP'],"3"))) {echo "checked=\"checked\"";} ?> type="radio" name="FIN_RESP" value="3" id="FIN_RESP_2" /></td>
                <td><?php echo $row_your_scholarships['FIN_RESP_OTHER']; ?></td>
                </tr>
              </table></td>
            </tr>
          <tr>
            <td valign="top" align="right"><strong>2010 Federal Income Tax Return Field?</strong></td>
            <td valign="top"><?php echo $row_your_scholarships['FED_RTN']; ?></td>
            </tr>
          <tr>
            <td valign="top" align="right"><strong>Adjusted Gross Income:</strong></td>
            <td valign="top">$<?php echo $row_your_scholarships['INCOME']; ?></td>
            </tr>
          <tr>
            <td align="right" valign="top"><strong>Family Financial Support Explanation:</strong></td>
            <td valign="top"><?php echo $row_your_scholarships['ZERO_INC']; ?></td>
            </tr>
          <tr>
            <td valign="top" align="right"><strong>Present market value of home (if owned):</strong></td>
            <td valign="top">$<?php echo $row_your_scholarships['MKTVAL_HOME']; ?></td>
            </tr>
          <tr>
            <td valign="top" align="right"><strong>Annual Mortgage Payment (if owned):</strong></td>
            <td valign="top">$<?php echo $row_your_scholarships['MORTGAGE']; ?></td>
            </tr>
          <tr>
            <td valign="top" align="right"><strong>Annual rental payment (non-homeowner):</strong></td>
            <td valign="top">$<?php echo $row_your_scholarships['RENT']; ?></td>
            </tr>
          <tr>
            <td valign="top" align="right"><strong>Medical and Dental expenses:</strong></td>
            <td valign="top">$<?php echo $row_your_scholarships['MED_DENT']; ?></td>
            </tr>
          <tr>
            <td valign="top" align="right"><strong>Total number of children living<br />
              in the home or receiving support:</strong></td>
            <td valign="top"><?php echo $row_your_scholarships['TOT_CHILD']; ?></td>
            </tr>
          <tr>
            <td valign="top" align="right"><strong>Total children currently attending college:</strong></td>
            <td valign="top"><?php echo $row_your_scholarships['SIB_COLLEGE']; ?></td>
            </tr>
          </table>
        </fieldset></td>
    </tr>
    <tr>
      <td valign="top"><fieldset id="el11">
        <legend><strong>Special Attachment Essay</strong></legend>
        <table width="100%" border="0" cellspacing="1" cellpadding="6">
          <tr>
            <td width="149%" valign="top"><p> <strong><?php echo $row_your_scholarships['ESSAY']; ?></strong></p>
              <p><?php echo $row_your_scholarships['STU_ESSAY']; ?></p></td>
          </tr>
        </table></fieldset></td>
    </tr>
    <?php if ($totalRows_winners > 0) { // Show if recordset not empty ?>
      <?php } // Show if recordset not empty ?>
  </table>
  <?php } // Show if recordset not empty ?></td>
                    </tr>
                  <tr>
                    <td colspan="2" valign="top"></td>
                    </tr><tr>
          <td valign="top"><?php echo $row_your_scholarships['FNAME']; ?>&nbsp;<?php echo $row_your_scholarships['LNAME']; ?> | <?php echo $row_your_scholarships['NAME']; ?></td>
        </tr>
                  </table></td>
                </tr>
              </table></td>
          
          </tr>
        </tbody>
      </table>
  </td>
  </tr>
  </tbody>
  </table>
  </td>
</tr>
</tbody>
</table><?php } while ($row_your_scholarships = mysql_fetch_assoc($your_scholarships)); ?>
<div class="ContentFooter"> </div>
	</div>
</body>
</html>
<?php
mysql_free_result($your_scholarships);
?>



Thanks again for everything, and yes, this is what the code in Dreamweaver looks like. :(
Was This Post Helpful? 0
  • +
  • -

#8 Dormilich  Icon User is offline

  • 痛覚残留
  • member icon

Reputation: 3541
  • View blog
  • Posts: 10,236
  • Joined: 08-June 10

Re: Print records that are checked off

Posted 12 December 2012 - 06:44 AM

the SQL on line #87 needs some serious work. as you can see, you pass the UID 7 times (!!!). that’s clearly a sign of bad design. you will need to make a proper JOIN on the tables, so that it suffices to pass the UID once.

and then I would (out of personal preference) use a Prepared Statement which I can feed the array’s values.

PS. if UID is a Primary Key, you won’t get more than one result per UID. (hence ORDER BY is superfluous)

This post has been edited by Dormilich: 12 December 2012 - 06:44 AM

Was This Post Helpful? 1
  • +
  • -

#9 lwaters  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 7
  • Joined: 11-December 12

Re: Print records that are checked off

Posted 12 December 2012 - 07:31 AM

The UID isn't a primary key. Is this the correct join statement?

SELECT *
FROM users 
INNER JOIN activities ON users.UID = activities.UID 
INNER JOIN coll_exp ON users.UID = coll_exp.UID 
INNER JOIN employ ON users.UID = employ.UID 
INNER JOIN fin_app ON users.UID = fin_app.UID 
INNER JOIN finaid ON users.UID = finaid.UID 
INNER JOIN stu_app2008 ON users.UID = stu_app2008.UID 
INNER JOIN stu_special ON users.UID = stu_special.UID
WHERE users.UID = colname


where colname is the url parameter UID?
Was This Post Helpful? 0
  • +
  • -

#10 Dormilich  Icon User is offline

  • 痛覚残留
  • member icon

Reputation: 3541
  • View blog
  • Posts: 10,236
  • Joined: 08-June 10

Re: Print records that are checked off

Posted 12 December 2012 - 08:56 AM

why isnít the UID a PK?

regarding the SQL, donít use *, use the proper field names or you donít know what to fetch.
Was This Post Helpful? 0
  • +
  • -

#11 lwaters  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 7
  • Joined: 11-December 12

Re: Print records that are checked off

Posted 12 December 2012 - 09:15 AM

Once I get the query correct, how does it know how to handle the array. With Dreamweaver, it always seems to assume it is not an array so it uses.
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}


So, I need to modify the above code some how. Again, I am a dummy at this. :)
Was This Post Helpful? 0
  • +
  • -

#12 Dormilich  Icon User is offline

  • 痛覚残留
  • member icon

Reputation: 3541
  • View blog
  • Posts: 10,236
  • Joined: 08-June 10

Re: Print records that are checked off

Posted 12 December 2012 - 07:07 PM

what array? the mysql result resource ainít one (therefore the fetch functions are required). and why DW uses a doÖwhile() loop instead of a while() loop remains a mystery (esp. since that approach fails for empty sets).


PS. GetSQLValueString() is a relatively complicated way to insert data (and I believe that non-integer numeric values (i.e. double) are also inserted using quotes). PHP 6 is not about to be released soon, magic_quotes are removed as of PHP 5.4, mysql_escape_string() is also long deprecated (mysql_real_escape_string() is supported since PHP 4.3!). explicitly inserting NULL by default may also break your database setup.
Was This Post Helpful? 1
  • +
  • -

Page 1 of 1