Jeff,
You can create your own GUI with a 3-page set like this:
Create a form in a page called searchadtodrop.php3 with a search field where you can enter all or part of the listing you want to drop:
searchadtodrop.php3
<pre>
<form action="dropad.php3">
Drop this ad: <input type="text" name="adname" size="40">
<input type="submit" value="Drop It!">
</form>
</pre>
Typing in the search field and hitting the Drop It! button sends the variable $adname (or whatever you choose to call it) to the page dropad.php3. If what you typed matches no row or more than one row in the database, the page warns that you have no precise match and sends you back to searchadtodrop.php3. If what you typed matches only one row, the page runs a MySQL query that pulls up the ad name and id associated with that row and asks you to confirm the drop.
dropad.php3
<pre>
<form action="postdrop.php3" method="POST" >
Confirm Drop
[nbsp][nbsp][nbsp][nbsp][nbsp][nbsp][nbsp]
<?
[nbsp][nbsp][nbsp][nbsp][nbsp]mysql_connect("$Host", "$User", "$Pass");
[nbsp][nbsp][nbsp][nbsp][nbsp]mysql_select_db("$DB");
[nbsp][nbsp][nbsp][nbsp][nbsp]$query = " SELECT COUNT(id) as id from adtable WHERE ad like '%$adname%' ";
$mysql_result = mysql_query($query);
while($row = mysql_fetch_row($mysql_result))
{
[nbsp][nbsp][nbsp][nbsp][nbsp]IF($row[0] !=1)
[nbsp][nbsp][nbsp][nbsp][nbsp]{
[nbsp][nbsp][nbsp][nbsp][nbsp]print("No precise match. Return to the <a href=searchadtodrop.php3>Drop Form</a> and try again.\n");
[nbsp][nbsp][nbsp][nbsp][nbsp]}
[nbsp][nbsp][nbsp][nbsp][nbsp]Else
[nbsp][nbsp][nbsp][nbsp][nbsp]{
[nbsp][nbsp][nbsp][nbsp][nbsp]$query = " SELECT id, ad, adstatus FROM adtable WHERE ad like '%$adname%' " ;
[nbsp][nbsp][nbsp][nbsp][nbsp]$mysql_result = mysql_query($query);
[nbsp][nbsp][nbsp][nbsp][nbsp]while($row = mysql_fetch_row($mysql_result))
[nbsp][nbsp][nbsp][nbsp][nbsp]{
[nbsp][nbsp][nbsp][nbsp][nbsp]print("<input type=hidden name=this_id value=" . $row[0] . ">Change the status of " . $row[1] . " from " . $row[2] . " to Dropped?
<input type=submit[nbsp][nbsp]value=Submit>[nbsp][nbsp] <a href=searchadtodrop.php3>Back to Form</a>
\n");
[nbsp][nbsp][nbsp][nbsp][nbsp]}
[nbsp][nbsp][nbsp][nbsp][nbsp]}
}
[nbsp][nbsp][nbsp][nbsp][nbsp]mysql_close();
?>
</form>
</pre>
Confirming the drop sends you to postdrop.php3, which executes a MySQL query that changes the status of the ad to "Dropped." Or - infinitely more dangerous - you could change the query to delete the row. In either case, the action is limited to the row defined by the experession WHERE id='$this_id', fetched in the previous query and passed along to postdrop.php3 as a hidden variable.
postdrop.php3
<pre>
<?
[nbsp][nbsp][nbsp][nbsp][nbsp]mysql_connect("$Host", "$User", "$Password");
[nbsp][nbsp][nbsp][nbsp][nbsp]mysql_select_db("$DB");
[nbsp][nbsp][nbsp][nbsp][nbsp]$query = " SELECT id, adname FROM adtable WHERE id='$this_id' " ;
[nbsp][nbsp][nbsp][nbsp][nbsp]$mysql_result = mysql_query($query);
[nbsp][nbsp][nbsp][nbsp][nbsp]while($row = mysql_fetch_row($mysql_result))
[nbsp][nbsp][nbsp][nbsp][nbsp]{
[nbsp][nbsp][nbsp][nbsp][nbsp]print("Sayonara,[nbsp][nbsp]" . $row[1] . "!\n");
[nbsp][nbsp][nbsp][nbsp][nbsp]}
[nbsp][nbsp][nbsp][nbsp][nbsp]$query = " UPDATE adtable SET adstatus='Dropped' WHERE id='$this_id' " ;
[nbsp][nbsp][nbsp][nbsp][nbsp]$mysql_result = mysql_query($query);
[nbsp][nbsp][nbsp][nbsp][nbsp]mysql_close();
?>
</pre>
There may be a typo or two here as I stripped out a lot of formatting for the sake of clarity.
Be sure to put these forms in a secure directory.
Wayne