看看这个如何同时调用两个数据表里的不同数据？

这是原来的调用：
$_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这两个字段，，，改怎么写，，，先谢谢诸位大神了

bee餐饮点餐外卖小程序

bee餐饮点餐外卖小程序是针对餐饮行业推出的一套完整的餐饮解决方案，实现了用户在线点餐下单、外卖、叫号排队、支付、配送等功能，完美的使餐饮行业更高效便捷！功能演示：1、桌号管理登录后台，左侧菜单 “桌号管理”，添加并管理你的桌号信息，添加以后在列表你将可以看到 ID 和 密钥，这两个数据用来生成桌子的二维码2、生成桌子二维码例如上面的ID为 308，密钥为 d3PiIY，那么现在去左侧菜单微信设置

1

查看详情

//下面是源码：

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

$city_id = _get('city_id', null, MF_INT_KEY);
if($city_id>0) {
$citys = $_G['loader']->variable('area');

<code>if(!$city = $citys[$city_id]) redirect('global_area_city_id_invalid');
if(!$city['enabled']) redirect('global_area_city_disabled');
init_city($city_id);</code>

}

$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');

<code>if(!$city = $citys[$city_id]) redirect('global_area_city_id_invalid');
if(!$city['enabled']) redirect('global_area_city_disabled');
init_city($city_id);</code>

}

$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');

不知所谓, 你连你们用的什么PHP框架都不知道, 也不知道用的什么mysql驱动, 没人回答得了你, 还请重新命好题再提问吧