SQL高级助手
1: 列出所有数据 select * from m_data
2: 删除所有数据 delete from m_data
3: 列出某一栏目数据 select * from m_data where m_type =(select m_id from m_type where m_name = '频道1')
4: 删除某一栏目数据 delete from m_data where m_type =(select m_id from m_type where m_name = '频道1')
5: 列出某一专题的数据 select * from m_data where m_type =(select m_id from m_topic where m_name = '男人必看十部')
6: 删除 某一专题的数据 delete from m_data where m_type =(select m_id from m_topic where m_name = '男人必看十部')

SetQuery($sql); $dsql->Execute('sqlhelper'); $num = $dsql->GetTotalRow('sqlhelper'); if ($num%$pagesize) { $zongye=ceil($num/$pagesize); }elseif( $num%$pagesize==0){ $zongye=$num/$pagesize; } $moye=$zongye; $n = count($dsql->GetArray('sqlhelper')); $n = $n/2; $sql1 = $sql." limit $pagenum $pagesize"; $dsql->SetQuery($sql1); $dsql->Execute('sqlhelper2'); $row1=$dsql->GetOne(); foreach($row1 as $key=>$value){ if(is_string($key)){ ?> GetArray('sqlhelper2')){ ?>
 页次：/ 每页 总收录数据条 首页 上一页 =$zongye){ ?>下一页 下一页 尾页