php mysqlÊý¾Ý¿âСÎÊÌ⣬ÊýÖµ±È½Ï - PHP / »ù´¡±à³Ì

<?php
$host="localhost";
$user="root";
$pass="pwd";
$my_db="test";
$my_tb="test";
$post="60-1000";//¼ÙÉèÕâÊÇpost´«Ë͹ýÀ´µÄÖµ
$row1=array();
$row1=explode("-",$post);//post·Ö³ÉÁ½¶Î·Ö±ðÊÇ$min=60,$max=1000;
$min=$row1[0];
$max=$row1[1];
//echo "min=".$min." "."max=".$max;exit;
$con=mysql_connect($host,$user,$pass);//ÁÙʱ²âÑéÊý¾Ý¿âÁ¬½Ó
if(!$con){
die('could not connect'.mysql_error());
}
mysql_select_db($my_db,$con);
$sql="select *from test where and num> $min and num< $max";//ÎÊÌⲿ·Ö
//echo $sql;
$result=mysql_query($sql);
while($row=mysql_fetch_array($result)){
echo $row['num'];
echo "<br/>";
}
mysql_close($con);

?>

Èç¹û$minºÍ$maxµÄÿ¸öλ¶¼ÊÇ1-9Ö®¼äµÄ»°Êý¾Ý¿âÊÇÕý³££¬²»»á±¨´í
Èç¹û²ôºÍÁË×Öĸ¾Í»á±¨´í£¬ÓÐʲô°ì·¨¸øËûÑé֤һϻòÕߣ¬²»ÈÃËû±¨´í

´ËÎÊÌâ²âÑétestÃûÊý¾Ý¿âϵÄtest±íϵÄnum×ֶΣ¬¸ñʽΪstring

---

²»ºÃÒâ˼¸Õ´ò´íÁË£¬ÏÂÃæÓï¾äûÓÐand
$sql="select *from test where and num> $min and num< $max";//ÎÊÌⲿ·Ö

---

where and -> where