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

re calling a function without including file
Hi,
i am new to programming in php, i was just checking the wordpress code and found out in the w

styling a RadioButtonList
HiI need to have a radio button and close to it, its lable, then a space then another set of those.

Multi language - seo links
Im trying to figure out the best method to have a multi language website that will function with seo

Multiple Dropdown Selections
I have a form that let's a user insert a page with the ability to select categories. I want them to

Find current logon time
Hi,
in my sql script i want to query and find out the logon time of the current session.
<

Combining Two Queries
I have two scripts that each work fine by themselves. One is a search script with a variable that de

Table colours fail when extra row added
Hey Gurus,

I got a weird problem with formating the colour of a table made in php. Everything

ob_ dynamic content
i was wondering about the potential to use ob to create a <div then remove it when the page

how to insert value
I am having file bookissueadd.php..... in which i am having tag

<td height="21&q

PHP mail() returns true but doesn't work
First off I apologize if this is a newbie question, and I generally don't like asking questions that