array from query then random gen. of array

[cherryst152]

I'm trying to make an array from a query and then randomly select 10 values from the array, but the error i keep getting is that it's not reading as an array. Thanks in advance for anyone who can help.

$query = "SELECT Id FROM January WHERE Username='0' AND Day='1'";
$result = mysql_query($query);

while($row=mysql_fetch_assoc($result))
{
echo $row['Id'];
echo "<br>";
}

for($i=1; $i<=10; $i++){
$random = array_rand($row);
echo $random;
}
?>

[Markus]

I'm trying to make an array from a query and then randomly select 10 values from the array, but the error i keep getting is that it's not reading as an array. Thanks in advance for anyone who can help.

$query = "SELECT Id FROM January WHERE Username='0' AND Day='1'";
$result = mysql_query($query);

while($row=mysql_fetch_assoc($result))
{
echo $row['Id'];
echo "<br>";
}

for($i=1; $i<=10; $i++){
$random = array_rand($row);
echo $random;
}
?>

Try:
[php]
<?php
$_query = mysql_query("SELECT * FROM `Members_Info`");

function rand_from_array($_data)
{
for($_i = 0; $_i < 10; ++$_i)
{
echo array_rand($_data);
}
}

while($_row=mysql_fetch_assoc($_query))
{
echo rand_from_array($_row) . "<Br />";
}
?>
[/php]
You'll have to adapt it (slight modifications)
Also untested!
Let me know if there's a problem!

[cherryst152]

When i tried that, all i get was 'Id' listed way too many times.

[Markus]

When i tried that, all i get was 'Id' listed way too many times.

Show me what you got.





...
:|

[cherryst152]

$_query = mysql_query("SELECT Ad_Id FROM January_Ad1 WHERE Username='0' AND Day='1'");

function rand_from_array($_data)
{
for($_i = 0; $_i < 10; ++$_i)
{
echo array_rand($_data);
}
}

while($_row=mysql_fetch_assoc($_query))
{
echo rand_from_array($_row) . "<Br />";
}

[TheServant]

Look at shuffle() and array_rand() functions here.

Sorry this didn't post, so only posted it a few replies later so it's out of date!

[TheServant]

Actually, look at that link. array_rand() takes another input which lets you choose how many elements you want to return, so that might be what you're after!

[cherryst152]

that definitely helped and put things in a more logical perspective. thanks. however, i remain with the same original problem. i feel as though this problem is because the array which i am trying to carry over from the while loop is not reading in the for loop. any further suggestions?

[cherryst152]

works properly now. finished code below.

$query = "SELECT Id FROM January WHERE Username='0' AND Day='1'";
$result = mysql_query($query);

$data = array();
while($row=mysql_fetch_assoc($result))
{
$data[] = $row['Id']; // store in array
}

$random = array_rand($data, 10); // get 10 random keys

foreach ($random as $key)
{
echo $data[$key];
echo "<br>";
}

[TheServant]

that definitely helped and put things in a more logical perspective. thanks. however, i remain with the same original problem. i feel as though this problem is because the array which i am trying to carry over from the while loop is not reading in the for loop. any further suggestions?

Why don't you use [PHP]array_rand($data, 10)[/PHP] instead of your for loop? Don't they do the same thing?


** ALSO: Start using appropriate code tags around any posted code!

[TheServant]

lol, I'm a bit slow today. Glad we could help ;)