Web Design Forums

gray · 21-09-2006, 10:29

evening gents, im trying to get my sql to pull out a random row, but grab rows with a higher priority more often than lower priorty - but still show lower priority rows occasionally...

i was thinking this, but failed.

PHP Code:


		
			
// priority_level is a column with values 1-5, 5 being high priority

$getFile = mysql_query("SELECT * FROM $table 

ORDER BY RAND(),priority_level DESC LIMIT 1");

can it be done?

gray · 21-09-2006, 10:40

ah good one

gray · 21-09-2006, 10:42

i'll make an array of 1, 2, 2, 3, 3, 3, 4, 4, 4, 4, 5, 5, 5, 5, 5 and select one at random

gray · 21-09-2006, 10:43

haha same idea

now some brain bod come along and say

"just use randomWithPriority() => foo ?: zx$" tbh

gray · 21-09-2006, 11:12

this will fail if there are no priority 4 rows for example.. going to have to check for existance of each level before adding that level to the array..

gray · 21-09-2006, 12:53

aye done it

21-09-2006, 10:29	#1 (permalink)
gray i still want paying Join Date: Oct 2003 Location: newcastle, uk Posts: 4,713	mysql selecting random rows, but use priority levels evening gents, im trying to get my sql to pull out a random row, but grab rows with a higher priority more often than lower priorty - but still show lower priority rows occasionally... i was thinking this, but failed. PHP Code: `// priority_level is a column with values 1-5, 5 being high priority $getFile = mysql_query("SELECT * FROM $table ORDER BY RAND(),priority_level DESC LIMIT 1");` can it be done?

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

21-09-2006, 10:40	#2 (permalink)
gray i still want paying Join Date: Oct 2003 Location: newcastle, uk Posts: 4,713	ah good one

21-09-2006, 10:42	#3 (permalink)
gray i still want paying Join Date: Oct 2003 Location: newcastle, uk Posts: 4,713	i'll make an array of 1, 2, 2, 3, 3, 3, 4, 4, 4, 4, 5, 5, 5, 5, 5 and select one at random

21-09-2006, 10:43	#4 (permalink)
gray i still want paying Join Date: Oct 2003 Location: newcastle, uk Posts: 4,713	haha same idea now some brain bod come along and say "just use randomWithPriority() => foo ?: zx$" tbh

21-09-2006, 11:12	#5 (permalink)
gray i still want paying Join Date: Oct 2003 Location: newcastle, uk Posts: 4,713	this will fail if there are no priority 4 rows for example.. going to have to check for existance of each level before adding that level to the array..

21-09-2006, 12:53	#6 (permalink)
gray i still want paying Join Date: Oct 2003 Location: newcastle, uk Posts: 4,713	aye done it

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)