Well obviously I'm stuck and really have no idea where to begin. I'm sorry when I posted I didn't know I would get a lecture from my parents. I came for help not a lecture or how I should handle my homework. From everything else I've seen you all are quite helpful and don't give the others lectures. This is what I had a few days ago and had working but anytime I add anything else, it stops.
<?php require_once('../../../Connections/Evaluation_Admin.php'); ?>
<?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_Recordset1 = "-1";
if (isset($_POST['employee'])) {
$colname_Recordset1 = $_POST['employee'];
}
mysql_select_db($database_Evaluation_Admin, $Evaluation_Admin);
$query_Recordset1 = sprintf("SELECT Who_being_reviewed FROM Survey_Responses WHERE Who_being_reviewed = %s", GetSQLValueString($colname_Recordset1, "text"));
$Recordset1 = mysql_query($query_Recordset1, $Evaluation_Admin) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
$colname_Recordset2 = "-1";
if (isset($_POST['id'])) {
$colname_Recordset2 = $_POST['id'];
}
mysql_select_db($database_Evaluation_Admin, $Evaluation_Admin);
$query_Recordset2 = sprintf("SELECT * FROM Employee_Info WHERE id = %s", GetSQLValueString($colname_Recordset2, "int"));
$Recordset2 = mysql_query($query_Recordset2, $Evaluation_Admin) or die(mysql_error());
$row_Recordset2 = mysql_fetch_assoc($Recordset2);
$totalRows_Recordset2 = mysql_num_rows($Recordset2);
?>
<!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" />
<title>Client/Customer Listing</title>
<link href="http://www.wiu.edu/users/ac118/419Spr2010/evaluation/admin/styles.css" rel="stylesheet" type="text/css" /><!--[if IE 5]>
<style type="text/css">
/* place css box model fixes for IE 5* in this conditional comment */
.twoColFixLt #sidebar1 { width: 230px; }
</style>
<![endif]--><!--[if IE]>
<style type="text/css">
/* place css fixes for all versions of IE in this conditional comment */
.twoColFixLt #sidebar1 { padding-top: 30px; }
.twoColFixLt #mainContent { zoom: 1; }
/* the above proprietary zoom property gives IE the hasLayout it needs to avoid several bugs */
</style>
<![endif]-->
</head>
<body class="twoColFixLt">
<script type='Text/JavaScript' src='scw.js'></script>
<div id="container">
<div id="sidebar1">
<h3>Navigation</h3>
<p><?php include('../nav.inc'); ?> </p>
<!-- end #sidebar1 --></div>
<div id="mainContent">
<h1> Report<!-- end #mainContent -->
</h1>
<form id="form1" name="form1" method="get" action="">
<p><?php echo $row_Recordset1['id']; ?></p>
</form>
<p> </p>
</div>
<!-- This clearing element should immediately follow the #mainContent div in order to force the #container div to contain all child floats --><br class="clearfloat" />
<!-- end #container --></div>
</body>
</html>
<?php
mysql_free_result($Recordset1);
mysql_free_result($Recordset2);
?>
If I knew how to do this I wouldn't be here obviously. If I wanted it built for me I'd go copy it. I want neither. I want someone who has more knowledge than me to HELP me and actually explain how it should be built correctly.
