Daily randomise listing function

[CHRD]

Would anybody like to see the standard listings randomise, so that everybody get the same exposure, but also randomise the featured listing above the standard listings,
or if a advertiser changes/edits there advert the system sees it as a new listing and moves there advert up, but I think this could couse a lot more bandwidth to be used

Maybe this can be inserted into V4

Thanks
Glenn

[gregbatch]

Change ASC or DESC in ORDER BY to RANDOM

[CHRD]

Sorry Im looking in administration/searchsettings.php and I dont have random setting in the sort listing options.

[Chaslie]

Change ASC or DESC in ORDER BY to RANDOM

I tried that in searchresults.php but throws up SQL errors.

Changed this:

$sSQL .= " ORDER BY ".MAIN_PRODUCT_SORT." ".MAIN_PRODUCT_SORT_OPTION.", p.dateadded DESC";

To this:

$sSQL .= " ORDER BY ".MAIN_PRODUCT_SORT." ".MAIN_PRODUCT_SORT_OPTION.", p.dateadded RANDOM";

.... but that doesn't provide the solution.

[gregbatch]

Sorry Im looking in administration/searchsettings.php and I dont have random setting in the sort listing options.

Sorry, Glenn. That was in the SQL query, but Chaslie says there are issues with that one.

UPDATE:
My error... should be rand()

[Chaslie]

$sSQL .= " ORDER BY ".MAIN_PRODUCT_SORT." ".MAIN_PRODUCT_SORT_OPTION.", p.dateadded rand()";

Is this code correct? In searchlistings.php around line 139. SQL error again. All I did was replace 'DESC' with 'rand()'.

[Chaslie]

Greg. Have you exhausted your ideas about this one yet?

[gregbatch]

Im not sure what is taking place in the "MAIN_PRODUCT_SORT" and "MAIN_PRODUCT_SORT_OPTION". I assume it would be the "field to sort on" and the "order" options from within the admin panel, then the second level sort within that by default is date added. I think you would need to kill one of the order options. I'm not so sure rand() plays well with others. Since you are basically throwing the main sort options out the window anyway, I would try kiling that.

$sSQL .= " ORDER BY ".MAIN_PRODUCT_SORT." ".MAIN_PRODUCT_SORT_OPTION.", p.dateadded DESC";

Becomes:

$sSQL .= " ORDER BY p.dateadded rand()";

[Chaslie]

Im not sure what is taking place in the "MAIN_PRODUCT_SORT" and "MAIN_PRODUCT_SORT_OPTION". I assume it would be the "field to sort on" and the "order" options from within the admin panel, then the second level sort within that by default is date added.

If you take out just "MAIN_PRODUCT_SORT" and "MAIN_PRODUCT_SORT_OPTION", featured adds immediately lose their priority listing and the sort is DESC by date added.

If you then replace DESC with rand(), you get SQL errors.

Since you are basically throwing the main sort options out the window anyway, I would try kiling that.

It seams that by substituting DESC with 'rand()' (in any combination) produces errors.

This certainly is a feature I would like to add to our own site so the topics is still open for solving.

[gregbatch]

Yep. Don't know, as I use rand() on another site to pull featured ads randomly. I'm sure it's clashing with other code somewhere. Unfortunatley, I don't have developer to look deeper.

UPDATE:
OK. Had to look at my own code (ahem ) to remember what I did. Rand() must be used alone, i.e. ORDER BY rand() . So, the result would be TOTALLY random.