<? $rs=mysql_query("select id from table") or die("error!")
while($row=mysql_fetch_array($rs)){ ?>
<option value="<?=row[id]?>"><?=row[id]?></option>
<? }?>
</select>
SELECTCASE WHEN (age >=20 and age <25) THEN 0
CASE WHEN (age >=25 and age <=30) THEN 1
ELSE -1 END
FROM student
用case when
case
when 条件1 then 值1
when 条件2 then 值2
else 值3
end
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)