stock/monthly_price_higher.html:$result = mysql_query("SELECT MAX(Date) FROM t_stock", $DBConnect); stock/monthly_price_higher.html: $result = mysql_query("SELECT StockCode, StockName, COUNT(*) AS C FROM `t_stock` WHERE Date > '$CheckTime' AND DaebiChar = '¡è' GROUP BY StockCode ORDER BY C DESC LIMIT 60"); stock/daily_price_higher.html:$result = mysql_query("SELECT MAX(Date) FROM t_stock", $DBConnect); stock/daily_price_higher.html: $result = mysql_query("SELECT Date, StockCode, StockName, EndMoney, DaebiPer FROM `t_stock` WHERE Date > '$CheckTime' AND DaebiChar = '¡è' ORDER BY Date DESC, StockName ASC"); stock/daily_price_higher.html: // $result = mysql_query("SELECT Date, StockCode, StockName, EndMoney, DaebiPer FROM `t_stock` LIMIT 10"); stock/daily_price_higher.html: $SubResult = mysql_query("SELECT Date, EndMoney, DaebiPer FROM `t_stock` WHERE StockCode = '$Row[StockCode]' AND Date < '$Date' ORDER BY Date DESC LIMIT 1"); stock/daily_price_higher.html: $SubResult = mysql_query("SELECT Date, EndMoney, DaebiPer FROM `t_stock` WHERE StockCode = '$Row[StockCode]' AND Date > '$Date' ORDER BY Date DESC LIMIT 1"); stock/year_price_higher.html:$result = mysql_query("SELECT MAX(Date) FROM t_stock", $DBConnect); stock/year_price_higher.html: // $result = mysql_query("SELECT StockCode, StockName, COUNT(*) AS C FROM `t_stock` WHERE DaebiPer > 14 AND Date > \"2007.08.01\" GROUP BY StockCode ORDER BY C DESC", $DBConnect); stock/year_price_higher.html: $result = mysql_query("SELECT StockCode, StockName, COUNT(*) AS C FROM `t_stock` WHERE DaebiChar = '¡è' GROUP BY StockCode ORDER BY C DESC LIMIT 100"); stock/price_higher_simulate_1.html: // $result = mysql_query("SELECT StockCode, StockName FROM `t_stock` WHERE Date > '2007.08.01' AND StockCode = '023790' GROUP BY StockCode ORDER BY StockCode"); stock/price_higher_simulate_1.html: // $result = mysql_query("SELECT StockCode, StockName FROM `t_stock` WHERE Date > '2007.08.01' GROUP BY StockCode ORDER BY StockCode"); stock/price_higher_simulate_1.html: $result = mysql_query("SELECT StockCode, StockName FROM `t_stock` WHERE Date > '2007.08.01' GROUP BY StockCode ORDER BY StockCode LIMIT 100"); stock/price_higher_simulate_1.html: // Write2("SELECT Date, StartMoney, EndMoney, LowMoney, HighMoney, DaebiPer FROM `t_stock` WHERE StockCode = '$StockCodeList[$i]' AND Date > '2007.08.01' ORDER BY Date
"); stock/price_higher_simulate_1.html: $result = mysql_query("SELECT Date, StartMoney, EndMoney, LowMoney, HighMoney, DaebiPer FROM `t_stock` WHERE StockCode = '$StockCodeList[$i]' AND Date > '2007.08.01' ORDER BY Date LIMIT 50"); stock/insert_stock_analyzer.html:echo "query - "."INSERT INTO t_stock (UniqueVar, StockCode, StockName, Date, StartMoney, EndMoney, HighMoney, LowMoney, Many, DaebiChar, DaebiMoney, DaebiPer) VALUES ".$Q."
"; stock/insert_stock_analyzer.html:$result = mysql_query("INSERT INTO t_stock (UniqueVar, StockCode, StockName, Date, StartMoney, EndMoney, HighMoney, LowMoney, Many, DaebiChar, DaebiMoney, DaebiPer) VALUES ".$Q, $DBConnect); stock/daily_price_lower.html:$result = mysql_query("SELECT MAX(Date) FROM t_stock", $DBConnect); stock/daily_price_lower.html: $result = mysql_query("SELECT Date, StockCode, StockName, EndMoney, DaebiPer FROM `t_stock` WHERE Date > '$CheckTime' AND DaebiChar = '¡é' ORDER BY Date DESC, StockName ASC"); stock/daily_price_lower.html: $SubResult = mysql_query("SELECT Date, EndMoney, DaebiPer FROM `t_stock` WHERE StockCode = '$Row[StockCode]' AND Date < '$Date' ORDER BY Date DESC LIMIT 1"); stock/daily_price_lower.html: $SubResult = mysql_query("SELECT Date, EndMoney, DaebiPer FROM `t_stock` WHERE StockCode = '$Row[StockCode]' AND Date > '$Date' ORDER BY Date DESC LIMIT 1");