Builder query question From table AS table01, table AS table02 |
I would like to make a Builder Query base on
PHP Code: $tQRY = "SELECT node.* Result of this query : Code: SELECT node.* When is transform it to a full builder PHP Code: $builder = $this->db->table($this->dbTable); with following result Code: SELECT node.* I get the first da_mainmenu to much. So there is problem with PHP Code: $builder->from($this->dbTable .' AS node'); How can i transform the query to builder? Also I'm not sure how to do the 'WHERE X BETWEEN y AND Z' ** solved ** Class is included
Just code the where clause directly, like so:
Code: $builder->where('node.LFT BETWEEN parent.LFT AND parent.RGT'); There's no variable interpolation or substitution so it should be fine.
(04-12-2020, 01:21 PM)maxxd Wrote: Just code the where clause directly, like so: Thanks Also problems solved with the table selection PHP Code: $this->db = db_connect($this->dbActiveGroup);
|
Welcome Guest, Not a member yet? Register Sign In |