jiage是表名,price和uid是字段,uid不是系统生成的字段,自己创建的.根据UID的大小判断 $a=$_POST['a']; $b=$_POST['b']; $c=$_POST['c']; $sql="update jiage set price='$a' where uid<=5 and uid>0,price='$b' where uid<=10 and uid>10,price='$c' where uid<=20 and uid>10";
$uid æ¯ç½å§æºå¨ç¼å·,æ ¹æ®ç½å§æºå¨ç¼å·æ¥è®¾å®æ¯å°æ¶çè´¹ç¨
追çæ©ï¼ç¨ä¸è¾¹é£è¯å¥å°±å¯ä»¥
ä¹å°±æ¯1-5å·ä¸ä¸ªä»·æ ¼
6-10å·ä¸ä¸ªä»·æ ¼
11-20å·ä¸ä¸ªä»·æ ¼
ç¶åï¼é£ä¸ªä»·æ ¼åºè¯¥æ¯æ°ååå§ï¼æçä½ ç¨å¼å·äºï¼æå°±ç¨å¼å·äº
$a=$_POST['a'];
$b=$_POST['b'];
$c=$_POST['c'];
$sql="update jiage set price=case when UID>0 and UID5 and UID10 and UID<=20 then '$c' end";
$result= mysql_query($sql);
if ($result) {
echo "æåï¼å¯ç ä¿®æ¹è´¹çæåï¼";
麻ç¦äº ææ³é®ä¸ æè¿è¡ä¹åæ°æ®åºä¸priceçæ°å没æåå,
æ©ï¼ä½ æ°æ®åºæ¯ä»ä¹çåï¼
ä½ ï¼å³ä¸è§,è¿ä¹é®å¤ªè½è¯¯æ¶é´