1
I'm new to XOOPS but loving every minute of it. I'm building my first module which does little more than add and edit records from a single table. However, I can't seem to get xoopsDB to delete a record for me. I've been able to search and update records with no issues, but the following code doesn't work. Can someone enlighten me?
$sql = "DELETE FROM ".$xoopsDB->prefix('mytable')." WHERE recordid = ".$_GET['id'];
$result = $xoopsDB->query($sql);
The SQL statement works if given directly to my MySQL server.
