thansk for the help but that did not work Here is what i have
this is the whole script from top to botto, html included
Hope this not to much info but i wanted to give you the whole picture
PHP Code:
<?
// survey_details.php - display the site surveys
// includes
include("config.php");
include("functions.php");
/*
// check for missing parameters
if (!$cir_id || $cir_id == "")
{
header("Location:error.php");
exit;
}
*/
// open connection to database
$connection = mysql_connect($hostname, $user, $pass) or die ("Unable to connect!");
// get site survey details
// use a join to get data from different tables
$query = "SELECT DISTINCT survey.cir_id, survey.cust_name, survey.cust_contact, survey.cust_phone, survey.ext, phonelist.phonelist, survey.altphnum, survey.cust_address, power.power, survey.dist_power, powerstrip.powerstrip, equptmount.equptmount, space.space, survey.concerns, ilecextend.ilecextend, focalextend.focalextend, survey.addinfo, survey.tech_name, survey.tech_phone, survey.lec_foc, survey.focal_foc, city.city, survey.survey_date from survey, phonelist, power, powerstrip, equptmount, space, ilecextend, focalextend, city WHERE phonelist.id = survey.f_altphone AND power.id = survey.f_power AND powerstrip.id = survey.f_powerstrip AND equptmount.id = survey.f_eqptmount AND space.id = survey.f_space AND ilecextend.id = survey.f_ilecextend AND focalextend.id = survey.f_focalextend AND city.id = survey.f_city AND survey.cir_id = cir_id";
$result = mysql_db_query($database, $query, $connection) or die ("Error in query: $query. " . mysql_error());
echo " <p>$query</p>";
// echo "<br>";
// echo " <p>$result</p>";
// error chec
/*
if (mysql_num_rows($result) <= 0)
{
header("Location:error.php");
exit;
}
else
{
*/
// obtain data from resultset
while(list($cir_id, $cust_name, $cust_contact, $cust_phone, $ext, $phonelist, $altphnum, $cust_address, $power, $dist_power, $powerstrip, $equptmount, $space, $concerns, $ilecextend, $focalextend, $addinfo, $tech_name, $tech_phone, $lec_foc, $focal_foc, $city, $survey_date) = mysql_fetch_row($result))
{
// what you want to do here
// clean up
// mysql_close($connection);
?>
<html>
<head>
</head>
<body bgcolor=white>
<table width="100%" height="100%" cellspacing="0" cellpadding="0" border="0">
<tr>
<td>
<table width="100%" cellspacing="0" cellpadding="2" border="0">
<tr><font size="+1">Customer Information</font><br><br>
<td colspan="4">Focal Circuit ID. <input type="text" name="cir_id" value="<? echo $cir_id; ?>" readonly></td>
</tr>
<tr>
<td colspan="4">Focal Customer Name <input type="text" name="cust_name" value="<? echo $cust_name; ?>" readonly></td>
</tr>
<tr>
<td colspan="4">Customer Contact <input type="text" name="cust_contact" value="<? echo $cust_contact; ?>" readonly></td>
</tr>
<tr>
<td>Customer Phone #<INPUT TYPE="text" NAME="cust_phone" MAXLENGTH=12 SIZE="12" value="<? echo $cust_phone ?>" readonly></td>
<td>Extension<INPUT TYPE="text" NAME="ext" MAXLENGTH=5 SIZE="4" value="<? echo $ext; ?>" readonly></td>
<td>Alternate contact device <input type="text" name="altphone" value="<? echo $phonelist; ?>" readonly></td>
<td>Phone Number<INPUT TYPE="text" NAME="phone" MAXLENGTH=12 SIZE="12" value="<? echo $altphnum; ?>" readonly ></td>
</tr>
<tr>
<td colspan="4">Customer Address <INPUT TYPE="text" NAME="cust_address" value="<? echo $cust_address; ?>" readonly></td>
</tr>
</table>
<hr width="100%" size="2">
<br>
<br>
<font size="+2">Site Survey</font><BR><BR>
Please Make sure the following is available where the equipment is to be installed.<BR>
<table width="100%" cellspacing="0" cellpadding="2" border="0">
<tr>
<td colspan="2">Are the proper Power requirements available <INPUT TYPE="text" NAME="power" value="<? echo $power; ?>" readonly></td>
</tr>
<tr>
<td>approx. distance to Power <INPUT TYPE="text" NAME="dist_power" value="<? echo $dist_power; ?>"> Ft.</td>
<td>Does Focal need to supply the Power Strip? (if the distance is over 5 Ft.)<INPUT TYPE="text" NAME="powerstrip" value="<? echo $powerstrip; ?>" readonly></td>
</tr>
<tr>
<td colspan="2">Method of mounting the Equipment <INPUT TYPE="text" NAME="equptmount" value="<? echo $equptmount; ?>" readonly></td>
</tr>
<tr>
<td colspan="2">Proper Space (At least 3sq. Ft.)<INPUT TYPE="text" NAME="space" value="<? echo $space; ?>" readonly></td>
</tr>
<tr>
<td colspan="2"><font color="red"><b>Potential Concerns</B></font> where the equipment is going to be installed.</td>
</tr>
<tr>
<td colspan="2"><TEXTAREA NAME="concerns" ROWS="6" COLS="40" readonly>
<?
echo "$concerns";
?>
</TEXTAREA></td>
</tr>
</table>
<hr width="100%" size="2">
<br>
<br>
Please Verify the Dmarc Location<br>
<table width="100%" cellspacing="0" cellpadding="2" border="0">
<tr>
<td>Is the Dmarc extended <INPUT TYPE="text" NAME="ilecextend" value="<? echo $ilecextend; ?>" readonly></td>
</tr>
<tr>
<td>Do we have to extend the circuit. <INPUT TYPE="text" NAME="focalextent" value="<? echo $focalextend; ?>" readonly></td>
</tr>
<tr>
<td>Please give us any additional information: (I.E. Is the 66 Block far away from the location Of the IAD Equipment)</td>
</tr>
<tr>
<td><TEXTAREA NAME="addinfo" ROWS="6" COLS="40" readonly >
<?
echo "$addinfo";
?>
</TEXTAREA></td>
</tr>
</table>
<hr width="100%" size="2">
<br>
<br>
Site Survey Preformed by:<br>
<table width="100%" cellspacing="2" cellpadding="2" border="0">
<tr>
<td colspan="2">Tech Name <input type="text" name="tech_name" value="<? echo $tech_name; ?>" readonly></td>
</tr>
<tr>
<td colspan="2">Tech Phone Number <INPUT TYPE="text" NAME="tech_phone" MAXLENGTH=12 SIZE="12" value="<? echo $tech_phone; ?>" readonly></td>
</tr>
<tr>
<td>LEC Loop FOC date <input type=text size=10 name=lec_foc value="<? echo $lec_foc; ?>" readonly></td>
<td>Focal FOC date <input type=text size=10 name=focal_foc value="<? echo $focal_foc; ?>" readonly ></td>
</tr>
<tr>
<td colspan="2">What City sold this Service <INPUT TYPE="text" NAME="city" value="<? echo $city; ?>" readonly></td>
</tr>
<tr>
<td colspan="2">Date Survey was Preformed on <input type=text size=10 name=date value="<? echo $survey_date; ?>" readonly></td>
</tr>
</table>
</body>
</html>
<?
}
?>
|