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
Query results
#1
Hi,

Just a quick query about retrieving data from the DB.

Normally I would use results() to get the data I want to display. But take the scenario where I want a specific value and do:
$somethingQ = $db->query("SELECT * FROM db WHERE category = 'this'");
$somethingR = $somethingQ->results();

If I try: $somethingR->id, it doesn't give me the data, but if I use first() above it does.

Just wondering how I would structure something to have multiple input text boxes, that return with a value stored in the DB but if changed/updated would be updated to their new value; each item's input would be item[].

Hope that makes sense.

  Reply


Messages In This Thread
Query results - by MHALL1 - 11-23-2017, 12:20 PM
Query results - by mudmin - 11-23-2017, 01:33 PM
Query results - by MHALL1 - 11-23-2017, 06:47 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)