Menu
Community /Pin to ProfileBookmark
@NogDogNov 16.2005 — #I'm guessing that [b][font=courier]$this->Order = "cat_featured desc, started desc";[/font][/b] gets used in an ORDER BY clause of a SQL query. As there is no option to ORDER BY random, best suggestion I could come up with is to radomly chose to sort it ascending, descending, or unsorted (in database order). Replace the above line with this code, and see what happens (no guarantees it will work, not knowing for sure what the rest of the code does):
Sorting a List
I’m running a third party php script and am having trouble setting the order for a list. The list (see the attached image) is divided into 2, “cat_featured” and “started” at present they are both set to the same order, with the most recent appearing at the top of the list.
What I am trying to do is sort it so that the cat_featured items are sorted randomly and the “started” items are left the same (sorted by most recent first). Here is all the necessary code I think:
[code=php]function SetOrder($SorterName, $SorterDirection)
{
$this->Order = “cat_featured desc, started desc”;
$this->Order = CCGetOrder($this->Order, $SorterName, $SorterDirection,
array(“Sorter_title” => array(“cat_featured desc, title”, “”),
“Sorter_started” => array(“cat_featured desc, started”, “”),
“Sorter_asking_price” => array(“cat_featured desc, asking_price”, “”),
“Sorter_location” => array(“cat_featured desc, state_province ” . $SorterDirection . “, city_town”, “”)));
}
Pretty new to php so any suggestions are welcome, thanks
[upl-file uuid=3ea5db01-1e38-4844-b7a3-8815fc284676 size=66kB]rotate.jpg
Sign in
to post a comment1 Comments(s) ↴
0
@NogDogNov 16.2005 — #I'm guessing that [b][font=courier]$this->Order = "cat_featured desc, started desc";[/font][/b] gets used in an ORDER BY clause of a SQL query. As there is no option to ORDER BY random, best suggestion I could come up with is to radomly chose to sort it ascending, descending, or unsorted (in database order). Replace the above line with this code, and see what happens (no guarantees it will work, not knowing for sure what the rest of the code does):[code=php]
$nbr = rand(1,3);
switch($nbr)
{
case 1:
$this->Order = "cat_featured desc, started desc";
break;
case 2:
$this->Order = "cat_featured asc, started desc";
break;
default:
$this->Order = "started desc";
}
[/code]