Home Ask Login Register

Developers Planet

Your answer is one click away!

James February 2016

Being able to delete a certain result from an SQL while loop

I have looked around for an answer but cannot seem to find one.

I would like to be able to delete a specific query from the database.

How am I able to remove a specific one from the form and post it into an SQL statement to delete?

Here is my current select statement.

if (isset($_POST['submit']))
  echo "Hello!";
  $selectOption = $_POST['info'];

  $query = "SELECT * FROM `REQUESTS` ORDER BY $selectOption"; 
  echo $query;
  $result = $db->query($query);
  if ($result == FALSE) { 
        die ("could not execute statement $query<br />");
  echo "<form action='' method='post'>";
  echo "<table>";     

  if ($row['status'] == 0) {
  else if ($row['status'] == 1){
  else if ($row['status'] == 2){

  echo "<tr id=".$type."><td>" . $row['requestid'] . "</td>";
  echo "<td>" . $row['booking_type'] . "</td>";
  echo "<td>" . $row['userid'] . "</td>";
  echo "<td>" . $row['moduleid'] . "</td>";
  echo "<td>" . $row['no_rooms'] . "</td>";
  echo "<td>" . $row['park'] . "</td>";
  echo "<td>" . $row['semester'] . "</td>";
  echo "<td>" . $row['day'] . "</td>";
  echo "<td>" . $row['start_time'] . "</td>";
  echo "<td>" . $row['end_time'] . "</td>";
  echo "<td>" . $row['length'] . "</td>";
  echo "<td>" . $row['students'] . "</td>";
  echo "<td>" . $row['priority'] . "</td>";
  echo "<td>" . $row['comments'] . "</td>";
  echo "<td>" . $row['status'] . "</td>";

  // <td class="'.(($row['status'] == 2) ? 'status-rejected' : 'status-accepted'). '">'.$row['status'].'</td>';
  echo "<td>".$stats."</td>";*/
  echo "<td>" . $row['round'] . "</td>";


DurtyFree February 2016

I don't exactly understand what you are trying to delete.

If you want to actually delete a data / row in your database, you need to use the DELETE Statement as explained here: http://www.w3schools.com/sql/sql_delete.asp

I guess your statement would look something like this:

WHERE requestid=$row['requestid']; 

$row['requestid'] is the actual unique key identifier to the data row you would like to delete.

edit: You could create a button / link to the exact page with an GET data (yourpage.php?deleteid=1) to pass the id of the data you would like to delete from the database.

Keep in mind that using GET paratemers isn't the best way to do this. You should rather use a form and POST the regarding id.

Post Status

Asked in February 2016
Viewed 1,208 times
Voted 12
Answered 1 times


Leave an answer

Quote of the day: live life