I am new to PHP and MySQL so am in need of some help please.
I am using MySQL through PHP MyAdmin.

I have a results page to a MySQL search and formatted it so that they come up as an HTML table.
This is it's code:

<table border="0" align="center">
<tr><!--Change colspan number as appropriate -->
<td colspan="7">Number of records found: <?php echo mysql_num_rows($result); ?></td>
</tr>
<tr>

<th>TW</th>
<th>LW</th>
<th>Wks</th>
<th>Title</th>
<th>Artist</th>

</tr>
<?php $i = 1; while($row = mysql_fetch_array($result)){ ?>
<tr>

<td><?php echo stripslashes($row['TW']); ?></td>
<td><?php echo stripslashes($row['LW']); ?></td> //image or formatted RE
<td><?php echo stripslashes($row['Wks']); ?></td>
<td><?php echo stripslashes($row['Title']); ?></td> //upper case
<td><?php echo stripslashes($row['Artist']); ?></td>

</tr>
<?php $i++; } ?>
</table>

Could some guru please amend the code for me where the comment Upper Case so that it will appear all in upper case. I know it uses the function strtoupper() but I don't know how to put the code into this table row.

The field where the comment for Image is, what I want is that if this field has new entered it will automatically insert a certain graphic. Also if this field of the MySQL database has a zero (0) entered, I wish it to automatically insert the letters RE in Yellow and bold.

How could I do these using if statements such as: if TW == new <img src = "new.gif">
Same type of thing here: if LW == 0 <b><font color>RE</font></b>

If someone would be so kind as to amend this code for me it would be greatly appreciated.