RE: can someone review this code

This message was sent from: General Support
http://forums.oscommerce.com/viewtopic.php?p=227192#227192
----------------------------------------------------------------

ok i think i found my problem and i need some help:
[code]//changes mltship
//get ship method
$methods = tep_db_fetch_array(tep_db_query("select method_name from " . ship_method));
$mltcount = sizeof($methods);[/code]

Right there is my problem its linking mydatabase.ship_method.method_name how can i get it so it goes to mydatabase.product_description.ship_method.method_name?  i tried putting a pd.ship_method, no luck at all