ecshop增加调用字段的方法实例

$arr[$article_id]['description'] = $row['description'];
$arr[$article_id]['file_url'] = $row['file_url'];

$sql = 'SELECT article_id, title, author, add_time, file_url, description, open_type' .
' FROM ' .$GLOBALS['ecs']->table('article') .
' WHERE is_open = 1 AND ' . $cat_str .
' ORDER BY article_type DESC, article_id DESC';

$meta = $db->getRow("SELECT keywords, cat_desc FROM " . $ecs->table('article_cat') . " WHERE cat_id = '$cat_id'");

$meta = $db->getRow("SELECT keywords,cat_name, cat_desc FROM " . $ecs->table('article_cat') . " WHERE cat_id = '$cat_id'");

$smarty->assign('description', htmlspecialchars($meta['cat_desc']));

$smarty->assign('cat_name', htmlspecialchars($meta['cat_name']));