alles uit de mysql database halen

<?php
include ('config.php');
$sql = "SELECT site FROM sites";
$result = mysql_query($sql);
$r=mysql_fetch_array($result);
{

	$list=$r["site"];  
}
echo ('' .$list. '');
?>

<?php
include ('config.php');
$sql = "SELECT site FROM sites";
$result = mysql_query($sql);
$r=mysql_fetch_array($result);
{
 
	$list=$r["site"];  
}
echo ('' .$list. '');
?>

<?php
include ('config.php');
$sql = "SELECT site FROM sites";
$result = mysql_query($sql);
while($r=mysql_fetch_array($result))
{

    echo $r["site"];  
}
?>

<?php
include ('config.php');
$sql = "SELECT site FROM sites";
$result = mysql_query($sql);
while($r=mysql_fetch_array($result))
{
 
    echo $r["site"];  
}
?>

echo ('' .$list. '');

echo ('' .$list. '');

echo $list;

echo $list;

echo $r["site"];

echo $r["site"];

echo $r["site"]."<br />";

echo $r["site"]."<br />";