Posted by Mike Tuller on 10/06/24 11:36

Excuse the last post, I didn't have all the code it there.

I have a table listing items in a database, and have a delete button
next to each item, and I want to be able to click on the delete and
delete only that record in the database and then reload the page
where it would display the updated information. Here is part of the
code I have.

// list elements one by one until there are no more in the database
while ( $row=mysql_fetch_array($result2) )
{
if ($row[range] != "")
{
echo "
<form action=".$_SERVER['PHP_SELF']." method=\"post\" name=
\"deleteRange\">
<tr class=\"trlist\">
<td>$row[id]</td>
<td>$row[range]</td>
<td align=\"right\"><input type=\"submit\" name=\"deleteRange\"
value=\"Delete\" /></td>
</tr>
</form>
";
}
}
echo "</table>";

echo "
<br />
<form action=".$_SERVER['PHP_SELF']." method=\"post\" name=
\"addrange\">
<table class=\"nolist\">
<tr>
<td>Add Range: $row[id]</td>
<td><input type=\"text\" name=\"name\" size=\"53\" tabindex=\"9
\" /></td>
<td align=\"right\"><input type=\"submit\" name=\"addRange\"
value=\"Add Range\" /></td>
</tr>

</table>
</form>";



}
elseif (isset($_POST['deleteRange']))
{

$query = "delete from district.ip_range where id = $row[id]";

mysql_query($query, $link) or die (mysql_error());

echo "Record ".$row[id]." has beed deleted.";

}

They key I am using to find the record I want to delete is the the
$row[id], but that is out of the scope of where the variable is set.
Is there a way to set a variable so that it goes outside the scope?

[Back to original message]