Form Button as a MySQL Delete function...

[Mr_Mako]

Hi...

I'm trying to set up a display that has a forum button as the way to delete a contact from a database. What I have so far is this:

The display block itself -

$display_block ="
     <font size=2><b>$name</b> - $address<input type=submit value=Delete? name=$name>";

and the delete code itself -

$name = $_GET[name];

$sql = "DELETE FROM $table_name WHERE name = '$name'";
$result = @mysql_query($sql, $connect) or die(mysql_error());

What I'm getting is basically a NULL value when I click the delete button. How do I pass the variable $name through to the next page with a button so the delete function can see it to delete it?

[tekky]

because you are using $name...

name=$name>";

not 'name' to assign the button name....

try doing

<input type=Submit value=Delete name=delete>

then

if isset($_GET['delete'])
{
  //do delete query
}

[Mr_Mako]

Ok... I see what you're saying...

But I guess I forgot to mention that I have a whole list of people on this page. The code uses a "while" statement to list the individuals in the database, and the above display block lists them.

So that won't really work. I need to specify the specific name variable of each individual through the Delete button to the deletion function page.

When I try the code above, I don't get any records deleted, but I also don't get any error messages either.

[tekky]

foreach $_POST as $key => $val
{
   if ($val == 'Delete')
   {
      //do delete query
   }
}

err obviously you can interchange $GET/$POST I would recommend POST for these kinda pages but... whichever you prefer on your site