Hyperlinks in table output

[mjrose]

I am trying to have php and MySQL output a table where one of the fields is a hyperlink. As shown below, the table output is correct, but I can't get the 5th column ( $myrow[4] ) to output a link where the database holds the name of a photo. The name of the photo prints OK but how to make it a link is the question. It is a relative link, so I would only need the table to display "image.jpg" as the link text.

while ($myrow = mysql_fetch_row($result)) {

printf("<tr><td>%s</td><td>%s</td><td><center>%s</center></td><td>$%s</td><td>%s</td><td>%s</td></tr>\n",

$myrow[0], $myrow[1], $myrow[2], $myrow[3], $myrow[4], $myrow[5]);

}

Thanks,

Mike

[Pig]

I never use printf because I find it much easier to read my code with the actual var names. This is how I would do it:

while( $row = mysql_fetch_array($result) )
{
    echo("
        <tr>
            <td>$row[0]</td>
            <td>$row[1]</td>
            <td>$row[2]</td>
            <td>$row[3]</td>
            <td><a href=\"$row[4]\">$row[4]</a></td>
            <td>$row[5]</td>
        </tr>
    ");
}