case and image help please

[charter]

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:

Number of records found: <?php echo mysql_num_rows($result); ?>
TW
LW
Wks
Title
Artist


<?php $i = 1; while($row = mysql_fetch_array($result)){ ?>
<?php echo stripslashes($row['TW']); ?>
<?php echo stripslashes($row['LW']); ?> //image or formatted RE
<?php echo stripslashes($row['Wks']); ?>
<?php echo stripslashes($row['Title']); ?> //upper case
<?php echo stripslashes($row['Artist']); ?>


<?php $i++; } ?>

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 Same type of thing here: if LW == 0 RE

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

[samaru]

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: Number of records found: <?php echo mysql_num_rows($result); ?> TW LW Wks Title Artist <?php $i = 1; while($row = mysql_fetch_array($result)){ ?> <?php echo stripslashes($row['TW']); ?> <?php echo stripslashes($row['LW']); ?> //image or formatted RE <?php echo stripslashes($row['Wks']); ?> <?php echo stripslashes($row['Title']); ?> //upper case <?php echo stripslashes($row['Artist']); ?> <?php $i++; } ?> 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.

[php] <?php echo strtoupper(ststripslashes($row['Title'])); //upper case ?> [/php]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.[php] <? if($row['LW']=='new') { echo ""; } elseif($row['LW']==0) { echo "RE } ?> //image or formatted RE[/php] If you need anything else, let me know.

[charter]

Many thanks inscissor.
I'll give it a try and let you know how I get on.

I am a newbie to PHP & MySQL.
I'm running the Database through PHP MyAdmin.

Do you know of any sites with tutorials for using PHP MyAdmin?
Again thanks.

[samaru]

You can try: http://hotwired.lycos.com/webmonkey/programming/php/tutorials/tutorial4.html

Other ways is just to go to google.com and type "php tutorial"