problem with GROUP BY and ORDER BY

Posted on 16th Feb 2014 07:03 pm by admin

i usually use this query to display the last 10 entries from a sql table:

Code: $query = "SELECT search_time, search_keywords FROM phpbb_popsearch ORDER BY search_time DESC limit 35";
as you can see it will order the results by "search_time" so the latest entries are listed first

normally the result would be something like this:
Quotenew entry
duplicate
another entry
bla bla
348237
543543
duplicate


but now i just want to include a "GROUP BY" in this sql request
Code: $query = "SELECT search_time, search_keywords FROM phpbb_popsearch ORDER BY search_time DESC limit 35";
but with the GROUP BY my sql query isn't ordered correctly anymore.

the result would be something like this:
QuoteQuotenew entry
another entry
bla bla
348237
543543
duplicate


notice the "duplicate" entry was grouped together, but it's not in the second first position anymore ???

i was expecting a result like this:
Quotenew entry
duplicate
another entry
bla bla
348237
543543

Since entry called "duplicate" is the second last added entry....

i hope you understand what i mean

Your Answer:

Login to answer

Other forums

UL and LI Add Form
The idea I want here is when the user click on a character name from the drop down select bar at the

ALV sum various columns problem
Hi all,
I'm doing a report on ABAP for a timesheet of the current month. The output i want is s

Help on Order Entry Form/System Where is best to begin.
I have a dilema and a very short amount of time at this point and I'm looking for some help on decid

type check while uploading
Hi Everyone,

How can I check the exact type of a file while uploading on my site?

Here

PHP Blog help
Need help with posting comments in a word press blog? I have a comments page where the comments are

Save cookie to DB
I'm working on a pixel tracking script for an incentive website and I need to use an ASP script to s

help with this code please?
Hello,

I am trying to build a remote upload script for my image hosting site.

I am usi

Using real time in php
I'm very average at PHP and im looking to introduce time to something on my site.
Its a sports si

How to form a xml form table with a single sql statement..?
Hi everyone,
I don't know if this is going to be a duplicate thread but i couldn't

question about n
I was looking at some of the things you could do with php and one of the things I have tried is n.<