Select array question

[Me01273]

Hi, when i select out of a dtabase like i have here:

$advert = @mysql_query("SELECT id, link FROM banner_adverts"); 
 if (!$advert) { 
   exit('<p>Error performing query: ' . 
       mysql_error() . '</p>'); 
 }
while ($row2 = mysql_fetch_array($advert)) {  
   $adid = $row2['id']; 
   $adlink = $row2['link']; 

$files = array($adlink);
$link = $files[array_rand($files)];
}
echo '<p>' . $link .
'</p>'; 

It asigns only the last database entry to $link
How can i make it random?

is $adlink an array itself or not?

Thanks in advance

David

[optl]

change $adlink = $row2['link'] to $adlink[] = $row2['link']
then change:

$files = array($adlink);
$link = $files[array_rand($files)]; 

to:

$link = $adlink[array_rand($adlink)]; 

[Me01273]

All works now, thank you so much.

David