hoe een foto link uit database halen

<?php
$query = "SELECT id,link FROM fotos WHERE id='<idnummer>'";
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_array($result);

$link = $row['link'];

$html_link = "<img src=\"".$link."\" />";
?>

<?php
$query = "SELECT id,link FROM fotos WHERE id='<idnummer>'";
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_array($result);
 
$link = $row['link'];
 
$html_link = "<img src=\"".$link."\" />";
?>