mysql query:select * from [pre]vipcenter_25 where status=3 order by limit 0,20
mysql error: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 'limit 0,20' at line 1 mysql errno:0
message:mysql query error
我想在公司主页上添加一个“成功案例”的新模块，复制的“品牌展示”的模块，把代码中的brand批量替换成success，其他都没问题就是在后台模块编辑时候出现这个报错
回复讨论(解决方案) select * from [pre]vipcenter_25 where status=3 order by limit 0,20
检查下sql，是否可以执行。
order by xx limit 0,20
不能执行，，
select * from [pre]vipcenter_25 where status=3 order by limit 0,20
多了套红的部分，如何你能运行？
select * from [pre]vipcenter_25 也报错
sql] select * from [pre]vipcenter_25
[err] 1064 - 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 '[pre]vipcenter_25' at line 1
sql] select * from [pre]vipcenter_25
[err] 1064 - 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 '[pre]vipcenter_25' at line 1
确定你表的名称书写正确，还有order by xx xx必须为表的字段属性，你上面未加上。 我试了，加上了也不行啊
sql] select * from [pre]vipcenter_25
[err] 1064 - 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 '[pre]vipcenter_25' at line 1
确定你表的名称书写正确，还有order by xx xx必须为表的字段属性，你上面未加上。
are you sure? 其实我也不太懂，我是个新手，但是我是完全复制的原有的模块的代码，数据库也新建了表，不知道是哪里出了问题
其实我也不太懂，我是个新手，但是我是完全复制的原有的模块的代码，数据库也新建了表，不知道是哪里出了问题
确定你表的名称书写正确，还有order by xx xx必须为表的字段属性，你上面未加上。
1.select * from tablename?
2.select * from tablename order by id? function get_list($condition = 'status=3', $order = 'edittime desc', $cache = '') {
global $mod, $pages, $page, $pagesize, $offset, $items, $sum;
if($page > 1 && $sum) {
$items = $sum;
} else {
$r = $this->db->get_one(select count(*) as num from {$this->table} where $condition, $cache);
$items = $r['num'];
}
$pages = defined('catid') ? listpages(1, catid, $items, $page, $pagesize, 10, $mod['linkurl']) : pages($items, $page, $pagesize);
$lists = $catids = $cats = array();
$result = $this->db->query( select * from {$this->table} where $condition order by $order limit $offset,$pagesize, $cache);
while($r = $this->db->fetch_array($result)) {
$r['adddate'] = timetodate($r['addtime'], 5);
$r['editdate'] = timetodate($r['edittime'], 5);
$r['todate'] = timetodate($r['totime'], 3);
$r['alt'] = $r['title'];
$r['title'] = set_style($r['title'], $r['style']);
$r['linkurl'] = $mod['linkurl'].$r['linkurl'];
$catids[$r['catid']] = $r['catid'];
$lists[] = $r;
}
select * from destoon_vipcenter_25 where status=3 order by edittime limit 0,20 可以查询
输出看看：
die(select * from {$this->table} where $condition order by $order limit $offset,$pagesize);
检查{$this->table}，$condition,$order , $offset, $pagesize,对应是否有值
select * from [pre]vipcenter_25 也报错
表名字怎么会出现这个？
输出看看：
die(select * from {$this->table} where $condition order by $order limit $offset,$pagesize);
检查{$this->table}，$condition,$order , $offset, $pagesize,对应是否有值
什么都没输出，没有值
select * from [pre]vipcenter_25 也报错
表名字怎么会出现这个？
这个我也不清楚，以前没学过php
源代码：
echo select * from {$this->table} where $condition order by $order limit $offset,$pagesize;
die();
再试试
moduleid = $moduleid;
$this->table = $table;
$this->table_data = $table_data;
$this->split = $mod['split'];
$this->db = &$db;
$this->pre = $this->db->pre;
$this->fields = array('catid','level','title','style','fee','introduce','areaid','thumb','homepage','status','hits','username','addtime','adddate','editor','edittime','editdate','ip','template', 'linkurl','filepath','note','company','truename','telephone','mobile','address','email','msn','qq','ali','skype');
}
function pass($post) {
global $dt_time, $mod;
if(!is_array($post)) return false;
if(!$post['catid']) return $this->_(lang('message->pass_catid'));
if(strlen($post['title']) _(lang('message->pass_title'));
if(!$post['thumb']) return $this->_(lang('message->pass_logo'));
return true;
}
function set($post) {
global $mod, $dt_time, $dt_ip, $_username, $_userid;
$post['editor'] = $_username;
$post['addtime'] = (isset($post['addtime']) && $post['addtime']) ? strtotime($post['addtime']) : $dt_time;
$post['adddate'] = timetodate($post['addtime'], 3);
$post['edittime'] = $dt_time;
$post['editdate'] = timetodate($post['edittime'], 3);
$post['fee'] = dround($post['fee']);
$post['homepage'] = fix_link(trim($post['homepage']));
$post['video'] = fix_link(trim($post['video']));
$post['video_width'] = intval($post['video_width']);
$post['video_height'] = intval($post['video_height']);
$post['title'] = trim($post['title']);
$post['content'] = stripslashes($post['content']);
$post['content'] = save_local($post['content']);
if($mod['clear_link']) $post['content'] = clear_link($post['content']);
if($mod['save_remotepic']) $post['content'] = save_remote($post['content']);
if($mod['introduce_length']) $post['introduce'] = addslashes(get_intro($post['content'], $mod['introduce_length']));
if($this->itemid) {
$new = $post['content'];
if($post['thumb']) $new .= '';
$r = $this->get_one();
$old = $r['content'];
if($r['thumb']) $old .= '';
delete_diff($new, $old);
} else {
$post['ip'] = $dt_ip;
}
if(!defined('dt_admin')) {
$content = $post['content'];
unset($post['content']);
$post = dhtmlspecialchars($post);
$post['content'] = dsafe($content);
}
$post['content'] = addslashes($post['content']);
return array_map(trim, $post);
}
function get_one() {
$content_table = content_table($this->moduleid, $this->itemid, $this->split, $this->table_data);
return $this->db->get_one(select * from {$this->table} a,{$content_table} c where a.itemid=c.itemid and a.itemid=$this->itemid);
}
function get_list($condition = 'status=3', $order = 'edittime desc', $cache = '') {
global $mod, $pages, $page, $pagesize, $offset, $items, $sum;
if($page > 1 && $sum) {
$items = $sum;
} else {
$r = $this->db->get_one(select count(*) as num from {$this->table} where $condition, $cache);
$items = $r['num'];
}
$pages = defined('catid') ? listpages(1, catid, $items, $page, $pagesize, 10, $mod['linkurl']) : pages($items, $page, $pagesize);
$lists = $catids = $cats = array();
$result = $this->db->query(select * from {$this->table} where $condition order by $order limit $offset,$pagesize, $cache);
while($r = $this->db->fetch_array($result)) {
$r['adddate'] = timetodate($r['addtime'], 5);
$r['editdate'] = timetodate($r['edittime'], 5);
$r['todate'] = timetodate($r['totime'], 3);
$r['alt'] = $r['title'];
$r['title'] = set_style($r['title'], $r['style']);
$r['linkurl'] = $mod['linkurl'].$r['linkurl'];
$catids[$r['catid']] = $r['catid'];
$lists[] = $r;
}
if($catids) {
$result = $this->db->query(select catid,catname,linkurl from {$this->db->pre}category where catid in (.implode(',', $catids).));
while($r = $this->db->fetch_array($result)) {
$cats[$r['catid']] = $r;
}
if($cats) {
foreach($lists as $k=>$v) {
$lists[$k]['catname'] = $v['catid'] ? $cats[$v['catid']]['catname'] : '';
$lists[$k]['caturl'] = $v['catid'] ? $mod['linkurl'].$cats[$v['catid']]['linkurl'] : '';
}
}
}
return $lists;
}
function add($post) {
global $mod;
$post = $this->set($post);
$sqlk = $sqlv = '';
foreach($post as $k=>$v) {
if(in_array($k, $this->fields)) { $sqlk .= ','.$k; $sqlv .= ,'$v'; }
}
$sqlk = substr($sqlk, 1);
$sqlv = substr($sqlv, 1);
$this->db->query(insert into {$this->table} ($sqlk) values ($sqlv));
$this->itemid = $this->db->insert_id();
$content_table = content_table($this->moduleid, $this->itemid, $this->split, $this->table_data);
$this->db->query(insert into {$content_table} (itemid,content) values ('$this->itemid', '$post[content]'));
$this->update($this->itemid);
if($post['status'] == 3 && $post['username'] && $mod['credit_add']) {
credit_add($post['username'], $mod['credit_add']);
credit_record($post['username'], $mod['credit_add'], 'system', lang('my->credit_record_add', array($mod['name'])), 'id:'.$this->itemid);
}
clear_upload($post['content'].$post['thumb'], $this->itemid);
return $this->itemid;
}
function edit($post) {
$this->delete($this->itemid, false);
$post = $this->set($post);
$sql = '';
foreach($post as $k=>$v) {
if(in_array($k, $this->fields)) $sql .= ,$k='$v';
}
$sql = substr($sql, 1);
$this->db->query(update {$this->table} set $sql where itemid=$this->itemid);
$content_table = content_table($this->moduleid, $this->itemid, $this->split, $this->table_data);
$this->db->query(update {$content_table} set content='$post[content]' where itemid=$this->itemid);
$this->update($this->itemid);
clear_upload($post['content'].$post['thumb'], $this->itemid);
if($post['status'] > 2) $this->tohtml($this->itemid, $post['catid']);
return true;
}
function tohtml($itemid = 0, $catid = 0) {
global $module, $mod;
if($mod['show_html'] && $itemid) tohtml('show', $module, itemid=$itemid);
}
function update($itemid) {
$item = $this->db->get_one(select * from {$this->table} where itemid=$itemid);
$update = '';
$keyword = $item['title'].','.$item['company'].','.strip_tags(cat_pos(get_cat($item['catid']), ',')).strip_tags(area_pos($item['areaid'], ','));
if($keyword != $item['keyword']) {
$keyword = str_replace(//, '', addslashes($keyword));
$update .= ,keyword='$keyword';
}
$item['itemid'] = $itemid;
$linkurl = itemurl($item);
if($linkurl != $item['linkurl']) $update .= ,linkurl='$linkurl';
$member = $item['username'] ? userinfo($item['username']) : array();
if($member) {
foreach(array('groupid','vip','validated','company','areaid','truename','telephone','mobile','address','qq','msn','ali','skype') as $v) {
if($item[$v] != $member[$v]) $update .= ,$v='.addslashes($member[$v]).';
}
if($item['email'] != $member['mail']) $update .= ,email='.addslashes($member['mail']).';
}
if($update) $this->db->query(update {$this->table} set .(substr($update, 1)). where itemid=$itemid);
}
function recycle($itemid) {
if(is_array($itemid)) {
foreach($itemid as $v) { $this->recycle($v); }
} else {
$this->db->query(update {$this->table} set status=0 where itemid=$itemid);
$this->delete($itemid, false);
return true;
}
}
function restore($itemid) {
global $module, $mod;
if(is_array($itemid)) {
foreach($itemid as $v) { $this->restore($v); }
} else {
$this->db->query(update {$this->table} set status=3 where itemid=$itemid);
if($mod['show_html']) tohtml('show', $module, itemid=$itemid);
return true;
}
}
function delete($itemid, $all = true) {
global $mod;
if(is_array($itemid)) {
foreach($itemid as $v) {
$this->delete($v, $all);
}
} else {
$this->itemid = $itemid;
$r = $this->get_one();
if($mod['show_html']) {
$_file = dt_root.'/'.$mod['moduledir'].'/'.$r['linkurl'];
if(is_file($_file)) unlink($_file);
}
if($all) {
$userid = get_user($r['username']);
if($r['thumb']) delete_upload($r['thumb'], $userid);
if($r['content']) delete_local($r['content'], $userid);
$this->db->query(delete from {$this->table} where itemid=$itemid);
$content_table = content_table($this->moduleid, $this->itemid, $this->split, $this->table_data);
$this->db->query(delete from {$content_table} where itemid=$itemid);
if($mod['cat_property']) $this->db->query(delete from {$this->db->pre}category_value where moduleid=$this->moduleid and itemid=$itemid);
if($r['username'] && $mod['credit_del']) {
credit_add($r['username'], -$mod['credit_del']);
credit_record($r['username'], -$mod['credit_del'], 'system', lang('my->credit_record_del', array($mod['name'])), 'id:'.$this->itemid);
}
}
}
}
function check($itemid) {
global $_username, $dt_time, $mod;
if(is_array($itemid)) {
foreach($itemid as $v) { $this->check($v); }
} else {
$this->itemid = $itemid;
$item = $this->get_one();
if($mod['credit_add'] && $item['username'] && $item['hits'] credit_record_add', array($mod['name'])), 'id:'.$this->itemid);
}
$editdate = timetodate($dt_time, 3);
$this->db->query(update {$this->table} set status=3,hits=hits+1,editor='$_username',edittime=$dt_time,editdate='$editdate' where itemid=$itemid);
$this->tohtml($itemid);
return true;
}
}
function reject($itemid) {
global $_username, $dt_time;
if(is_array($itemid)) {
foreach($itemid as $v) { $this->reject($v); }
} else {
$this->db->query(update {$this->table} set status=1,editor='$_username' where itemid=$itemid);
return true;
}
}
function clear($condition = 'status=0') {
$result = $this->db->query(select itemid from {$this->table} where $condition );
while($r = $this->db->fetch_array($result)) {
$this->delete($r['itemid']);
}
}
function level($itemid, $level) {
$itemids = is_array($itemid) ? implode(',', $itemid) : $itemid;
$this->db->query(update {$this->table} set level=$level where itemid in ($itemids));
}
function refresh($itemid) {
global $dt_time;
$editdate = timetodate($dt_time, 3);
$itemids = is_array($itemid) ? implode(',', $itemid) : $itemid;
$this->db->query(update {$this->table} set edittime='$dt_time',editdate='$editdate' where itemid in ($itemids));
}
function _($e) {
$this->errmsg = $e;
return false;
}
}
?>
输出：select * from destoon_vipcenter_25 where status=3 order by limit 0,20
echo select * from {$this->table} where $condition order by $order limit $offset,$pagesize;
die();
再试试
你还是针对这个问题，贴出输出结果吧，不然你问的问题，没办法解答了。 问题算是解决了，function get_list($condition = 'status=3', $order = 'edittime desc', $cache = '') {
global $mod, $pages, $page, $pagesize, $offset, $items, $sum;
if($page > 1 && $sum) {
$items = $sum;
} else {
$r = $this->db->get_one(select count(*) as num from {$this->table} where $condition, $cache);
$items = $r['num'];
}
$pages = defined('catid') ? listpages(1, catid, $items, $page, $pagesize, 10, $mod['linkurl']) : pages($items, $page, $pagesize);
$lists = $catids = $cats = array();
$result = $this->db->query(select * from {$this->table} where $condition order by $order limit $offset,$pagesize, $cache);
是获得不了$order的值，直接用edittime desc代替$order,运行没问题。但是现在不明白是为什么获得不了$order的值
echo select * from {$this->table} where $condition order by $order limit $offset,$pagesize;
die();
再试试
你还是针对这个问题，贴出输出结果吧，不然你问的问题，没办法解答了。
还是非常感谢你！ 这个问题我告诉你原因吧，你复制了模块之后 没对模块进行设置 点击菜单最下面 模块设置 设置一下模块就好了。 这绝对是正确答案 你不要着急去改代码 代码没有问题的 。