The following warnings occurred:
Warning [2] Undefined variable $unreadreports - Line: 26 - File: global.php(961) : eval()'d code PHP 8.2.25 (Linux)
File Line Function
/global.php(961) : eval()'d code 26 errorHandler->error
/global.php 961 eval
/printthread.php 16 require_once



UserSpice
DB Delete - Printable Version

+- UserSpice (https://userspice.com/forums)
+-- Forum: Support Center (https://userspice.com/forums/forumdisplay.php?fid=23)
+--- Forum: UserSpice 4.4 (https://userspice.com/forums/forumdisplay.php?fid=27)
+--- Thread: DB Delete (/showthread.php?tid=1335)



DB Delete - rob@selectech.us - 02-16-2019

I am attempting to delete a record from the database using the function delete.

I have the ID of the record, but when it runs, I get the following error:


ERROR: No array in actID=EDL006


The delete function is simply: delete($table, $where)

Which is what I am passing to it, but I get the error above.

Any suggestions? Am I am passing the wrong information?

Thanks for any assistance.

Rob


RE: DB Delete - rob@selectech.us - 02-17-2019

So again I figured out the problem, just realized that I wasn't passing the information correctly.

Also, I decided to use the $db->query function instead and pass the information I needed as such:

$db-query("DELETE FROM table1 WHERE id=?",array($UserId));

This worked perfectly! Smile

Cheers