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

Post, not working, please help
The error is:
Method Not Allowed
The requested method POST is not allowed for the URL /student

What's wrong with my code
sobbing for many days, still don't know why please Help. Why my page isn't posted correctly. In a

Get last modified date of web page
Hai All,

In php how can i get last modified date of a give web page . I have tried to g

Xacute search within SQL results
I have a query that is pulling data, and I want to return a specific value from the results of that

Firewall / visited websites logger
Hi. I have a firewall implementation and I want to log all the websites visited on the machine. S

EXplanation help
Hey all,

I am still fairly new to PHP programming and I am trying to put together a page wher

How to calculate days from variable date?
This will be easy for one of you gurus. I want to fetch the date from a variable date, for example:<

Bandwidth monitoring?
Hi guys,

I need a little information I have written a php app and I occurred to that I need

help with calculations on a flat text file
hello,
I have this code below that is attached to a flat file like this:
Email:LastName:FirstN

IS this code correct
The reason i ask is everything underneath it appears to be alink as well, tis blimmin annoying