PEAK XOOPS - Re: Randomise display of thumbnails in myalbum index? in englishin japanese

Top > XOOPS Modules >myAlbum-P >Randomise display of thumbnails in myalbum index?

Re: Randomise display of thumbnails in myalbum index?

List posts in the topic

question Re: Randomise display of thumbnails in myalbum index?

msg# 1.1.1.1.1
depth:
4
Previous post - Next post | Parent - Children.1 | Posted on 2006/9/1 7:44
slyss79  三等軍曹   Posts: 143
yes, index.php is the right....

// Assign Latest Photos
// riga qui sotto mod by sly: era ORDER BY date DESC
$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 rand()" , $num , $pos ) ;

but i have made any test with:

ORDER BY title ASC or DESC or date ASC or DESC etc... and result don't change!!!! so it's mean this is not my lines!!!

i don't remember but maybe i have modified another file with the sort order... do you know what should be ?

thanks a lot...
Votes:3 Average:3.33

Posts tree

  Advanced search

Login
Username or e-mail:

Password:

Remember Me

Lost Password?

Register now!