PEAK XOOPS - Order in my index page 
Order in my index page
- You cannot open a new topic into this forum
- Guests cannot post into this forum
Previous post
-
Next post
|
Parent
-
Children.1
|
Posted on 2006/6/17 18:25
slyss79
Posts: 143
Posts: 143
hi...
in my index page
...site/modules/myalbum0/index.php
i have all my thumb with parties...
now: how i can order by date or by id the thumbs (gallery)?
thanks a lot...
in my index page
...site/modules/myalbum0/index.php
i have all my thumb with parties...
now: how i can order by date or by id the thumbs (gallery)?
thanks a lot...
Votes:0
Average:0.00
GIJOE
Posts: 4110
Posts: 4110
In index.php, date DESC is the default and hard-coded order.
If you want to modify it, edit line 48 of index.php
If you want to modify it, edit line 48 of index.php
Votes:1
Average:0.00
slyss79
Posts: 143
Posts: 143
i have try to modify it but the result is the same...
where i mistake ?
thanks
where i mistake ?
thanks
Votes:0
Average:0.00
GIJOE
Posts: 4110
Posts: 4110
eg) by id DESC
It is natural if each result looks identical.
id DESC and date DESC will return almost the same result.
$prs = $xoopsDB->query( "SELECT l.lid, l.cid, l.title, l.ext, l.res_x, l.res_y, l.status, l.date, l.hits, l.rating, l.votes, l.comments, l.submitter, t.description,c.title AS cat_title FROM $table_photos l LEFT JOIN $table_text t ON l.lid=t.lid LEFT JOIN $table_cat c ON l.cid=c.cid WHERE l.status>0 ORDER BY l.lid DESC" , $num , $pos ) ;
It is natural if each result looks identical.
id DESC and date DESC will return almost the same result.
Votes:0
Average:0.00
slyss79
Posts: 143
Posts: 143
nothing 
i have try also with l.lid DESC but nothing... i don't know why...
i have try also with l.lid DESC but nothing... i don't know why...
Votes:16
Average:5.00
Previous post
-
Next post
|
Parent
-
No child
|
Posted on 2006/6/20 6:29
GIJOE
Posts: 4110
Posts: 4110
Check again.
It is natural if each result looks identical.
id DESC and date DESC will return almost the same result.
Try id ASC once.
Or check the file you edit is correct one.
It is natural if each result looks identical.
id DESC and date DESC will return almost the same result.
Try id ASC once.
Or check the file you edit is correct one.
Votes:0
Average:0.00
Login