...
Ok so couldn't you set that other table up into an array in either another php file with just an include or just in products.php and use what $products[product].unit comes up to get the full unit name using the same basic method?
__________________
-tmx-
|