autom. nummeren

<?php
	$connection = connect_to_db();
	$sql = "SELECT * FROM banners order by time";
	$result = mysql_query($sql, $connection);
	while($row = mysql_fetch_array($result))
	{
		echo '' . $row['url'] . '<br>';
		
	}
?>

<?php
	$connection = connect_to_db();
	$sql = "SELECT * FROM banners order by time";
	$result = mysql_query($sql, $connection);
	while($row = mysql_fetch_array($result))
	{
		echo '' . $row['url'] . '<br>';
 
	}
?>

<?php
$teller = 0;
while($row = mysql_fetch_array($result))
{
$teller++;
echo $teller.'. $row['url'] . '<br>';
}

<?php
$teller = 0;
while($row = mysql_fetch_array($result))
{
$teller++;
echo $teller.'. $row['url'] . '<br>';
}

$i = 0;
while($row = mysql_fetch_array($result))
{
$i++;
echo $i ': ' . $row['url'] . '<br>';
}

$i = 0;
while($row = mysql_fetch_array($result))
{
$i++;
echo $i ': ' . $row['url'] . '<br>';
}

<?php
    $qGetBanners = mysql_query("SELECT *
                                FROM banners
                                ORDER BY time", $connection);
                                
    $i = 1;
    
    while ($aBanner = mysql_fetch_assoc($qGetBanners))
    {
        echo $i++ . ': ' . $aBanner['url'] . '<br />';
    }
?>

<?php
    $qGetBanners = mysql_query("SELECT *
                                FROM banners
                                ORDER BY time", $connection);
 
    $i = 1;
 
    while ($aBanner = mysql_fetch_assoc($qGetBanners))
    {
        echo $i++ . ': ' . $aBanner['url'] . '<br />';
    }
?>