product_id and manufacturers

[Guest]

for some reason, i cannot output the manufacturer id with this query:

$products_new_query_raw = "select p.products_id, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, p.products_date_added, m.manufacturers_name from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on (p.manufacturers_id = m.manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = pd.products_id and TO_DAYS(NOW()) - TO_DAYS(p.products_date_added) < '" . '30' . "' and pd.language_id = '" . (int)$languages_id . "' order by p.products_date_added DESC, pd.products_name";

$products_new_split = new splitPageResults($products_new_query_raw, '50');

 

trying to output using:

 <td valign="middle" class="infoBoxContents">' . $products_new['manufacturers_id'] . '</td>

 

no errors or anything, it just comes up blank. any suggestions?