Welcome Guest, Not a member yet? Register   Sign In
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...
8,979 Views
7 Replies
05-09-2017, 08:35 PM
corey
    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(...
8,979 Views
7 Replies
05-05-2017, 10:20 PM
corey
    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...
8,979 Views
7 Replies
05-05-2017, 10:06 PM
corey
    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...
8,979 Views
7 Replies
05-05-2017, 03:15 AM
corey
    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...
8,979 Views
7 Replies
05-04-2017, 11:36 PM
corey

Theme © iAndrew 2016 - Forum software by © MyBB