That cleared up all the errors on the screen, however, it is not displaying any of the information at all. On my view all page, I click the details button beside the record, and it should open this page with the records details in it for me to view, modify, or delete. In the URL bar it does show the correct path (msag/modify2.php?StreetID=249) but no information. and if I hit the edit key anyways, it throws that same bunch of unidentified variable errors as before.
see anything outright that could be causing this problem?
PHP Code:
<?php include 'includes/head/head_main.php'; ?>
<div id = "top_content">
<body>
<?php include 'includes/header/header_main.php'; ?>
<?php
include 'includes/db/connect.php';
if(isset($_POST['edit']))
{
$_StreetPrefix = $_rw['StreetPrefix'];
$_StreetName = $_rw['StreetName'];
$_LOWNUMBER = $_rw['LOWNUMBER'];
$_HighNumber = $_rw['HighNumber'];
$_EOB = $_rw['EOB'];
$_ESN = $_rw['ESN'];
$_COMMUNITY = $_rw['COMMUNITY'];
$_TELCO = $_rw['TELCO'];
$_MAP = $_rw['MAP'];
$_DateEntered = $_rw['DateEntered'];
$_DateModified = $_rw['DateModified'];
$_StreetID = $_rw['StreetID'];
$_SQL = "UPDATE MSAG SET StreetPrefix='$_StreetPrefix',
StreetName='$_StreetName',
LOWNUMBER='$_LOWNUMBER',
HighNumber='$_HighNumber',
EOB='$_EOB',
ESN='$_ESN',
COMMUNITY='$_COMMUNITY',
TELCO='$_TELCO',
MAP='$_MAP',
DateEntered='$_DateEntered',
DateModified='$_DateModified'
WHERE StreetID='$_StreetID'";
sqlsrv_query($_SQL) or die(sqlsrv_error());
//header("Location : index.php?id=$_id");
$_html ="<tabel><tr>
<td width=\"19%\">RECORD HAS BEEN </td>
<td width=\"81%\">UPDATED CLICK <a href=\"index.php\">HERE</a></td>
</tr></table>";
}
else
{
$_StreetID = (int)($_GET['StreetID']);
$_sql ="SELECT * FROM MSAG WHERE StreetID=$_StreetID";
$_rs = sqlsrv_query($conn, $_sql);
while($_rw = sqlsrv_fetch_array($_rs));
{
$_StreetID = $_rw['StreetID'];
$_StreetPrefix = $_rw['StreetPrefix'];
$_StreetName = $_rw['StreetName'];
$_LOWNUMBER = $_rw['LOWNUMBER'];
$_HighNumber = $_rw['HighNumber'];
$_EOB = $_rw['EOB'];
$_ESN = $_rw['ESN'];
$_COMMUNITY = $_rw['COMMUNITY'];
$_TELCO = $_rw['TELCO'];
$_MAP = $_rw['MAP'];
$_DateEntered = $_rw['DateEntered'];
$_DateModified = $_rw['DateModified'];
}
$_html=" <center>
<form action=\"\" method=\"post\" id=\"_form\" name=\"_form\" enctype=\"multipart/form-data\">
<table>
<tr>
<td>Directional: <br><input type=\"text\" name=\"_StreetPrefix\" size= \"8\" value=\"$_StreetPrefix\" /> <br></td>
<td>Street Name: <br><input type=\"text\" name=\"_StreetName\" size= \"50\" value=\"$_StreetName\" /> <br></td>
<td>Community: <br><input type=\"text\" name=\"_COMMUNITY\" size= \"50\" value=\"$_COMMUNITY\" /> <br></td>
</tr></table>
<br>
<table>
<tr>
<td>Low Range : <br><input type=\"text\" name=\"_LOWNUMBER\" size= \"8\" value=\"$_LOWNUMBER\" /> <br></td>
<td>High Range: <br><input type=\"text\" name=\"_HighNumber\" size= \"8\" value=\"$_HighNumber\" /> <br></td>
<td>OEB: <br><input type=\"text\" name=\"_EOB\" size= \"8\" value=\"$_EOB\" /> <br></td>
<td>ESN Number: <br><input type=\"text\" name=\"_ESN\" size= \"8\" value=\"$_ESN\" /> <br></td>
</tr></table>
<br>
<table>
<tr>
<td>Telco : <br><input type=\"text\" name=\"_TELCO\" size= \"8\" value=\"$_TELCO\" /> <br></td>
<td>Map Number: <br><input type=\"text\" name=\"_MAP\" size= \"8\" value=\"$_MAP\" /> <br></td>
</tr></table>
<br>
<table>
<tr>
<td>Entry Date : <br><input type=\"text\" name=\"_DateEntered\" size= \"8\" value=\"$_DateEntered\" /> <br></td>
<td>Last Modified: <br><input type=\"text\" name=\"_DateModified\" size= \"8\" value=\"$_DateModified\" /> <br></td>
</tr></table>
<br>
<table>
<tr>
<td>
<input type=\"submit\" align = \"left\" name=\"edit\" value=\"Edit\"/>
<input type=\"hidden\" name=\"id\" value=\"$_StreetID\"/>
</td>
<td>
<input type=\"submit\" id=\"delete\" name=\"delete\" value=\"Delete\"/>
<input type=\"hidden\" name=\"id\" value=\"$_StreetID\"/>
</td>
</tr>
</table>
</center>";
}
?>
<center>
<h1><u>Record Details</u></h1>
<br>
<br>
</center>
<?php echo $_html; ?>