Loop Help

[Vivid Lust]

Im trying to solect the whole column "url", and display contents row by row:

 

#Display images
$query = mysql_query( "SELECT url FROM gallery")
or die(mysql_error());
$row = mysql_fetch_assoc($query);
while ($row = mysql_fetch_assoc($query)){
echo $row['url'];

 

The problem is, is that only one URL is displayed,

[rhodesa]

It should look something like this:

 

<?php
  $query = mysql_query("SELECT url FROM gallery")
    or die(mysql_error());
  while ($row = mysql_fetch_assoc($query)){
    echo $row['url'];
  }
?>