If this is mysql, you can use SELECT * FROM konkuranse ORDER BY RAND() LIMIT 1
To get a random row and skip all that stuff you have... ---John Holmes... > -----Original Message----- > From: Raymond Lilleodegard [mailto:[EMAIL PROTECTED]] > Sent: Thursday, December 05, 2002 5:36 PM > To: [EMAIL PROTECTED] > Subject: [PHP] Easy array stuff I think for those who can I guess. > > Hi! > > I am trying to get out a value of an array that I have made from a query > and > deliver the value into a variable. I have made this code. Am I totally > lost? > > > while ($myrow = mysql_fetch_array($result)); > { > > $id = $myrow['id']; > > $deltaker[] = array ($id); > > } > > $limit = count($deltaker); > > > $finn_vinner = rand(0,$limit); > > $vinner_deltaker = $deltaker[$finn_vinner]; > > $vinner_id = current($vinner_deltaker); > > > $sql2 = "SELECT * FROM konkuranse WHERE id = '$vinner_id'"; > > > Best regards Raymond > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
