Ah, ok. I now get the print out of:
There are 0 records returned.
I went to my SQL DB and ran ran a querry for ID number 249
(msag/modify2.php?StreetID=249) and the record is indeed in the DB but still nothing outputs to the screen but the empty form. the CSS and all the form boxes show, just empty. Since it shows the correct StreetID number in the URL im assuming that it is in fact finding the record, just wont show it, Its got to just be a simple syntax error on my part in tryin to convert it from MySQL to MsSQL, but i fail to see the error.
Any suggestions, sir?
PHP Code:
<?php include 'includes/head/head_main.php'; ?>
<div id = "top_content">
<body>
<?php
ini_set('display_errors', 1);
error_reporting(E_ALL);
include 'includes/header/header_main.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);
printf('There are %d records returned.', sqlsrv_num_rows($_rs));
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; ?>