四處流浪的阿基。I am Vagrant Walker

CASE 是 SQL 用來做為 if-then-else 之類邏輯的關鍵字。 CASE 的語法如下：

CASE

   WHEN condition THEN  result

   [WHEN···]

   [ELSE result]

END;

JQuery中基本的AJAX教學請參考：http://expect7.pixnet.net/blog/post/37919326
如果有需要loding中的圖示請參考：http://expect7.pixnet.net/blog/post/39827699
範例程式下載：http://www.megaupload.com/?d=QB8F68VI

在寫AJAX的時候，程式碼大部分都可以從網路上找到你要的答案。
但是要找圖片卻是一件很麻煩的事。
但是我發現了這個ajaxload網站，你只要點選幾個你要的設定。他就會產出圖片讓你直接下載。
有興趣的人可以直接到下列網址參考一下，非常好用。

JQuery在某些動作之後，想要把視窗移到最頂端。
只需要加入下列程式碼。
$(window).scrollLeft("0");
$(window).scrollTop("0");

Javascript在某些動作之後，想要把視窗移到最頂端。
只需要加入下列程式碼。
window.document.body.scrollTop = 0;
window.document.documentElement.scrollTop = 0;

基礎說明：
rand()：取得隨機亂數
說明：rand函式所傳回的資料型態為整數，會依據設計者傳入的最大值與最小值，傳回隨機亂數，可以同時不指定最大值與最小值，這個時候並不會出錯，此時會使用預設最大值getrandmax()=32767與預設最小值0做為基本判斷數值，也就是說rand()等於rand(0,32767)，會傳回0到32767之間的數值。

pH值，亦稱氫離子濃度指數、酸鹼值，是溶液中氫離子活度的一種標度，也就是通常意義上溶液酸鹼程度的衡量標準。
PH值計算公試：
其中[H+]指的是溶液中氫離子的活度（有時也被寫為[H3O+]，水合氫離子活度），單位為摩爾／升，在稀溶液中，氫離子活度約等於氫離子的濃度，可以用氫離子濃度來進行近似計算。
 
在標準溫度和壓力下，pH=7的水溶液（如：純水）為中性，這是因為水在標準溫度和壓力下自然電離出的氫離子和氫氧根離子濃度的乘積（水的離子積常數）始終是1×10−14，且兩種離子的濃度都是1×10−7mol/L。pH值小於7說明H+的濃度大於OH−的濃度，故溶液酸性強，而pH值大於7則說明H+的濃度小於OH−的濃度，故溶液鹼性強。所以pH值愈小，溶液的酸性愈強；pH愈大，溶液的鹼性也就愈強。
 
在非水溶液或非標準溫度和壓力的條件下，pH=7可能並不代表溶液呈中性，這需要通過計算該溶劑在這種條件下的電離常數來決定pH為中性的值。如373K（100℃）的溫度下，pH=6為中性溶液。 由於實際中的溶液不是理想溶液，所以僅僅用H+濃度是不可以準確測量的，因此也無法準確計算得到溶液的pH。故而應當採用H+活度，即pH=-lg aH+=-lgγ·cH+。這樣從理論上講只要知道氫離子的活度aH+就可以得到溶液的準確pH。[2]

以經成功透過糖加上酵母產出CO2。
考慮是否要去挖海邊的白沙回來當底沙用。
今天查到四尺上部過濾器的最便宜的價格：
MR.AQUA水族先生四尺三層式滴流式過濾槽 450元 只能郵寄
http://goods.ruten.com.tw/item/show?21106222089889

養魚常聽到人家說魚缸說是幾呎幾呎！但是常常搞不清楚到底是多大！所以查了一下！
1呎=12吋
1呎=30.48公分(cm)
1吋=2.54公分(cm)

有時候要在HTML中加一些特殊符號，像是"<"這樣的符號，可是直接打上去卻出現問題。在網路上找到相關資料。下面提供上來。
資料來源：http://ascii.cl/htmlcodes.htm

ASCII			HTML	HTML
Dec	Hex	Symbol	Number	Name	Description
32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47	20 21 22 23 24 25 26 27 28 29 2A 2B 2C 2D 2E 2F	! " # $ % & ' ( ) * + , - . /	  ! " # $ % & ' ( ) * + , - . /	" &	space exclamation point double quotes number sign dollar sign percent sign ampersand single quote opening parenthesis closing parenthesis asterisk plus sign comma minus sign - hyphen period slash

ASCII			HTML	HTML
Dec	Hex	Symbol	Number	Name	Description
48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63	30 31 32 33 34 35 36 37 38 39 3A 3B 3C 3D 3E 3F	0 1 2 3 4 5 6 7 8 9 : ; < = > ?	&#48; &#49; &#50; &#51; &#52; &#53; &#54; &#55; &#56; &#57; &#58; &#59; &#60; &#61; &#62; &#63;	&lt; &gt;	zero one two three four five six seven eight nine colon semicolon less than sign equal sign greater than sign question mark

ASCII			HTML	HTML
Dec	Hex	Symbol	Number	Name	Description
64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79	40 41 42 43 44 45 46 47 48 49 4A 4B 4C 4D 4E 4F	@ A B C D E F G H I J K L M N O	@ A B C D E F G H I J K L M N O		at symbol

ASCII			HTML	HTML
Dec	Hex	Symbol	Number	Name	Description
80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95	50 51 52 53 54 55 56 57 58 59 5A 5B 5C 5D 5E 5F	P Q R S T U V W X Y Z [ \ ] ^ _	P Q R S T U V W X Y Z [ \ ] ^ _		opening bracket backslash closing bracket caret - circumflex underscore

ASCII			HTML	HTML
Dec	Hex	Symbol	Number	Name	Description
96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111	60 61 62 63 64 65 66 67 68 69 6A 6B 6C 6D 6E 6F	` a b c d e f g h i j k l m n o	` a b c d e f g h i j k l m n o		grave accent

ASCII			HTML	HTML
Dec	Hex	Symbol	Number	Name	Description
112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127	70 71 72 73 74 75 76 77 78 79 7A 7B 7C 7D 7E 7F	p q r s t u v w x y z { | } ~	p q r s t u v w x y z { | } ~		opening brace vertical bar closing brace equivalency sign - tilde (not defined in HTML 4 standard)

ASCII			HTML	HTML
Dec	Hex	Symbol	Number	Name	Description
128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143	80 81 82 83 84 85 86 87 88 89 8A 8B 8C 8D 8E 8F				(not defined in HTML 4 standard) (not defined in HTML 4 standard) (not defined in HTML 4 standard) (not defined in HTML 4 standard) (not defined in HTML 4 standard) (not defined in HTML 4 standard) (not defined in HTML 4 standard) (not defined in HTML 4 standard) (not defined in HTML 4 standard) (not defined in HTML 4 standard) (not defined in HTML 4 standard) (not defined in HTML 4 standard) (not defined in HTML 4 standard) (not defined in HTML 4 standard) (not defined in HTML 4 standard) (not defined in HTML 4 standard)

ASCII			HTML	HTML
Dec	Hex	Symbol	Number	Name	Description
144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159	90 91 92 93 94 95 96 97 98 99 9A 9B 9C 9D 9E 9F				(not defined in HTML 4 standard) (not defined in HTML 4 standard) (not defined in HTML 4 standard) (not defined in HTML 4 standard) (not defined in HTML 4 standard) (not defined in HTML 4 standard) (not defined in HTML 4 standard) (not defined in HTML 4 standard) (not defined in HTML 4 standard) (not defined in HTML 4 standard) (not defined in HTML 4 standard) (not defined in HTML 4 standard) (not defined in HTML 4 standard) (not defined in HTML 4 standard) (not defined in HTML 4 standard) (not defined in HTML 4 standard)

ASCII			HTML	HTML
Dec	Hex	Symbol	Number	Name	Description
160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175	A0 A1 A2 A3 A4 A5 A6 A7 A8 A9 AA AB AC AD AE AF	¡ ¢ £ ¤ ¥ ¦ § ¨ © ª « ¬ ­ ® ¯	  ¡ ¢ £ ¤ ¥ ¦ § ¨ © ª « ¬ ­ ® ¯	  ¡ ¢ £ ¤ ¥ ¦ § ¨ © ª « ¬ ­ ® ¯	non-breaking space inverted exclamation mark cent sign pound sign currency sign yen sign broken vertical bar section sign spacing diaeresis - umlaut copyright sign feminine ordinal indicator left double angle quotes not sign soft hyphen registered trade mark sign spacing macron - overline

ASCII			HTML	HTML
Dec	Hex	Symbol	Number	Name	Description
176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191	B0 B1 B2 B3 B4 B5 B6 B7 B8 B9 BA BB BC BD BE BF	° ± ² ³ ´ µ ¶ · ¸ ¹ º » ¼ ½ ¾ ¿	° ± ² ³ ´ µ ¶ · ¸ ¹ º » ¼ ½ ¾ ¿	° ± ² ³ ´ µ ¶ · ¸ ¹ º » ¼ ½ ¾ ¿	degree sign plus-or-minus sign superscript two - squared superscript three - cubed acute accent - spacing acute micro sign pilcrow sign - paragraph sign middle dot - Georgian comma spacing cedilla superscript one masculine ordinal indicator right double angle quotes fraction one quarter fraction one half fraction three quarters inverted question mark

ASCII			HTML	HTML
Dec	Hex	Symbol	Number	Name	Description
192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207	C0 C1 C2 C3 C4 C5 C6 C7 C8 C9 CA CB CC CD CE CF	À Á Â Ã Ä Å Æ Ç È É Ê Ë Ì Í Î Ï	À Á Â Ã Ä Å Æ Ç È É Ê Ë Ì Í Î Ï	À Á Â Ã Ä Å Æ Ç È É Ê Ë Ì Í Î Ï	latin capital letter A with grave latin capital letter A with acute latin capital letter A with circumflex latin capital letter A with tilde latin capital letter A with diaeresis latin capital letter A with ring above latin capital letter AE latin capital letter C with cedilla latin capital letter E with grave latin capital letter E with acute latin capital letter E with circumflex latin capital letter E with diaeresis latin capital letter I with grave latin capital letter I with acute latin capital letter I with circumflex latin capital letter I with diaeresis

ASCII			HTML	HTML
Dec	Hex	Symbol	Number	Name	Description
208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223	D0 D1 D2 D3 D4 D5 D6 D7 D8 D9 DA DB DC DD DE DF	Ð Ñ Ò Ó Ô Õ Ö × Ø Ù Ú Û Ü Ý Þ ß	Ð Ñ Ò Ó Ô Õ Ö × Ø Ù Ú Û Ü Ý Þ ß	Ð Ñ Ò Ó Ô Õ Ö × Ø Ù Ú Û Ü Ý Þ ß	latin capital letter ETH latin capital letter N with tilde latin capital letter O with grave latin capital letter O with acute latin capital letter O with circumflex latin capital letter O with tilde latin capital letter O with diaeresis multiplication sign latin capital letter O with slash latin capital letter U with grave latin capital letter U with acute latin capital letter U with circumflex latin capital letter U with diaeresis latin capital letter Y with acute latin capital letter THORN latin small letter sharp s - ess-zed

ASCII			HTML	HTML
Dec	Hex	Symbol	Number	Name	Description
224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239	E0 E1 E2 E3 E4 E5 E6 E7 E8 E9 EA EB EC ED EE EF	à á â ã ä å æ ç è é ê ë ì í î ï	à á â ã ä å æ ç è é ê ë ì í î ï	à á â ã ä å æ ç è é ê ë ì í î ï	latin small letter a with grave latin small letter a with acute latin small letter a with circumflex latin small letter a with tilde latin small letter a with diaeresis latin small letter a with ring above latin small letter ae latin small letter c with cedilla latin small letter e with grave latin small letter e with acute latin small letter e with circumflex latin small letter e with diaeresis latin small letter i with grave latin small letter i with acute latin small letter i with circumflex latin small letter i with diaeresis

ASCII			HTML	HTML
Dec	Hex	Symbol	Number	Name	Description
240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255	F0 F1 F2 F3 F4 F5 F6 F7 F8 F9 FA FB FC FD FE FF	ð ñ ò ó ô õ ö ÷ ø ù ú û ü ý þ ÿ	ð ñ ò ó ô õ ö ÷ ø ù ú û ü ý þ ÿ	ð ñ ò ó ô õ ö ÷ ø ù ú û ü ý þ ÿ	latin small letter eth latin small letter n with tilde latin small letter o with grave latin small letter o with acute latin small letter o with circumflex latin small letter o with tilde latin small letter o with diaeresis division sign latin small letter o with slash latin small letter u with grave latin small letter u with acute latin small letter u with circumflex latin small letter u with diaeresis latin small letter y with acute latin small letter thorn latin small letter y with diaeresis