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

Web Host List
Here is a list of web hosts that offer PHP and MySQL. It is no where near a full list, but it is mos

Search function
I am looking for some guidance from the experts.

I am trying to create a search function. It

GET * FROM _____ Except?
I have a site that is for stock photography.

This section of the code calls images to display

how to load a Sys file with system load and call images?
normally you need register the module as a service with CreateService, and start the service

sql error
I have been looking at this code for 20mins and can't work out what I am doing wrong. There is somet

Printer configuration
Hi All,
Suppose one of the user deleted the printer settings unfortunatly ,then what is the pro

CODE NOT WORKING
Code: [Select]<?php
//include shared codes

include '../lib/common.php';
include

extending tidy
I have problem with type-hinting and extending tidy. This code creates error:
Code: class cMyTidy

Pagination
Hi All,

I think I'm finally getting somewhere with pagination!

I can now submit a quer

Need help making login verification cleaner...
I use the below to verify user login. I first check the cookie for the id, ip and a unique id. If it