PHP/SQL query will not execute

Question

Hello for some reason the SQL query will not run and it will not delete the row in the database. I was wondering if anyone has any idea why this is?

choosebid.php:

<td>
  <form method = "POST" action= "actionpage9.php">
    <input type="hidden" value="<?php echo $row['bid_id']?>" name="bid_id" />
    <input type="submit" class="btn btn-xlarge btn-block btn-primary" value ="decline" />
  </form>
</td>

actionpage9.php:

<?php
require 'config.php';

$bid_id    = $_POST['bid_id'];

$query   = "DELETE FROM bid WHERE 'bid_id' = '$bid_id'";
$success = $conn->query($query);

if (!$success) {
    die("Couldn't enter data: ".$conn->error);
}

header("location: choosebid.php");
$conn->close();
?>

Did you try to replace the `Delete` by a `Select` and see if you get any results? — Dominique, Apr 24 '18 at 13:25
Did you try to echo value of `$bid_id` or echo your `$query' variable — Mohammad Wasim, Apr 24 '18 at 13:28

score 0 · Answer 1 · answered Apr 24 '18 at 13:28

0

Change your SQL statement from delete to drop

answered Apr 24 '18 at 13:28

MoeAmeen Mayet

53
10

PHP/SQL query will not execute

1 Answers1