[SOLVED] I need help with this code

[LOUDMOUTH]

I have this current code that places the word [DO] into my page.  I would like to replace the [DO] with and image instead.  How do I do this?

 

<?

$result = mysql_query("SELECT * FROM `crimes` ORDER BY `nerve` ASC");

while($line = mysql_fetch_array($result, MYSQL_ASSOC)) {

echo "<tr><td width='50%'>".$line['name']."</td><td width='25%'>".$line['nerve']."</td><td width='25%'>[<a href=crime.php?id=".$line['id]."'>DO</a>]</td></tr>";

}

?>

 

 

[ram4nd]

<?
$result = mysql_query("SELECT * FROM `crimes` ORDER BY `nerve` ASC");
while($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
   echo '<tr><td width="50%">'.$line['name'].'</td><td width="25%">'.$line['nerve'].'</td><td width="25%"><a href="crime.php?id='.$line['id'].'"><img src="Here goes the image location" /></a></td></tr>';
}
?>

You shoud use single quotes instead of double if that is not necessary.

[LOUDMOUTH]

Thank you that worked.  But how do i make the border on the image disappear since it is a link?

[ram4nd]

<?
$result = mysql_query("SELECT * FROM `crimes` ORDER BY `nerve` ASC");
while($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
   echo '<tr><td width="50%">'.$line['name'].'</td><td width="25%">'.$line['nerve'].'</td><td width="25%"><a href="crime.php?id='.$line['id'].'"><img src="Here goes the image location" border="0" /></a></td></tr>';
}
?>

Just add border="0" to image attributes.

[LOUDMOUTH]

 

Thank you very much!