Urgent Help!!Random number from database

[k_o_b]

I have database about test that contain 4 fields, Group,ID,Question and Answer. Group can be only number 1 to 10. But ID can be any number. For each Group can not have same ID.

Example:
Group ID Question Answer
1 1 aaaa True
1 2 bbbb False
1 3 cccc True
2 1 dddd True
2 2 eeee True
3 1 ffff False
4 1 gggg False
4 2 hhhh True

I want to random 1 Question from each Group.What should I do and what is the code? Plase help me. Thank you.

[khaine]

I think the best way would be to retrive a count of the number of questions in one group and then generate a random number to select one.

Something like this in mysql.

<?

$query="select ID from database where group like '1';";

$result=mysql_query($query, $connection);
if ( !$result )
{
echo "Failed to execute query<P>\n";
echo mysql_error();
exit;
}

unset($store);
while ( $fields=mysql_fetch_array($result) )
{
$store[]=$fields[0];
}

$top=count($store);
$touse=mt_rand(1, $top);

echo "Using question ".$touse;

// $store[$touse] then holds the id of the question to use.

?>