select count(*) as doyo_total_page from dy_member AS a LEFT JOIN dy_member_field AS b ON a.id=b.aid WHERE b.u_gz REGEXP AND a.gid = 6
执行错误: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND a.gid = 6' at line 4

34.? ????????$this->arrSql[]?=?$sql;
35.? ????????if(?$result?=?mysql_query($sql,?$this->conn)?){
36.? ????????????return?$result;
37.? ????????}else{
38.? ????????????if(mysql_error()!=''){
39.? ????????????????syError("{$sql}执行错误:?"?.?mysql_error());
40.? ????????????}else{
41.? ????????????????return?TRUE;
42.? ????????????}
43.? ????????}
44.? ????}
3.? class?db_mysql?{
4.? ????public?$conn;
5.? ????public?$arrSql;
6.? ????public?function?getArray($sql)
7.? ????{
8.? ????????if(?!?$result?=?$this->exec($sql)?)return?array();
9.? ????????if(?!?mysql_num_rows($result)?)return?array();
10.? ????????$rows?=?array();
11.? ????????while($rows[]?=?mysql_fetch_array($result,MYSQL_ASSOC)){}
12.? ????????mysql_free_result($result);
13.? ????????array_pop($rows);
132.? ????????return?$this->update($conditions,?array($field=>$value));
133.? ????}
134.?
135.? ????public?function?findSql($sql)
136.? ????{
137.? ????????return?$this->_db->getArray($sql);
138.? ????}
139.?
140.? ????public?function?runSql($sql)
141.? ????{
142.? ????????return?$this->_db->exec($sql);
718.? ????}
719.? ????return?$allfields;
720.? }
721.? //统计
722.? function??total_page($sql,$v='doyo_total_page'){
723.? ????$a=syDB('molds')->findSql('select?count(*)?as?'.$v.'?from?'.$sql);
724.? ????return?$a[0][$v];
725.? }
726.? //支付平台
727.? function?payment($pay){
728.? ????$payment=syDB('payment')->find(array('pay'?=>?$pay),null,'name');
218.? //????????????????????????????????????????????????ON?b.u_scgz?=c.tid?WHERE?a.gid?=?".$get_gid['gid'].$sql_str);
219.? ????????????????//?要找工种
220.? ????????????????$total_page=total_page("dy_member?AS?a
221.? ????????????????????????????????????????????????LEFT?JOIN?dy_member_field?AS?b
222.? ????????????????????????????????????????????????ON?a.id=b.aid
223.? ????????????????????????????????????????????????WHERE?b.u_gz?REGEXP?".$this->pro."?AND?a.gid?=?".$get_gid['gid'].$sql_str);
224.? ????????????????$this->lists?=?$this->Class->syPager($this->syArgs('page',0,1),$this->type['listnum'],$total_page)->findSql($sql);
225.? ????????????????$pages=$this->Class->syPager()->getPager();
226.? ????????????????$this->pages=html_url('classtype',$this->type,$pages,$this->syArgs('page',0,1));
227.? ????????????????$list_c=$this->lists;
228.? ????????????????foreach($list_c?as?$k=>$f){
11.? ????$handle_controller?=?syClass($__controller,?null,?$GLOBALS['G_DY']["controller_path"].'/'.$__controller.".php");
12.? ????if(!is_object($handle_controller)?||?!method_exists($handle_controller,?$__action)){
13.? ????????syError('route?Error');
14.? ????????exit;
15.? ????}
16.? ????$handle_controller->$__action();
17.? ????if(FALSE?!=?$GLOBALS['G_DY']['view']['auto_display']){
18.? ????????$__tplname?=?$__controller.$GLOBALS['G_DY']['view']['auto_display_sep'].
19.? ????????????????$__action.$GLOBALS['G_DY']['view']['auto_display_suffix'];?
20.? ????????$handle_controller->auto_display($__tplname);
21.? ????}
2.? set_time_limit(60);
3.? require("config.php");
4.?
5.? $doyoConfig['view']['config']['template_dir']?=?APP_PATH.'/template/'.$doyoConfig['ext']['view_themes'];
6.? require(DOYO_PATH."/sys.php");
7.? spRun();????