Antonio47 started a discusssion in the thread
How to change to random
Hi ,
HAPPY NEW YEAR TO ALL.
At last I managed to find a web link panel in which is displacing the last 5 submissions.
and here is the table code:
Quote
$result = dbquery("SELECT weblink_id, weblink_name, weblink_cat, weblink_description, weblink_count FROM ".DB_WEBLINKS." ORDER BY weblink_datestamp DESC LIMIT 0,5".....
I would like to display the lat RANDOM 5 site but when I changed the above code with:
Quote$result = dbquery("SELECT weblink_id, weblink_name, weblink_cat, weblink_description, weblink_count FROM ".DB_WEBLINKS." ORDER BY weblink_datestamp RAND() LIMIT 0,5......
I do get the error, aldo I changed the RAND() LIMIT 0,5..... bit into
RAND LIMIT 0,5..... but still no go.
Any help is much appreciated
2 Jan 2014 at 10:53 AM