Posted on 2006-10-13 17:30
my 閱讀(304)
評論(0) 編輯 收藏 所屬分類:
工作記錄
今天在寫一個查詢程序
在SQL上暫時是這樣寫的：
$sql="select * from orders where createtime>='$begintime' and createtime<='$endtime' and state like'%$orderclass%' and firstname? like'%$firstname%' and lastname like'%$lastname%' and email like'%$emailname%' and realmlocation like'%$servername%' and servername like'%$realmname%' and faction like'%$faction%' and characters like'%$charact%' and ipnum like'%$ip%' and numbers>=$bnumbers and numbers<=$enumbers and moneys>=$bmoneys and moneys<=$emoneys";
值得注意的是
createtime>='$begintime' 中createtime是DATE型
numbers<=$enumbers 中numbers是整型
區別在加上了' '，被郁悶了一陣，雖人啊雖人