<select name="jenama" size="1" id="brand" onChange="auto_select()">
</select> | <select name="model" size="1" id="model" style="width:150px"></select>
<script language="javascript">
navigator.appName;
var arr = new Array();
arr[0] = new Array("HP","HP1234","HPDV5228TX","HPDV2001TX");
arr[1] = new Array("ASUS","A8H","F3S");
arr[2] = new Array("ACER","Aspire4530","Aspire4935","Aspire3810T","TravelMate6493");
var IE = false;
var FF = false;
if (navigator.appName.indexOf("Microsoft") == 0) {
IE = true;
} else if (navigator.appName.indexOf("Netscape") == 0) {
FF = true;
}
function auto_select() {
while(document.getElementById("model").length > 0) {
document.getElementById("model").remove(0);
}
var si = document.getElementById("brand").selectedIndex;
if (FF) {
for (i = 1; i < arr[si].length; i++) {
document.getElementById("model").add(new Option(arr[si][i],arr[si][i]),null);
}
} else {
var newOption;
for (i = 0; i < arr[si].length; i++) {
newOption = document.createElement("option");
newOption.text = newOption.value = arr[si][i];
document.getElementById("model").add(newOption);
}
}
}
function initial() {
if (FF) {
for (i = 0; i < arr.length; i++) {
document.getElementById("brand").add(new Option(arr[i][0],arr[i][0]),null);
}
} else {
var newOption;
for (i = 0; i < arr.length; i++) {
newOption = document.createElement("option");
newOption.text = newOption.value = arr[i][0];
document.getElementById("brand").add(newOption);
}
}
document.getElementById("brand").options[0].selected = true;
}
initial();
auto_select();
</script>


i want to update data in sql that have list menu that are using javascript code..how can i display the original data in the list menu before update??how to combine with php code??

learn ajax/jquery.

not a very good advice indeed...
learning ajax/jquery dosent make u a better javascript programmer
instead learn javascript..than move on to javascript library

refer mozilla javascript reference https://developer.mozilla.org/en/JavaScript

and dude pls put your code in [code] tag and please make ur code readable by indenting it

This post has been edited by slier81: May 24 2009, 12:08 PM

I'm a jquery programmer, jquery has some disadvantage than javascript, For example, if you use $('#blah').html('a') a few more times, it will leak all your user's memory. However if you use document.getElementById('blah').innerHTML = 'a'; , your memory usage is constant at that level. It's because jquery convert the 'a' into DOM object, but the pure javascript just append it directly. Otherwise, it's good because I have to write lesser with jquery

Change this

into this betweenvar arr = new Array();, and var IE = false;

This is not a recommended way of doing database query. If you have 100 brands you are going to query the database 100 times.


I wonder why the need to detect Netscape. Anyone still using Netscape?

Here's a revamped code that should work on IE, Firefox, Opera, Chrome and Safari. I don't have Netscape to test this.


This post has been edited by nyem: May 25 2009, 10:20 AM

You're right for this, nyem.

$rs_brand = mysql_query("SELECT `brandId`,`brandName` FROM `brand`");
while ($row0 = mysql_fetch_array($rs_brand)) {
$rs_model = mysql_query(sprintf("SELECT `modelId`,`modelName` FROM `model` WHERE `brandId` = '%u'",$row0[0]));
while ($row1 = mysql_fetch_array($rs_model)) {
...
}
}
}


what can i do with this code??