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
Did you know?Explore Trending and Topic pages for more stories like this.
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
No comments posted yet
Your Answer:
Login to answer
175 
43 
Other forums
extract a file from zip file
hi,
i know how to unzip a zip file in php, but is there a way to just extract a certain file only
tag inside php...
hi
Code: <?php
echo "<td width="$columnWidth%" align=&Generate multilayered array from string.
ok so i have a string that looks like this:
Code: blog:edit_all,delete_all|users:edit_all,delete_ How to set pass login name from htaccess to php
When the user logs into my members page via htaccess, I'd like to retain the username so that I can timezone change with date()
so i put all my times for posts in my made from scratch forum(not phpbb3 or sm)
in my mysql db u How can use this array as a key?
Say I have this array for example:
print_r($array);
Prints:
Code: [Select]Array ASP.NET 2.0 - Enter Key - Default Submit Button
Hi,One of the most annoying things in developing web pages is handling the "Enter key" for form subm Text Not Displaying Correctly With PHP:GD
I recently moved servers and since then I have noticed that one line of text is showing weirdly.
How to make a mail Form secure?
I want to create an email Form on my web site. How can I make the Form secure so the submitted info path to include folder
Hi everyone,
When I'm testing locally, I have to add the name of the site folder as part of t
| 
