php如何$_G兩個資料表裡的不同資料？

這是原來的調用：
$_G['db']->from('dbpre_subject');
$_G['db']->select('*');
$_G['db']->where('city_id', array(0,$_CITY['aid']));
$_G['db']->where_concat_like('name,subname', "%{$q}%");
$_G['db']->where('status', 1);

現在我要在此基礎之上，在調用dbpre_subject_product_new 這個資料表裡的c_product_price和c_product_content這兩個欄位，，，改怎麼寫，，，先謝謝諸位大神了

//把源碼貼上

!defined('IN_MUDDER') && exit('Access Denied');

$city_id = _get('city_id', null, MF_INT_KEY);
if($city_id>0) {

$citys = $_G['loader']->variable('area');if(!$city = $citys[$city_id]) redirect('global_area_city_id_invalid');if(!$city['enabled']) redirect('global_area_city_disabled');init_city($city_id);

}

$q = _input('keyword', '', MF_TEXT);
if(($_GET['Pathinfo'] || $_GET['Rewrite']) && $q && $_G['charset'] != 'utf-8' && $_G'cfg') {

$q = charset_convert($q,'utf-8',$_G['charset']);

}
$q = str_replace(array("rn","r","n") ,'', _T($q));

$_G['db']->from('dbpre_subject');
$_G['db']->select('*');
$_G['db']->where('city_id', array(0,$_CITY['aid']));
$_G['db']->where_concat_like('name,subname', "%{$q}%");
$_G['db']->where('status', 1);

$multipage = '';
if($total = $_G['db']->count()) {

$_G['db']->sql_roll_back('from,select,where');$orderby = array($post['ordersort']=>$post['ordertype']);$offset = 10;$start = get_start($_GET['page'], $offset);$_G['db']->order_by($orderby);$_G['db']->limit($start, $offset);$list = $_G['db']->get();if($total) {    $multipage = mobile_page($total, $offset, $_GET['page'], url("item/mobile/do/search/keyword/$q/page/_PAGE_"));}

}

//顯示模版
if($_G['in_ajax']) {

include mobile_template('item_list_li');output();

}

$title = '搜尋產品：'.$q;
include mobile_template('item_list');

回複內容：

這是原來的調用：
$_G['db']->from('dbpre_subject');
$_G['db']->select('*');
$_G['db']->where('city_id', array(0,$_CITY['aid']));
$_G['db']->where_concat_like('name,subname', "%{$q}%");
$_G['db']->where('status', 1);

現在我要在此基礎之上，在調用dbpre_subject_product_new 這個資料表裡的c_product_price和c_product_content這兩個欄位，，，改怎麼寫，，，先謝謝諸位大神了

//把源碼貼上

!defined('IN_MUDDER') && exit('Access Denied');

$city_id = _get('city_id', null, MF_INT_KEY);
if($city_id>0) {

$citys = $_G['loader']->variable('area');if(!$city = $citys[$city_id]) redirect('global_area_city_id_invalid');if(!$city['enabled']) redirect('global_area_city_disabled');init_city($city_id);

}

$q = _input('keyword', '', MF_TEXT);
if(($_GET['Pathinfo'] || $_GET['Rewrite']) && $q && $_G['charset'] != 'utf-8' && $_G'cfg') {

$q = charset_convert($q,'utf-8',$_G['charset']);

}
$q = str_replace(array("rn","r","n") ,'', _T($q));

$_G['db']->from('dbpre_subject');
$_G['db']->select('*');
$_G['db']->where('city_id', array(0,$_CITY['aid']));
$_G['db']->where_concat_like('name,subname', "%{$q}%");
$_G['db']->where('status', 1);

$multipage = '';
if($total = $_G['db']->count()) {

$_G['db']->sql_roll_back('from,select,where');$orderby = array($post['ordersort']=>$post['ordertype']);$offset = 10;$start = get_start($_GET['page'], $offset);$_G['db']->order_by($orderby);$_G['db']->limit($start, $offset);$list = $_G['db']->get();if($total) {    $multipage = mobile_page($total, $offset, $_GET['page'], url("item/mobile/do/search/keyword/$q/page/_PAGE_"));}

}

//顯示模版
if($_G['in_ajax']) {

include mobile_template('item_list_li');output();

}

$title = '搜尋產品：'.$q;
include mobile_template('item_list');

你這是什麼架構呢？不同的架構有不同的文法

