array_rand

[boredidiot]

I cannot get this code to work. It keeps coming back Warning: array_rand() [function.array-rand]: Second argument has to be between 1 and the number of elements in the array.

 

$numb is coming back '1','2','3'

 

 

 

$q = "SELECT * FROM `filler` WHERE `t`='l'";

$r = mysql_query($q) or die(mysql_error());

while ($num = mysql_fetch_assoc($r)) {

$numb .= "'".$num['id']."',";

}

$numb = substr_replace($numb, "", -1);

 

//pick only 2 and no duplicates

$numbers=array($numb);

 

//Get 2 unique random keys from $numbers array.

$rand_keys = array_rand($numbers, 2);

[Mark Baker]

What do you believe this line of code is actually doing???

//pick only 2 and no duplicates
$numbers=array($numb);

Your array comprises a single element, a string value that looks something like '1,2,3'

simply saying $numbers=array($numb) doesn't automatically convert the string into an array of values split on the ,

 

q = "SELECT * FROM `filler` WHERE `t`='l'";
$r = mysql_query($q) or die(mysql_error());
$numbers = array();
while ($num = mysql_fetch_assoc($r)) {
   $numbers[] = $num['id']; 
}

//Get 2 unique random keys from $numbers array.
$rand_keys = array_rand($numbers, 2);