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 9:22 am by Jamie | Last modified 10/14/2019 11:46 am by Ray Borduin | 160 views | 4 replies |

10/11/2019 9:22 am | #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 9:39 am | #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.

Did this help? Tips are appreciated...

10/11/2019 9:50 am | #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 11:45 am | #4 Ray BorduinWebAssist

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

Did this help? Tips are appreciated...

10/12/2019 10:06 am | #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.