Alain Sauve
Alain Sauve
Here you can write your where like this `where('user_id IS NULL', NULL, FALSE,FALSE,FALSE,TRUE)` Result for a select query: `SELECT * FROM `table` WHERE user_id IS NULL` It will give you...
Then you should validate $some_value to make sure it is not NULL. Rather than to hope the framework/library will do it for you.
Hi, Your relations in the tests and aplicaciones models seam to be wrong. Base on the tables above these relation should be has_many not has_many_pivot.
Hi, You have 2 ways to do this: 1st option: ``` PHP $this->db->distinct(); $this->group_by('user_id')->where('publish
Hi @dandruff123 , The only way I can think of to get this to work is to use an ordered subquery as the table. You can do it using CI...
@dandruff123 You could also try this library [https://github.com/NTICompass/CodeIgniter-Subqueries](https://github.com/NTICompass/CodeIgniter-Subqueries) It should work with CI 3.X out of the box.
You need to make the where clause a custom string like this: ``` php $result = $this->where('fieldName IS NULL',NULL,NULL,FALSE,FALSE,TRUE)->get_all(); ```
Hi, Just add a where clause to the paginate.
```php $this->model->where('field_name',$value_array,NULL,NULL,TRUE)->get_all(); ```
I agree with @avenirer the after_get hook should get the whole result. I also agree with @s0x, I have yet found what the $last parameter is used for, but I...