mshin****@nifty*****
mshin****@nifty*****
2005年 11月 8日 (火) 18:20:23 JST
ご連絡ありがとうございます。
># なるべく全文引用は止めてください（警告１）
すいません、以後気をつけます。
>> $new_products_query =
については、以下のとおりです
$new_products_query = tep_db_query("select p.products_id, p.products_image, p.
products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_
price) as products_price, pd.products_description from " . TABLE_PRODUCTS . "
p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TAB
LE_PRODUCTS_DESCRIPTION . " pd where products_status = '1' and p.products_id
= pd.products_id order by p.products_date_added desc limit " . MAX_DISPLAY_NEW
_PRODUCTS);
} else {
$new_products_query = tep_db_query("select distinct p.products_id, p.produ
cts_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price
, p.products_price) as products_price, pd.products_description from " . TABLE_
PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.product
s_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c, "
. TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = p2c.products_id and
p2c.categories_id = c.categories_id and c.parent_id = '" . $new_products_categ
ory_id . "' and p.products_status = '1' and p.products_id = pd.products_id ord
er by p.products_date_added desc limit " . MAX_DISPLAY_NEW_PRODUCTS);
}
>> $info_box_contents[$row][$col] =
については、以下のとおりです
'text' => '<table width="260"><tr><td colspan="3" class=NewProductsName><a hre
f="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['pr
oducts_id']) . '">' . $new_products['products_name'] . '</a></td></tr><tr><td>
<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_produc
ts['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $new_products['products_
image'], $new_products['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT
) . '</a></td><td align="right"><div width="50" valign="top"><STRONG style="FO
NT-SIZE: 8px; COLOR: #f87c00">' .
$new_products['products_description'] . '
</strong></div><br><STRONG style="FONT-SIZE: 15px; COLOR: #f87c00">' .
$currencies->display_price($new_products['products_price'], $new_products['pro
ducts_tax_class_id']) . '<a href="' . tep_href_link(FILENAME_DEFAULT, tep_get_
all_get_params(array('action')) . 'action=buy_now&products_id=' . $new_product
s['products_id'], 'NONSSL') . '"></strong>' . tep_image_button('button_buy_now
.gif', TEXT_BUY . $new_products['products_name'] . TEXT_NOW) . '</a></td></tr>
</table>');
すいません、右も左もわからないものでして・・・本当にお手数を
おかけして申し訳ございませんが、何卒、宜しくお願い致します。