After displaying avatar can't display data

[oliver12]

After I display an image from the database, the table below it doesn't display the data. (the data is from the same database) What do you think the problem is?

 

<table border="1">
<tr>
<th align="left">Profile Picture</th>
</tr>
<?php
//Display result
while($row = mysql_fetch_array($result))
{ ?>
<tr>
<td><img src="files/<?=$row["file"]?>" height="200" width="150"</img></td>
</tr>
<?php 
} 
?>
</table>

<table border="1">

<tr>
<th align="left">Player User Name</th>
<th align="left">First Name</th>
<th align="left">Last Name</th>
</tr>
<?php
while($row = mysql_fetch_array($result))
{ ?>
<tr>
<td><?=$row["player_id"]?></td>
<td><?=$row["player_name"]?></td>
<td><?=$row["player_surname"]?></td>
</tr>
<?php 
} 
?>

[PFMaBiSmAd]

After you iterate over the result set, the result pointer is after the last row of data. You must reset the result pointer before you can iterate over the result set again - http://php.net/mysql_data_seek

[oliver12]

Thanks, took me a while to implement but i got it

[teamatomic]

This is not a valid image tag

<img src="files/<?=$row["file"]?>" height="200" width="150"</img>

An image tag does not have a closing tag

<img src="image.png">

 

 

HTH

Teamaotmic

[Alex]

This is not a valid image tag

<img src="files/<?=$row["file"]?>" height="200" width="150"</img>

An image tag does not have a closing tag

<img src="image.png">

 

 

HTH

Teamaotmic

 

If you want to nitpick that's a valid img tag either. In the img tag the alt attribute is required, and if it's XHTML it must self-close.