Search found 4 matches

by antoniolite
Tue Apr 10, 2007 11:53 am
Forum: Plugins
Topic: Help sorting Recent Entries descending order
Replies: 15
Views: 9073

Las query doesn't work either.
Don't worry, maybe i will remove that plugin from the blog...

Anyway, thanks a lot for your help, Garvin.
by antoniolite
Tue Apr 10, 2007 11:29 am
Forum: Plugins
Topic: Help sorting Recent Entries descending order
Replies: 15
Views: 9073

Very strange...

if i execute the query in phpmyadmin, i get the same result... with ASC and DESC...

I changed the query to:

SELECT * FROM s9y_entries WHERE isdraft = 'false' ORDER BY id DESC LIMIT 10;
and looks like now i get the recent entries correctly. Is not a good solution, but it works ...
by antoniolite
Sat Apr 07, 2007 12:44 pm
Forum: Plugins
Topic: Help sorting Recent Entries descending order
Replies: 15
Views: 9073

Hello,

i added a "echo $entries_query;" after construct the select query, and this is what i got:

SELECT DISTINCT id, title, timestamp FROM s9y_entries WHERE isdraft = 'false' AND timestamp <= 1175942543 ORDER BY timestamp DESC LIMIT 10

Looks right, but i continue getting recent entries from ...
by antoniolite
Sat Mar 10, 2007 2:54 pm
Forum: Plugins
Topic: Help sorting Recent Entries descending order
Replies: 15
Views: 9073

Hi,

I have the same problem in www.casarusia.com, i tried everthing but the recent entries still shows from oldest to newer.

maybe it is a x-file?