IE & FF 之CSS 注意地方

1.內插定位圖
<img src="pix.gif" class="nobrimg" width="30" height="1" border="0">
.nobrimg {display:block;height:1px;margin:0 0 0 0;padding:0;border:0;}



2.最小高度
{height:auto !important;height:350px; min-height:350px;}

3.圖文對齊顯示

vertical-align:middle; 

?? NO！NO！ ＮＯ！

正卻解答：img{margin:0 3px -3px 0;}

MySQL CREATE VIEW

CREATE VIEW pay_stat as  SELECT left(pay_status,10) as PP ,SUM( IF( payfor ='現場繳費', `final_cost`, 0 ) ) AS 現場繳費 ,SUM( IF( payfor ='刷卡', `final_cost`, 0 ) ) AS 刷卡 ,SUM( IF( payfor ='超商代碼', `final_cost`, 0 ) ) AS 超商代碼,SUM( IF( payfor ='虛擬帳號', `final_cost`, 0 ) ) AS 虛擬帳號 FROM `class_student` WHERE pay_status !='' group by  PP  order by pay_status ASC