[請益] jquery & php
jQuery(document).ready(function(){ $('#maintenance').cascade('#session', {
ajax: { type: "GET", url: 'FinanceReportAction.php',
data: { act: '1', val: $('#session').val() } },
template: function(item) { return "<option value='" + item.Value + "'>"
+ item.Text + "</option>"; },
match: function(selectedValue) { return this.When == selectedValue; }
});});
------------------------------------------------------------------------------------------------------
$list = '[';
switch ($action) {
case '1':
$query = sprintf("SELECT maintenance FROM finance WHERE session=
'$parentId' AND maintenance!='' );
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
$list .= '{\'When\':\'' . $parentId . '\',\'Value\':\'' .
$row["maintenance"] . '\',\'Text\':\'' . $row["maintenance"] . '\'},';
}
break;
}
$list .= ']';
echo $list;
---------------------------------------------------------------------------------------------------------
請問如果要從不同table裡抓不同的欄位出來計算 要怎麼寫呢
用下面方式，感覺行不通
$query = sprintf("SELECT maintenance FROM finance WHERE session= '$parentId'
AND maintenance!='' );
$result = mysql_query($query);
$query2 = sprintf("SELECT roomprice FROM marketing WHERE session= '$parentId'
AND roomprice!='');
$result2 = mysql_query($query2);
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 140.115.227.213
討論串 (同標題文章)
以下文章回應了本文：
完整討論串 (本文為第 1 之 3 篇)：
PHP 近期熱門文章
PTT數位生活區 即時熱門文章
