实现多条件查询.docVIP

实现多条件查询 conn=mysql_connect(localhost,root,); db=mysql_select_db(lingyun); query=select from message where tradetype=.tradetype.; 交易类型，如出租，出售 SQL=SQL . wuye= . wuye . ; if(housetype!=不限){ query.= housetype=.housetype.; 房屋类型，如二室一厅，三室二厅 } if(degree!=不限){ query.= degree=.degree.; 新旧程度 } if(wuye!=不限){ query.= wuye=.wuye.; 物业类型 如住房，商铺 } if(price2!=){ switch(price1){ case 大于 query.= price.price2.; 价格 break; case 等于 query.= price=.price2.; break; case 小于 query.= price.price2.; break; } } if(area2!=){ switch(area1){ case 大于 query.= area.area2.; 面积 break; case 等于 query.= area=.area2.; break; case 小于 query.= area.area2.; break; } } switch(pubdate){ 发布日期 case 本星期内 query.= TO_DAYS(NOW()) - TO_DAYS(date)=7; break; case 一个月内 query.= TO_DAYS(NOW()) - TO_DAYS(date)=30; break; case 三个月内 query.= TO_DAYS(NOW()) - TO_DAYS(date)=91; break; case 六个月内 query.= TO_DAYS(NOW()) - TO_DAYS(date)=183; break; } if(address!=){ query.= address like %address%; 地址 } if(!page){ page=1; } 二、输出查询结果： php if (page){ page_size=20; result=mysql_query(query); #message_count=mysql_result(result,0,total); message_count=10; page_count=ceil(message_countpage_size); offset=(1)page_size; query=query. order by date desc limit offset, page_size; result=mysql_query(query); if(result){ rows=mysql_num_rows(result); if(rows!=0){ while(myrow=mysql_fetch_array(result)){ echo tr; echo td width=15 height=12img src=imagehome2.gif width=14 height=14td; echo td width=540 height=12myrow[id]nbsp;myrow[tradetype]nbsp;myrow[address]nbsp;myrow[wuye](myrow[housetype])font style=font-size9pt[myrow[date]]font; echo td; echo td width=75 height=12a href=view_d.phpcode=myrow[code] target=_blank详细内容atd; echo tr; } } else echo trtddiv align=centerimg src=imagesorry.gifbrbr没有找到满足你条件的记录divtdtr; } prev_page=1; next_page=page+1; echo div align=center; echo nbsp;第.page..page_count.页nbsp; if (page=1){ echo 第一页; } else{ echo a href=PATH_INFOpa