Resize image to thumbnail

[robonhigh]

Hi, I am trying to re-size the images to thumbnail size (50px) in this code I have but I'm not quite sure where to begin.

 

The php its self generates random products from a database and displays and image (100px) and the image title which is a link to the product itself.

 

Here's what I've got:

 

<div class="skin_fenavh">Random Item</div> 

<div class="skin_fenavmini">

 

<?php

$host  = 'localhost';

$dbUser = 'dbuser';

$dbPass = 'dbpassword';

$db = 'dbname';

 

mysql_connect("$host", "$dbUser", "$dbPass") or die(mysql_error());

mysql_select_db("$db") or die(mysql_error());

 

$result = mysql_query("SELECT id,imgsm,name FROM gbu0_prod order by rand() LIMIT 1" ) or die(mysql_error());

while($row = mysql_fetch_array( $result )) {

print "<a href=\"/linux/" . $row['id'] . ".html\"><img alt=\"\" src=\"media/gbu0/prodsm/" . $row['imgsm'] . "\" /><br />" . $row['name'] . "</a> ";

}

?>

 

</div>