How Can I load a Product from the db based on the nid?
$product = db_fetch_object(db_query("SELECT * FROM {uc_products} WHERE nid = '%s'", *nid here*)); print_r($product);