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

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

need help modifying script
Hi guys,

I'm fairly new to php and am having a bit of trouble modifying a script.

This

Multi dimensional arrays
If I put in this code:

1
2
3
4
5
6
7
8
9
10
11
12
13<

Creating XML with php
I need to creat an XML with php and have successfully produced a valid output.
The problem I hav

Is there a quick way to do this?
Hi all,

I need to create a mysql table from php that goes a little something like this

FPDF Help
I've been playing with the FPDF module. I was building a form and rolling right along and then sudde

Checking if field is empty AND using !is_numeric
Hi lads,

Need to be able to display an error message (using isset?) that says "Cant lea

Setting/Modify Headers using mail() function
I have a question about setting email headers when using mail() in a php script.

When I send

Calander Basic Spript help
hi, just starting out with PHP and have the following script:

<?php
//This gets t

form variables from database help.
Hi all,

I would like to have a form that gives you options based on the results of an mysql q