Welcome Guest, Not a member yet? Register   Sign In
Double select in builder
#3

thanks, ive managed to fix it as follows:
```
$db = \Config\Database::connect();
$builder = $db->table('main_table');

$builder->selects[] = "*";
$builder->selects[] = "main_table.id as id";

$builder->select($builder->selects);
$builder->join("second_table","main_table.id = second_table.base_id","INNER");
$query = $builder->get();
```

Seems the select needed to have an array.
Reply


Messages In This Thread
Double select in builder - by RuudTableaux - 03-06-2020, 07:30 AM
RE: Double select in builder - by donpwinston - 03-06-2020, 11:06 AM
RE: Double select in builder - by RuudTableaux - 03-13-2020, 02:07 AM



Theme © iAndrew 2016 - Forum software by © MyBB