in case anyone has a need for a smiliar script, This is the fixed code so far:
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']))
{
$_StreetName = $_POST['StreetName'];
$_StreetID = $_POST['StreetID'];
$_SQL = "UPDATE MSAG SET StreetName='$StreetName'
WHERE StreetID='$StreetID'";
sqlsrv_query($_SQL) or die(sqlsrv_error());
$_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']);
$query ="SELECT * FROM MSAG WHERE StreetID=$StreetID";
$resource = sqlsrv_query($conn, $query);
while($result=sqlsrv_fetch_array($resource))
{
echo "
<center>
<h1><u>Record Details</u></h1>
<br>
<br>
</center>
<form action=\"\" method=\"post\" id=\"_form\" name=\"_form\" enctype=\"multipart/form-data\">
<table>
<tr>
<td>Prefix <br><input type=\"text\" name=\"StreetPrefix\" value=".$result['StreetPrefix']."> <br></td>
<td>Street: <br><input type=\"text\" name=\"StreetName\" value=".$result['StreetName']."> <br></td>
<td>Suffix <br><input type=\"text\" name=\"StreetSuffix\" value=".$result['StreetSuffix']."> <br></td>
<td>Post <br><input type=\"text\" name=\"StreetPostDi\" value=".$result['StreetPostDir']."> <br></td>
<td>Community: <br><input type=\"text\" name=\"COMMUNITY\" value=".$result['COMMUNITY']."> <br></td>
</tr></table>
<br>
<table>
<tr>
<td>Low: <br><input type=\"text\" name=\"LOWNUMBER\" value=".$result['LOWNUMBER']."> <br></td>
<td>High: <br><input type=\"text\" name=\"HighNumber\" value=".$result['HighNumber']."> <br></td>
<td>EOB: <br><input type=\"text\" name=\"EOB\" value=".$result['EOB']."> <br></td>
<td>ESN: <br><input type=\"text\" name=\"ESN\" value=".$result['ESN']."> <br></td>
</tr>
</table>
<br>
<table>
<tr>
<td>Telco: <br><input type=\"text\" name=\"TELCO\" value=".$result['TELCO']."> <br></td>
<td>Map: <br><input type=\"text\" name=\"MAP\" value=".$result['MAP']."> <br></td>
<td>Zone: <br><input type=\"text\" name=\"ZONE\" value=".$result['ZONE']."> <br></td>
<td>ZIP: <br><input type=\"text\" name=\"PostOffice\" value=".$result['PostOffice']."> <br></td>
</tr>
</table>
<br>
<table>
<tr>
<td>Entered: <br><input type=\"text\" name=\"DateEntered\" value=".(($result['DateEntered'] instanceof DateTime) ? $result['DateEntered']->format('Y-m-d') : $result['DateEntered'])."> <br></td>
<td>Modified: <br><input type=\"text\" name=\"DateUpdated\" value=".(($result['DateUpdated'] instanceof DateTime) ? $result['DateUpdated']->format('Y-m-d') : $result['DateUpdated'])."> <br></td>
</tr>
</table>
<br>
<table>
<tr>
<td>Comments: <br><input type=\"text\" name=\"Commments\" value=".$result['Commments']."> <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>
";
}
}
?>
Now all is needed is to make it able to update the record or delete the record. If anyone has done this in MsSQL, I owuld appreciate some guidance and advice. I will post the finished code once I figure it out though. and thank you guys for all your help so far
