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
/showthread.php 28 require_once





× This forum is read only. As of July 23, 2019, the UserSpice forums have been closed. To receive support, please join our Discord by clicking here. Thank you!

  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
db where var1=x AND var2=y AND var3=q
#1
I can't figure out how to solve a right query, what do I wrong?

sql query: 
DELETE FROM `tbl_resource` WHERE (`ID_resource`=".$var1."  AND `ID_veld`=".$var2." AND `type_resource`='P') LIMIT 1;

first try:
$db->delete("tbl_resource",
[ "AND", 
["ID_resource","=",$db->result()[0]->ID_papo], 
["ID_veld", "=", $lesblokId ],
["type_resource", "=", "P"]
]);

second try:
$db->delete("tbl_resource",
[ "AND", 
[ "AND",[
["ID_resource","=",$db->result()[0]->ID_papo], 
["ID_veld", "=", $lesblokId ]
], 
["type_resource", "=", "P"]
]
]);
  Reply


Messages In This Thread
db where var1=x AND var2=y AND var3=q - by Ruud - 01-05-2019, 06:10 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)