|
 |
| |
ช่วยดูโค้ดให้หน่อยน๊าว่าส่วนที่เพิ่มเติมไปนี้ผิดยังไง (เอาโค้ด คุณWeerachai มาต่อเติมค่ะ) |
| |
 |
|
|
 |
 |
|
ช่วยดูโค้ดให้หน่อยน๊าว่าส่วนที่เพิ่มเติมไปนี้ผิดยังไง (เอาโค้ด คุณWeerachai มาต่อเติมค่ะ)
สำหรับฐานข้อมูล
ต้องการให้ผลลัพท์หมวดหมู่ย่อย ที่ list สุดท้าย แสดงออกมาถูกต้องนะคะ ตอนนี้ยังผิดอยู่ ก็เลย เพิ่มฟังชั่นขึ้นมาเองค่ะ มันเลย error
function ListCategory03(SelectValue) อันนี้ค่ะ
Code (PHP)
<?php
$objConnect = mysql_connect("localhost","root","peenuj") or die("Error Connect to Database");
$objDB = mysql_select_db("swapmeet");
@mysql_query("SET NAMES UTF8");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>กรุณาเลือกหมวดหมู่ให้ถูกต้อง *</title>
<script language = "JavaScript">
/* START CATEGORY 01 */
function ListCategory01(SelectValue)
{
frmMain.list_category01.length = 0
frmMain.list_category02.length = 0
frmMain.list_category03.length = 0
//*** Insert null Default Value ***//
var myOption = new Option('','')
frmMain.list_category01.options[frmMain.list_category01.length]= myOption
<?
$intRows = 0;
$strSQL = "SELECT * FROM category_01 ORDER BY SubCate01_Id ASC ";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
$intRows = 0;
while($objResult = mysql_fetch_array($objQuery))
{
$intRows++;
?>
x = <?=$intRows;?>;
mySubList = new Array();
strGroup = <?=$objResult["CateMain_Id"];?>;
strValue = "<?=$objResult["SubCate01_Id"];?>";
strItem = "<?=$objResult["SubCate01_Name"];?>";
mySubList[x,0] = strItem;
mySubList[x,1] = strGroup;
mySubList[x,2] = strValue;
if (mySubList[x,1] == SelectValue){
var myOption = new Option(mySubList[x,0], mySubList[x,2])
frmMain.list_category01.options[frmMain.list_category01.length]= myOption
}
<?
}
?>
}
/* END CATEGORY 01 */
/* START CATEGORY 02 */
function ListCategory02(SelectValue)
{
frmMain.list_category02.length = 0
frmMain.list_category03.length = 0
//*** Insert null Default Value ***//
var myOption = new Option('','')
frmMain.list_category02.options[frmMain.list_category02.length]= myOption
<?
$intRows = 0;
$strSQL = "SELECT * FROM category_02 ORDER BY SubCate02_Id ASC";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
$intRows = 0;
while($objResult = mysql_fetch_array($objQuery))
{
$intRows++;
?>
x = <?=$intRows;?>;
mySubList = new Array();
strGroup = <?=$objResult["SubCate01_Id"];?>;
strValue = "<?=$objResult["SubCate02_Id"];?>";
strItem = "<?=$objResult["SubCate02_Name"];?>";
mySubList[x,0] = strItem;
mySubList[x,1] = strGroup;
mySubList[x,2] = strValue;
if (mySubList[x,1] == SelectValue){
var myOption = new Option(mySubList[x,0], mySubList[x,2])
frmMain.list_category02.options[frmMain.list_category02.length]= myOption
}
<?
}
?>
}
/* END CATEGORY 02 */
//ส่วนที่เพิ่มเติมเองค่ะ คิดว่าน่าจะเออเร่อส่วนนี้ค่ะ
/* START CATEGORY 03 */
function ListCategory03(SelectValue)
{
frmMain.list_category03.length = 0
//*** Insert null Default Value ***//
var myOption = new Option('','')
frmMain.list_category03.options[frmMain.list_category03.length]= myOption
<?
$intRows = 0;
$strSQL = "SELECT * FROM category_03 ORDER BY SubCate03_Id ASC";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
$intRows = 0;
while($objResult = mysql_fetch_array($objQuery))
{
$intRows++;
?>
x = <?=$intRows;?>;
mySubList = new Array();
strGroup1 = <?=$objResult["SubCate01_id"];?>;
strGroup2 = <?=$objResult["SubCate02_id"];?>;
strValue = "<?=$objResult["SubCate03_id"];?>";
strItem = "<?=$objResult["SubCate03_Name"];?>";
mySubList[x,0] = strItem;
mySubList[x,1] = strValue;
mySubList[x,2] = strGroup1;
mySubList[x,3] = strGroup2;
if ((mySubList[x,2] == SelectValue) || (mySubList[x,3] == SelectValue)) {
var myOption = new Option(mySubList[x,0], mySubList[x,1])
frmMain.list_category03.options[frmMain.list_category03.length]= myOption
}
<?
}
?>
}
/* END CATEGORY 03 */
</script>
<style type="text/css">
<!--
body {
background-image: url();
}
-->
</style>
</head>
<body>
<table width="750" border="0" cellspacing="0" cellpadding="0">
<tr>
<th width="750" bgcolor="#FFFFFF" scope="row"><p><img src="Images/text-plscorrectselectcate.jpg" width="244" height="28" /></p>
<form name="frmMain" method="post" action="">
<table width="750" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><div align="center">
<!-- LIST CATEMAIN -->
<select name="list_catemain" size="9" style="width:150px" id="list_catemain" onchange = "ListCategory01(this.value)">
<option value="" selected="selected"></option>
<?
$strSQL = "SELECT * FROM category_main ORDER BY catemain_id ASC ";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
while($objResult = mysql_fetch_array($objQuery))
{
?>
<option value="<?=$objResult["catemain_id"];?>">
<?=$objResult["catemain_name"];?>
</option>
<?
}
?>
</select>
</div></td>
<!-- LIST 1 -->
<td><div align="center">
<select name="list_category01" size="9" id="list_category01" style="width:200px"
onChange = "ListCategory02(this.value)">
</select>
</div>
</td>
<!-- LIST 2 -->
<td>
<select name="list_category02" size="9" style="width:200px" id="list_category02"
onChange = "ListCategory03(this.value)">
</select></td>
<!-- LIST 3 -->
<td><div align="center">
<select name="list_category03" size="9" style="width:200px" id="list_category03">
</select>
</div>
</td>
</table>
<img src="Images/button_selectcate-confirm.jpg" onclick="setValue()"/>
<script language="javascript">
function setValue()
{
var text1 = document.getElementById("list_catemain").options[document.getElementById('list_catemain').selectedIndex].text;
var text2 = document.getElementById("list_category01").options[document.getElementById('list_category01').selectedIndex].text;
var text3 = document.getElementById("list_category02").options[document.getElementById('list_category02').selectedIndex].text;
var text4 = document.getElementById("list_category03").options[document.getElementById('list_category03').selectedIndex].text;
text_from_popup = text1+">"+text2+">"+text3+">"+text4; // create new text from three selected option
textbox_mainpage = window.opener.document.getElementById("resultcate"); // create new var from main page textbox object prepare for set value
textbox_mainpage.value = text_from_popup; // set value from popup to main page textbox
window.close(); // close this popup
}
</script>
</form>
</th>
</tr>
</table>
</body>
</html>
<?
mysql_close($objConnect);
?>
ขอบคุณทุกคำตอบค่ะ
Tag : - - - -
|
|
|
 |
 |
 |
 |
| Date :
2009-12-27 19:58:09 |
By :
unzeen |
View :
991 |
Reply :
15 |
|
 |
 |
 |
 |
|
|
|
|
 |
 |
|
 |
 |
| |
|
|
|
| |
|
โค้ออาจจะยาว ไม่ต้องดูหมดก็ได้นะคะ ดูเฉพาะ ฟังชั่น function ListCategory03(SelectValue) อันนี้ ก็ได้ค่ะ
เพราะคิดว่าน่าจะผิดตรงนี้ค่ะ
|
| |
|
|
| |
| Date :
2009-12-27 19:59:49 |
By :
unzeen |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
 
|
| |
|
|
| |
| Date :
2009-12-27 21:30:31 |
By :
unzeen |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
ความเป็นไปได้น่ะครับ น่าจะมาจาก
x = <?=$intRows;?>;
และการใส่ php ใน javascript แบบนี้ทุกอันเลยครับ
เพราะว่าถ้า $intRows ไม่มีค่าขึ้นมา ผลจะได้ดังนี้
x=; <--- error syntax ครับ ใส่ " คุมไว้ด้วยครับกันไว้อีกทางหนึ่ง
x="<?=$intRows; ?>";
ใส่ให้หมดเลยน่ะครับ ถ้าไม่ได้ส่งโค้ดมาอีกรอบน่ะ เดียวดูให้
|
| |
|
|
| |
| Date :
2009-12-27 22:06:12 |
By :
xbeginner01 |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
ขอบคุณคุณ xbeginner01 มากเลยนะค่ะ
แต่ยังไม่ได้เรยอ่ะค่ะ
Code (PHP)
<?php
$objConnect = mysql_connect("localhost","root","peenuj") or die("Error Connect to Database");
$objDB = mysql_select_db("swapmeet");
@mysql_query("SET NAMES UTF8");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>กรุณาเลือกหมวดหมู่ให้ถูกต้อง *</title>
<script language = "JavaScript">
/* START CATEGORY 01 */
function ListCategory01(SelectValue)
{
frmMain.list_category01.length = 0
frmMain.list_category02.length = 0
frmMain.list_category03.length = 0
//*** Insert null Default Value ***//
var myOption = new Option('','')
frmMain.list_category01.options[frmMain.list_category01.length]= myOption
<?
$intRows = 0;
$strSQL = "SELECT * FROM category_01 ORDER BY SubCate01_Id ASC ";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
$intRows = 0;
while($objResult = mysql_fetch_array($objQuery))
{
$intRows++;
?>
x = "<?=$intRows;?>";
mySubList = new Array();
strGroup = <?=$objResult["CateMain_Id"];?>;
strValue = "<?=$objResult["SubCate01_Id"];?>";
strItem = "<?=$objResult["SubCate01_Name"];?>";
mySubList[x,0] = strItem;
mySubList[x,1] = strGroup;
mySubList[x,2] = strValue;
if (mySubList[x,1] == SelectValue){
var myOption = new Option(mySubList[x,0], mySubList[x,2])
frmMain.list_category01.options[frmMain.list_category01.length]= myOption
}
<?
}
?>
}
/* END CATEGORY 01 */
/* START CATEGORY 02 */
function ListCategory02(SelectValue)
{
frmMain.list_category02.length = 0
frmMain.list_category03.length = 0
//*** Insert null Default Value ***//
var myOption = new Option('','')
frmMain.list_category02.options[frmMain.list_category02.length]= myOption
<?
$intRows = 0;
$strSQL = "SELECT * FROM category_02 ORDER BY SubCate02_Id ASC";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
$intRows = 0;
while($objResult = mysql_fetch_array($objQuery))
{
$intRows++;
?>
x = "<?=$intRows;?>";
mySubList = new Array();
strGroup = <?=$objResult["SubCate01_Id"];?>;
strValue = "<?=$objResult["SubCate02_Id"];?>";
strItem = "<?=$objResult["SubCate02_Name"];?>";
mySubList[x,0] = strItem;
mySubList[x,1] = strGroup;
mySubList[x,2] = strValue;
if (mySubList[x,1] == SelectValue){
var myOption = new Option(mySubList[x,0], mySubList[x,2])
frmMain.list_category02.options[frmMain.list_category02.length]= myOption
}
<?
}
?>
}
/* END CATEGORY 02 */
/* START CATEGORY 03 */
function ListCategory03(SelectValue)
{
frmMain.list_category03.length = 0
//*** Insert null Default Value ***//
var myOption = new Option('','')
frmMain.list_category03.options[frmMain.list_category03.length]= myOption
<?
$intRows = 0;
$strSQL = "SELECT * FROM category_03 ORDER BY SubCate03_Id ASC";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
$intRows = 0;
while($objResult = mysql_fetch_array($objQuery))
{
$intRows++;
?>
x = "<?=$intRows;?>";
mySubList = new Array();
strGroup1 = <?=$objResult["SubCate01_id"];?>;
strGroup2 = <?=$objResult["SubCate02_id"];?>;
strValue = "<?=$objResult["SubCate03_id"];?>";
strItem = "<?=$objResult["SubCate03_Name"];?>";
mySubList[x,0] = strItem;
mySubList[x,1] = strValue;
mySubList[x,2] = strGroup1;
mySubList[x,3] = strGroup2;
if ((mySubList[x,2] == SelectValue) || (mySubList[x,3] == SelectValue)) {
var myOption = new Option(mySubList[x,0], mySubList[x,1])
frmMain.list_category03.options[frmMain.list_category03.length]= myOption
}
<?
}
?>
}
/* END CATEGORY 03 */
</script>
<style type="text/css">
<!--
body {
background-image: url();
}
-->
</style>
</head>
<body>
<table width="750" border="0" cellspacing="0" cellpadding="0">
<tr>
<th width="750" bgcolor="#FFFFFF" scope="row"><p><img src="Images/text-plscorrectselectcate.jpg" width="244" height="28" /></p>
<form name="frmMain" method="post" action="">
<table width="750" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><div align="center">
<!-- LIST CATEMAIN -->
<select name="list_catemain" size="9" style="width:150px" id="list_catemain" onchange = "ListCategory01(this.value)">
<option value="" selected="selected"></option>
<?
$strSQL = "SELECT * FROM category_main ORDER BY catemain_id ASC ";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
while($objResult = mysql_fetch_array($objQuery))
{
?>
<option value="<?=$objResult["catemain_id"];?>">
<?=$objResult["catemain_name"];?>
</option>
<?
}
?>
</select>
</div></td>
<!-- LIST 1 -->
<td><div align="center">
<select name="list_category01" size="9" id="list_category01" style="width:200px"
onChange = "ListCategory02(this.value)">
</select>
</div>
</td>
<!-- LIST 2 -->
<td>
<select name="list_category02" size="9" style="width:200px" id="list_category02"
onChange = "ListCategory03(this.value)">
</select></td>
<!-- LIST 3 -->
<td><div align="center">
<select name="list_category03" size="9" style="width:200px" id="list_category03">
</select>
</div>
</td>
</table>
<img src="Images/button_selectcate-confirm.jpg" onclick="setValue()"/>
<script language="javascript">
function setValue()
{
var text1 = document.getElementById("list_catemain").options[document.getElementById('list_catemain').selectedIndex].text;
var text2 = document.getElementById("list_category01").options[document.getElementById('list_category01').selectedIndex].text;
var text3 = document.getElementById("list_category02").options[document.getElementById('list_category02').selectedIndex].text;
var text4 = document.getElementById("list_category03").options[document.getElementById('list_category03').selectedIndex].text;
text_from_popup = text1+">"+text2+">"+text3+">"+text4; // create new text from three selected option
textbox_mainpage = window.opener.document.getElementById("resultcate"); // create new var from main page textbox object prepare for set value
textbox_mainpage.value = text_from_popup; // set value from popup to main page textbox
window.close(); // close this popup
}
</script>
</form>
</th>
</tr>
</table>
</body>
</html>
<?
mysql_close($objConnect);
?>
มันแจ้ง error page เหมือนเดิมค่ะ
ลอง view source ดูแล้ว
ตรง
function ListCategory03(SelectValue)
มัน เออเร่อ บันทัดนี้ค่ะ
strGroup1 = ;
|
| |
|
|
| |
| Date :
2009-12-27 22:48:00 |
By :
unzeen |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
ยังใส่คุมไม่หมดเลยครับ
trGroup = <?=$objResult["SubCate01_Id"];?>; กรณีเดียวกันครับ
ถ้า $objResult["SubCate01_Id"] ไม่มีค่า ผลทีได้คือ
trGroup =; < syntax error ครับ
ใส่ให้หมดๆ ๆ ๆ ๆ
strGroup1
strGroup2
สองตัวแปรนี้ด้วยครับ
|
| |
|
|
| |
| Date :
2009-12-27 23:07:29 |
By :
xbeginner01 |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
งงงง อ่า
(เริ่มเหนทางสว่าง)
|
| |
|
|
| |
| Date :
2009-12-27 23:10:45 |
By :
unzeen |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
ทำยางไงหรอค่ะ ม่ายเข้าใจ
|
| |
|
|
| |
| Date :
2009-12-27 23:25:34 |
By :
unzeen |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
เข้าใจแล้วค่ะ
|
| |
|
|
| |
| Date :
2009-12-27 23:34:56 |
By :
unzeen |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
เย่ได้แล้ววววววววววววววววววว แต่มานออก แค่ 3 ขั้น ขั้นที่ 4 ไม่แสดงไรเรย
ไม่ทราบว่า เงื่อนไข ที่เติมเองนี่ผิดเป่าค่ะ
Code (PHP)
if ((mySubList[x,2] == SelectValue) || (mySubList[x,3] == SelectValue)) {
var myOption = new Option(mySubList[x,0], mySubList[x,1])
frmMain.list_category03.options[frmMain.list_category03.length]= myOption
}
<?
}
?>
}
/* END CATEGORY 03 */
|
| |
|
|
| |
| Date :
2009-12-27 23:37:19 |
By :
unzeen |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
ต้องการเงื่อนไขยังไงครับ อธิบายใหม่ให้ฟังหน่อยครับ
|
| |
|
|
| |
| Date :
2009-12-27 23:53:59 |
By :
xbeginner01 |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
ต้องการอย่างนี้ค่ะ
ตอนนี้ ช่องสุดท้าย ช่องที่ สี่ มานไม่แสดง อ่ะค่ะ
คือ..
ตรงคอลัมภ์ catemain_id ที่ = 1 แล้ว SubCate01_id =2
แล้วลงมาเรื่อยๆ ถึง catemain_id ที่ = 2 SubCate01_id =2
มันเลยทำให้ ส่วนที่มี SubCate01_id = 2 มารวมกัน แต่จริงๆ แล้ว มานต้องไม่แสดงเพราะมานคนละหมวดหมู่กัน เพราะอันนึง catemain_id = 1 อีกอัน = 2 อ่ะค่ะ
เราจึงต้อง มี Group อีกอัน มาช่วยอ้าง
เราจึงเพิ่ม เงื่อนไขตรงนี้นะค่ะ
|
| |
|
|
| |
| Date :
2009-12-28 00:02:39 |
By :
unzeen |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
 รอออ อออ อ อ
|
| |
|
|
| |
| Date :
2009-12-28 00:13:59 |
By :
unzeen |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
เราลองใส่ ตามที่ คุณ xbeginner01 บอกแล้วค่ะ
ผลที่ได้คือ พอเลือกหมวดหมู่ถึงขั้นที่ 3 แล้ว ขั้นที่ 4 ไม่มีขึ้นอะไรเรยค่ะ :(
Code (PHP)
<?php
$objConnect = mysql_connect("localhost","root","peenuj") or die("Error Connect to Database");
$objDB = mysql_select_db("swapmeet");
@mysql_query("SET NAMES UTF8");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>กรุณาเลือกหมวดหมู่ให้ถูกต้อง *</title>
<script language = "JavaScript">
/* START CATEGORY 01 */
function ListCategory01(SelectValue)
{
frmMain.list_category01.length = 0
frmMain.list_category02.length = 0
frmMain.list_category03.length = 0
//*** Insert null Default Value ***//
var myOption = new Option('','')
frmMain.list_category01.options[frmMain.list_category01.length]= myOption
<?
$intRows = 0;
$strSQL = "SELECT * FROM category_01 ORDER BY SubCate01_Id ASC ";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
$intRows = 0;
while($objResult = mysql_fetch_array($objQuery))
{
$intRows++;
?>
x = "<?=$intRows;?>";
mySubList = new Array();
strGroup = <?=$objResult["CateMain_Id"];?>;
strValue = "<?=$objResult["SubCate01_Id"];?>";
strItem = "<?=$objResult["SubCate01_Name"];?>";
mySubList[x,0] = strItem;
mySubList[x,1] = strGroup;
mySubList[x,2] = strValue;
if (mySubList[x,1] == SelectValue){
var myOption = new Option(mySubList[x,0], mySubList[x,2])
frmMain.list_category01.options[frmMain.list_category01.length]= myOption
}
<?
}
?>
}
/* END CATEGORY 01 */
/* START CATEGORY 02 */
function ListCategory02(SelectValue)
{
frmMain.list_category02.length = 0
frmMain.list_category03.length = 0
//*** Insert null Default Value ***//
var myOption = new Option('','')
frmMain.list_category02.options[frmMain.list_category02.length]= myOption
<?
$intRows = 0;
$strSQL = "SELECT * FROM category_02 ORDER BY SubCate02_Id ASC";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
$intRows = 0;
while($objResult = mysql_fetch_array($objQuery))
{
$intRows++;
?>
x = "<?=$intRows;?>";
mySubList = new Array();
strGroup = <?=$objResult["SubCate01_Id"];?>;
strValue = "<?=$objResult["SubCate02_Id"];?>";
strItem = "<?=$objResult["SubCate02_Name"];?>";
mySubList[x,0] = strItem;
mySubList[x,1] = strGroup;
mySubList[x,2] = strValue;
if (mySubList[x,1] == SelectValue){
var myOption = new Option(mySubList[x,0], mySubList[x,2])
frmMain.list_category02.options[frmMain.list_category02.length]= myOption
}
<?
}
?>
}
/* END CATEGORY 02 */
/* START CATEGORY 03 */
function ListCategory03(SelectValue)
{
frmMain.list_category03.length = 0
//*** Insert null Default Value ***//
var myOption = new Option('','')
frmMain.list_category03.options[frmMain.list_category03.length]= myOption
<?
$intRows = 0;
$strSQL = "SELECT * FROM category_03 ORDER BY SubCate03_Id ASC";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
$intRows = 0;
while($objResult = mysql_fetch_array($objQuery))
{
$intRows++;
?>
x = "<?=$intRows;?>";
mySubList = new Array();
strGroup1 = "<?=$objResult["SubCate01_id"];?>";
strGroup2 = "<?=$objResult["SubCate02_id"];?>";
strValue = "<?=$objResult["SubCate03_id"];?>";
strItem = "<?=$objResult["SubCate03_Name"];?>";
mySubList[x,0] = strItem;
mySubList[x,1] = strValue;
mySubList[x,2] = strGroup1;
mySubList[x,3] = strGroup2;
var category01 =document.getElementById('list_category01');
var category01Value=category01.options[category01.selectedIndex].value;
if((mySubList[x,2] == SelectValue && mySubList[x,3]==category01Value )){
var myOption = new Option(mySubList[x,0], mySubList[x,1])
frmMain.list_category03.options[frmMain.list_category03.length]= myOption
}
<?
}
?>
}
/* END CATEGORY 03 */
</script>
<style type="text/css">
<!--
body {
background-image: url();
}
-->
</style>
</head>
<body>
<table width="750" border="0" cellspacing="0" cellpadding="0">
<tr>
<th width="750" bgcolor="#FFFFFF" scope="row"><p><img src="Images/text-plscorrectselectcate.jpg" width="244" height="28" /></p>
<form name="frmMain" method="post" action="">
<table width="750" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><div align="center">
<!-- LIST CATEMAIN -->
<select name="list_catemain" size="9" style="width:150px" id="list_catemain" onchange = "ListCategory01(this.value)">
<option value="" selected="selected"></option>
<?
$strSQL = "SELECT * FROM category_main ORDER BY catemain_id ASC ";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
while($objResult = mysql_fetch_array($objQuery))
{
?>
<option value="<?=$objResult["catemain_id"];?>">
<?=$objResult["catemain_name"];?>
</option>
<?
}
?>
</select>
</div></td>
<!-- LIST 1 -->
<td><div align="center">
<select name="list_category01" size="9" id="list_category01" style="width:200px"
onChange = "ListCategory02(this.value)">
</select>
</div>
</td>
<!-- LIST 2 -->
<td>
<select name="list_category02" size="9" style="width:200px" id="list_category02"
onChange = "ListCategory03(this.value)">
</select></td>
<!-- LIST 3 -->
<td><div align="center">
<select name="list_category03" size="9" style="width:200px" id="list_category03">
</select>
</div>
</td>
</table>
<img src="Images/button_selectcate-confirm.jpg" onclick="setValue()"/>
<script language="javascript">
function setValue()
{
var text1 = document.getElementById("list_catemain").options[document.getElementById('list_catemain').selectedIndex].text;
var text2 = document.getElementById("list_category01").options[document.getElementById('list_category01').selectedIndex].text;
var text3 = document.getElementById("list_category02").options[document.getElementById('list_category02').selectedIndex].text;
var text4 = document.getElementById("list_category03").options[document.getElementById('list_category03').selectedIndex].text;
text_from_popup = text1+">"+text2+">"+text3+">"+text4; // create new text from three selected option
textbox_mainpage = window.opener.document.getElementById("resultcate"); // create new var from main page textbox object prepare for set value
textbox_mainpage.value = text_from_popup; // set value from popup to main page textbox
window.close(); // close this popup
}
</script>
</form>
</th>
</tr>
</table>
</body>
</html>
<?
mysql_close($objConnect);
?>
|
| |
|
|
| |
| Date :
2009-12-28 15:11:15 |
By :
unzeen |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
ลองแก้ ตรงที่เหมือนกับบรรทัด "<?=$objResult["SubCate01_id"];?>";เป็น "<?=$objResult['SubCate01_id'];?>"; ดูครับ
|
| |
|
|
| |
| Date :
2009-12-29 01:09:57 |
By :
test |
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
| |
|
 Load balance : Server 01
|
