I added the $conn variable to the first sqsrv query and it cleared that error. I decided to print oujt the errors a little different and this is what I came up with:
[CODE]Notice: Undefined variable: rs in C:\Inetpub\wwwroot\msag\modify2.php on line 53 Warning: sqlsrv_fetch_array(): supplied resource is not a valid ss_sqlsrv_stmt resource in C:\Inetpub\wwwroot\msag\modify2.php on line 53 Array ( [0] => Array ( [0] => IMSSP [SQLSTATE] => IMSSP [1] => -14
Code:
=> -14 [2] => An invalid parameter was passed to sqlsrv_fetch_array. [message] => An invalid parameter was passed to sqlsrv_fetch_array. ) )
The new code is:
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($conn, $rs) or die(print_r(sqlsrv_errors(), true)));
{
$_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=\"$_StreeName\" /> <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; ?>