Welcome Guest, Not a member yet? Register   Sign In
CodeIgniter Forums Using CodeIgniter General Help sql return all rows
sql return all rows
  • Offline mwhitney
    Posting Freak
  • *****
  • Posts: 1,101
    Threads: 4
    Joined: Nov 2014
    Reputation: 95
#5
09-10-2015, 07:12 AM

Let's start at the beginning, then: what should the SQL look like when it goes through to the database? I'm assuming you have some other tool for querying the database (for example, MySQL Workbench) and can craft the query there to get the results you're looking for. Given that, we can apply the query grouping syntax I linked to previously to get Query Builder to generate the correct output.
Bonfire
Practical CodeIgniter 3
CodeIgniter Testing Guide
Reply


Messages In This Thread
sql return all rows - by rchiu5hk - 09-09-2015, 09:21 AM
RE: sql return all rows - by mwhitney - 09-09-2015, 09:31 AM
RE: sql return all rows - by Wouter60 - 09-09-2015, 11:45 AM
RE: sql return all rows - by rchiu5hk - 09-09-2015, 03:58 PM
RE: sql return all rows - by mwhitney - 09-10-2015, 07:12 AM



Theme © iAndrew 2016 - Forum software by © MyBB