[willscarlet]

Hello everyone, back to this script you guys helped with earlier. I have everything else working now except for my 'update' page and script. when the user selects a criteria and hits the search button, all works well. The problem, however, is that with ever output record is a 'details' button that when pressed will take them to a page with that specific records details on it and allow them to modify or delete it. When the press the button though, it just takes you back to the same page without any records on it. Any see something wrong with my code or have any ideas?

Main Page:

PHP Code:

<center><h1><u> MSAG Database </u></h1>
<br>            
<br>
        
<?php include 'includes/menu.php'; ?>
            
<form method="post" action="index.php">
<input type="hidden" name="submitted" value="true" />

<label>Search Category:

<select name="category">
    <option value="StreetName">Street Name</option>
    <option value="LOWNUMBER">Low Range</option>
    <option value="HighNumber">High Range</option>
    <option value="EOB">OEB</option>
    <option value="ESN">ESN Number</option>
    <option value="COMMUNITY">Community</option>
    <option value="TELCO">Telco</option>
    <option value="MAP">Map Number</option>
    <option value="DateEntered">Entry Date</option>
    <option value="DateUpdated">Last Modified</option>
</select>
</label>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<label>Search Criteria: <input type="text" name="criteria" /></label>

<input type="submit" name="search" value="Search"/>

</form>

</center>
<?php

include 'includes/db/connect.php';

if(isset($_POST['search']) || isset($_POST['submit']))
{     
    $category = $_POST['category'];
    $criteria = $_POST['criteria'];
    
    $query = "SELECT * FROM MSAG WHERE $category LIKE '%$criteria%' ORDER BY StreetName ASC";
    $resource=sqlsrv_query($conn, $query) or die(print_r(sqlsrv_errors(), true));


echo "
<form action=\"\" method=\"post\">
        <table align=\"center\" border=\"1\" cellpadding=\"2\" cellspacing=\"2\" width=\"100%\" >
        <tr align = 'center'>
            <td><b>Prefix</b></td>
            <td><b>Street Name</b></td>
            <td><b>Low</b></td>
            <td><b>High</b></td>
            <td><b>OEB</b></td>
            <td><b>ESN #</b></td>
            <td><b>Community</b></td>
            <td><b>Telco</b></td>
            <td><b>Map #</b></td>
            <td><b>Entry Date</b></td>
            <td><b>Last Modified</b></td>
            <td><b>Details</b></td>
        </tr>
";

while($result=sqlsrv_fetch_array($resource))
{ 
    echo "
<tr align = center>
<td>".$result['StreetPrefix']."</td>
<td>".$result['StreetName']."</td>
<td>".$result['LOWNUMBER']."</td>
<td>".$result['HighNumber']."</td>
<td>".$result['EOB']."</td>
<td>".$result['ESN']."</td>
<td>".$result['COMMUNITY']."</td>
<td>".$result['TELCO']."</td>
<td>".$result['MAP']."</td>
<td>".(($result['DateEntered'] instanceof DateTime) ? $result['DateEntered']->format('Y-m-d') : $result['DateEntered']) ." </td>
<td>".(($result['DateUpdated'] instanceof DateTime) ? $result['DateUpdated']->format('Y-m-d') : $result['DateUpdated']) ." </td>
<td><a href=\"modify2.php?StreetID=".$result['StreetID']."\"><input type=\"submit\" name = \"details\" value = \"Details\" /></a></td>
</tr>
";         
}
}    
?>
</table>
</form>

update/delete page:

PHP Code:

<?php
include 'includes/db/connect.php';
$_StreetID = (int)($_GET['StreetID']);
$_sql ="SELECT * FROM `records` WHERE `StreetID`=$_StreetID";
$_rs = mysql_query($_sql);
while($_rw = mysql_fetch_assoc($_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'];
}

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 `records` 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'"; 
        
  mysql_query($_SQL) or die(mysql_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>"; 
} 
elseif(isset($_POST['delete'])) 
{ 
    $id = (int)$_POST['id']; 
    mysql_query("DELETE FROM `records` WHERE `StreetID`='$StreetID' LIMIT 1"); 
    $_html = 'Record deleted successfully!<br/><a href="index.php">Return to "Home" page.</a>'; 

        if ("default" != GetFileName($_POST['_front'])){
    unlink($_POST['_front']);
    }
    if ("default" != GetFileName($_POST['_rear'])){
    unlink($_POST['_rear']);
    }
    if ("default" != GetFileName($_POST['_right'])){
    unlink($_POST['_right']);
    }
    if ("default" != GetFileName($_POST['_left'])){
    unlink($_POST['_left']);
    }
    if ("default" != GetFileName($_POST['_intfront'])){
    unlink($_POST['_intfront']);
    }
    if ("default" != GetFileName($_POST['_intrear'])){
    unlink($_POST['_intrear']);
    }

} 
else 
{ 
$_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; ?>