at witts end, and help..

[davieboy]

trying to show ten results at random from the database but can only get one showing.
any ideas please folks

<?php 
include 'config.php';
$db = mysql_connect($db_host,$db_user,$db_pass);
mysql_select_db ($db_name) or die ("Cannot connect to database"); 
$result = mysql_query("SELECT id,link,site,displays FROM links LIMIT 10")or die (mysql_error()) ;  

while($r=mysql_fetch_array($result)) 
{
$id=$r["id"];
$site=$r["site"];
$link=$r["link"];
$displays++;
  }  

   $update = "UPDATE links SET displays=displays+1 WHERE id=$id";
    $updatesql = mysql_query($update);

echo "<b><a href=\"$link\" target=\"_blank\">$site</a></b><br>";
?>

[Kudose]

$query = "select from ... LIMIT 10";
while(($fetch = mysql_fetch_array($query)) !== FALSE){
  print_r($fetch);
}

[Weedpacket]

while($r=mysql_fetch_array($result))
{
$id=$r["id"];
$site=$r["site"];
$link=$r["link"];
$displays++;
  }   

Do what you want to do with this record before going on to the next one.

[davieboy]

i did try that but it updated all the records in the db, not just the one that i wanted (ie the displayed one)