CodeIgniter Forums - Search Results

Search Results

Thread: database error when using DISTINCT and ORDER BY
Post: RE: database error when using DISTINCT and ORDER B...

guyz seems like you dont understand problem is with mysql version 5.7 needs change in code or change mysql 5.7 mode by default in 5.7 one mode is set to ONLY_FULL_GROUP_BY either disable it or go bac...

Thread: database error when using DISTINCT and ORDER BY
Post: RE: database error when using DISTINCT and ORDER B...

my problem solved by using Code: -- SELECT ANY_VALUE(message_user_name), ANY_VALUE(message_user_id) FROM cms_inbox GROUP BY message_user_id ORDER BY ANY_VALUE(message_time) -- adding ANY_VALUE(...

Thread: database error when using DISTINCT and ORDER BY
Post: RE: database error when using DISTINCT and ORDER B...

ok i need to repeat my error in details i want to get only one user_id from my inbox db by using group by or distinct but both not working here is my sql code for group by Code: -- SELEC...

Thread: database error when using DISTINCT and ORDER BY
Post: RE: database error when using DISTINCT and ORDER B...

This select thing is working if i dont use order by but it shows error when order by is used with distinct or group by this error only shows when mysql is 5.7 they changed some stuff in it and i th...

Thread: database error when using DISTINCT and ORDER BY
Post: database error when using DISTINCT and ORDER BY

hello everyone i am new to code igniter and got stuck in one query i want to get distinct id from database order it by id my code is PHP Code: -- $this->db->select('message_user_id, messag...