MySQL multiple group by using -


now using query : 

select * messages receiverid='$uid' or senderid='$uid' group recei verid,senderid order datex desc

but results

id  receiverid  senderid  1      2            1  2      1            2

but want showing 1 result syntax. example:

id  receiverid  senderid  1      2            1

or 

id  receiverid  senderid  2      1            2

you want use least() , greatest():

select * messages receiverid='$uid' or senderid='$uid' group least(receiverid, senderid), greatest(receiverid, senderid) order datex desc;

however, should list columns explicitly in select. using mysql extension have columns in select not in group by. bad idea unless understand doing.


Comments

Post a Comment

Popular posts from this blog

javascript - Jquery show_hide, what to add in order to make the page scroll to the bottom of the hidden field once button is clicked -

i have button on website when clicked, reveals map. button can seen when page first loads up, when clicked, section holding map slides open , goes out of screen since page loads @ top (normal). want page scroll down bottom of div select when button pushed, if map out of screen. if page scrolled down, , clicks show map button, don't want page jump bottom of map. i tried figure out myself, no luck. seasoned jquery coders able give me guidance? many thanks! map = mapdiv.gmap3("get"); infobox = new infobox({ pixeloffset: new google.maps.size(-220, -310), closeboxurl: '', enableeventpropagation: true }); mapdiv.delegate('.infobox .close','click',function () { infobox.close(); }); jquery(".slidingdiv").hide(); jquery(".show_hide").show(); jquery('.show_hide').click(function(){ lastcenter=map.getcenter(); jquery(".slidingdiv...
Read more

python - How to get a widget position inside it's layout in Kivy? -

i have gridlayout , added image widgets on after adding of images want draw rectangle in each image using canvas couldn't because don't know exact image widgets positions on gridlayout. code: http://paste.ofcode.org/3bdp9yhjrcrzmsztbu9hqp4 http://paste.ofcode.org/3az3gx4fxzr9dlhe2ami97c in last line of python code : rectangle(pos = (child.x - 2.4, child.y + 467), size = (70, 70)) how draw rectangle in child(my method not good^), also why gridlayout not coming in center after setting it's pos_hint = {"center_x" : .5}? if understand question right, try use such methods to_local() , to_parent() , to_widget() , to_window() . try substract position of gridlayout widgets' positions.
Read more

Error while updating a record in APEX screen -

while updating record using mru failing below error. 1 error has occurred current version of data in database has changed since user initiated update process. current row version identifier = "c5f3645b026aa5646c00dc7b631c4d19" application row version identifier = "6a9323b62f641015fa4601421dfb03de" (row 1) this strange because not see change in data @ backend. any highly appreciated. thanks. aj
Read more