於後台的訂單查詢(order_info.htm)是有個顯示$order.region的功能.

    /* 取得区域名 */
    $sql = "SELECT concat(IFNULL(c.region_name, ''), '  ', IFNULL(p.region_name, ''), " .
                "'  ', IFNULL(t.region_name, ''), '  ', IFNULL(d.region_name, '')) AS region " .
            "FROM " . $ecs->table('order_info') . " AS o " .
                "LEFT JOIN " . $ecs->table('region') . " AS c ON o.country = c.region_id " .
                "LEFT JOIN " . $ecs->table('region') . " AS p ON o.province = p.region_id " .
                "LEFT JOIN " . $ecs->table('region') . " AS t ON o.city = t.region_id " .
                "LEFT JOIN " . $ecs->table('region') . " AS d ON o.district = d.region_id " .
            "WHERE o.order_id = '$order[order_id]'";
    $order['region'] = $db->getOne($sql);

小弟也想讓它顯示在前台的收货人信息上, 主要是flow.php 和 flow.dwt內, 不曉得如何修改?

請各位提供協助.

[ 本帖最后由 chirng 于 2007-12-25 15:57 编辑 ]

找下高手帮你解决吧.

引用:

原帖由 maikongjian14 于 2007-12-25 16:01 发表
找下高手帮你解决吧.

高手來指點一下吧!!!

这个问题我问过好几次，都没有回答，现在都不想再问了，我上次试了一下调用配送区域，但是只能显示到对应的数字，并不是显示文字

/* 取得区域名 */

    $sql = "SELECT concat(IFNULL(c.region_name, ''), '  ', IFNULL(p.region_name, ''), " .
                "'  ', IFNULL(t.region_name, ''), '  ', IFNULL(d.region_name, '')) AS name_of_region " .
            "FROM " . $ecs->table('user_address') . " AS o " .
                "LEFT JOIN " . $ecs->table('region') . " AS c ON o.country = c.region_id " .
                "LEFT JOIN " . $ecs->table('region') . " AS p ON o.province = p.region_id " .
                "LEFT JOIN " . $ecs->table('region') . " AS t ON o.city = t.region_id " .
                "LEFT JOIN " . $ecs->table('region') . " AS d ON o.district = d.region_id " .
            "WHERE o.user_id = '$consignee[user_id]'";
   
    $name_of_region = $db->getOne($sql);   
    $smarty->assign('name_of_region', $name_of_region);

[ 本帖最后由 chirng 于 2007-12-26 23:00 编辑 ]