Databridge V2 with MySQLi support IS Now Available!

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › General / Announcements › PHP and MySQL › deleting a row

deleting a row

Thread began 10/11/2019 12:22 pm by Jamie | Last modified 10/14/2019 2:46 pm by Ray Borduin | 32 views | 4 replies |

10/11/2019 12:22 pm | #1 Jamie

deleting a row

Hi Ray

On the site you helped me with the other day (the content history) just wondering how I get the delete button on the attached to work to delete the selected item from the drop down.

Cheers

Jamie

10/11/2019 12:39 pm | #2 Ray BorduinWebAssist

Just use the delete server behavior triggered on the delete button press with the HistoryID from the select list as the deleted item index.

10/11/2019 12:50 pm | #3 Jamie

isnt that what I have done here?

<?php
if (isset($_POST["Delete"]) || isset($_POST["Delete_x"])) {
  $DeleteQuery = new WA_MySQLi_Query($DBConnection);
  $DeleteQuery->Action = "delete";
  $DeleteQuery->Table = "content_history";
  $DeleteQuery->addFilter("HistoryID", "=", "i", "".($_GET['HistoryID'])  ."");
  $DeleteQuery->execute();
  $DeleteGoTo = "";
  if (function_exists("rel2abs")) $DeleteGoTo = $DeleteGoTo?rel2abs($DeleteGoTo,dirname(__FILE__)):"";
  $DeleteQuery->redirect($DeleteGoTo);
}
?>

10/11/2019 2:45 pm | #4 Ray BorduinWebAssist

$_GET['HistoryID'] should be: $_POST['HistoryID']

10/12/2019 1:06 pm | #5 Jamie

perfect thanks

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.