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



UserSpice
update not using id - Printable Version

+- UserSpice (https://userspice.com/forums)
+-- Forum: Support Center (https://userspice.com/forums/forumdisplay.php?fid=23)
+--- Forum: UserSpice 4.3 and Below (https://userspice.com/forums/forumdisplay.php?fid=26)
+--- Thread: update not using id (/showthread.php?tid=503)



update not using id - marcus - 03-21-2017

Hi all,
I have a separate database that I want to update using the DB Class.
As I only see this possibility: $db->update('camps',5,$fields); using id I'm a bit stuck. I need to update databases using another fieldname (g_ID). How would I do that?

Regards,
Marc
Haarlem
The Netherlands


update not using id - dan - 03-21-2017

You can just write a raw query like

$db->query("UPDATE...

Just follow normal query syntax for binding variables.