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
Bug in db query->count?
#7
How can I do multiple conditions like this using AND? Looking at the docs here (https://userspice.com/documentation-db-class-2/) I tried using db-query once again...
$poolQ = $db->query("SELECT * FROM pools WHERE id = ?",$poolID);
$poolO = $poolQ->results();
print_r($poolO);

and once again what I got was results from the
Code:
users
table even though my query specified the
Code:
pools
table. I'm not sure how I should setup an AND with db->get. Also, you said passing my input as an array rather than how I did in the example in this post will clean the variable from injection?

Thanks
  Reply


Messages In This Thread
Bug in db query->count? - by Trioxin - 12-10-2016, 03:31 PM
Bug in db query->count? - by Trioxin - 12-10-2016, 03:56 PM
Bug in db query->count? - by Trioxin - 12-10-2016, 04:02 PM
Bug in db query->count? - by dan - 12-10-2016, 04:26 PM
Bug in db query->count? - by Trioxin - 12-10-2016, 04:40 PM
Bug in db query->count? - by dan - 12-10-2016, 05:00 PM
Bug in db query->count? - by Trioxin - 12-12-2016, 12:36 AM
Bug in db query->count? - by Trioxin - 12-12-2016, 03:20 AM
Bug in db query->count? - by mudmin - 12-12-2016, 04:18 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)