$sql="SELECT
`r_id`,`r_adddate`,`r_name`,`r_position`,`r_edu`,`r_sex`,`r_pay`,`r_appraise`,`r_jobtype`,`r_workadd`,`m_nameshow` FROM `{$cfg['tb_pre']}resume` INNER JOIN `{$cfg['tb_pre']}member` ON `r_mid`=`m_id` WHERE ";
$sqladd=" `r_cnstatus`=1 AND `r_flag`=1 AND `r_openness`=0 AND `m_flag`=1 AND DATEDIFF(`m_startdate`,'".date('Y-m-d')."')<=0 AND DATEDIFF(`m_enddate`,'".date('Y-m-d')."')>=0 AND `r_personinfo`=1 AND `r_careerwill`=1".$sqladd;
if($usergroup==0&&$usergroup!='') $sqladd.=" AND `r_usergroup`=0";
if($usergroup==1) $sqladd.=" AND `r_usergroup`=1";
if($usergroup==2) $sqladd.=" AND `r_usergroup`=2";
$jobtype=isset($jobtype)?intval($jobtype):'';
if($jobtype==2) $sqladd.=" AND `r_jobtype`=2";
$sql.=$sqladd;
限制调取条数 默认是调取全部数据 我只想调取最新10000条 该怎么修改 谢谢了
`r_id`,`r_adddate`,`r_name`,`r_position`,`r_edu`,`r_sex`,`r_pay`,`r_appraise`,`r_jobtype`,`r_workadd`,`m_nameshow` FROM `{$cfg['tb_pre']}resume` INNER JOIN `{$cfg['tb_pre']}member` ON `r_mid`=`m_id` WHERE ";
$sqladd=" `r_cnstatus`=1 AND `r_flag`=1 AND `r_openness`=0 AND `m_flag`=1 AND DATEDIFF(`m_startdate`,'".date('Y-m-d')."')<=0 AND DATEDIFF(`m_enddate`,'".date('Y-m-d')."')>=0 AND `r_personinfo`=1 AND `r_careerwill`=1".$sqladd;
if($usergroup==0&&$usergroup!='') $sqladd.=" AND `r_usergroup`=0";
if($usergroup==1) $sqladd.=" AND `r_usergroup`=1";
if($usergroup==2) $sqladd.=" AND `r_usergroup`=2";
$jobtype=isset($jobtype)?intval($jobtype):'';
if($jobtype==2) $sqladd.=" AND `r_jobtype`=2";
$sql.=$sqladd;
限制调取条数 默认是调取全部数据 我只想调取最新10000条 该怎么修改 谢谢了
`r_id`,`r_adddate`,`r_name`,`r_position`,`r_edu`,`r_sex`,`r_pay`,`r_appraise`,`r_jobtype`,`r_workadd`,`m_nameshow` FROM `{$cfg['tb_pre']}resume` INNER JOIN `{$cfg['tb_pre']}member` ON `r_mid`=`m_id` WHERE ".' limit 开始取记录的位置,条数';
$sqladd=" `r_cnstatus`=1 AND `r_flag`=1 AND `r_openness`=0 AND `m_flag`=1 AND DATEDIFF(`m_startdate`,'".date('Y-m-d')."')<=0 AND DATEDIFF(`m_enddate`,'".date('Y-m-d')."')>=0 AND `r_personinfo`=1 AND `r_careerwill`=1".$sqladd;
if($usergroup==0&&$usergroup!='') $sqladd.=" AND `r_usergroup`=0";
if($usergroup==1) $sqladd.=" AND `r_usergroup`=1";
if($usergroup==2) $sqladd.=" AND `r_usergroup`=2";
$jobtype=isset($jobtype)?intval($jobtype):'';
if($jobtype==2) $sqladd.=" AND `r_jobtype`=2";
$sql.=$sqladd;
注意:请修改“开始取记录的位置”为实际记录开始的索引位置,“取记录条数”请修改为要取的具体条数,例如:limit 0,10 表示从第0条记录开始取10条,注意索引是从0开始的
你可以这样
在sql语句后面的加上limit 0,1000
是说从第0条取取1000条数据