Here's a link to my ajax javascript file:
http://www.leadingedgeroofing.com/manage/j/ajax.js
On the file that IS WORKING (get_material_containers.php) and writing the option tags, my code looks like this:
Expand|Select|Wrap|Line Numbers
- $container_r = @mysql_query($container_q) OR die ($container_q.'<br /><br />'.mysql_error());
- if (mysql_num_rows($container_r) > 0) {
- echo 'obj.options[obj.options.length] = new Option(\' - select - \',\'\');'."\n";
- while ($container = mysql_fetch_array($container_r)) {
- echo 'obj.options[obj.options.length] = new Option(\''.addslashes(htmlentities($container['material_container'])).'\');'."\n";
- }
- } else {
- echo 'obj.options[obj.options.length] = new Option(\' - select - \',\'\');'."\n";
- }
Expand|Select|Wrap|Line Numbers
- if (mysql_num_rows($warranty_r) > 0) {
- echo 'obj.input = \''.mysql_result($warranty_r,0,'manf_warranty_cost').'\'; // set the value for the hidden input box
- obj2.input = \''.mysql_result($warranty_r,0,'manf_warranty_cost').'\'; // set the value for the disabled input box';
- }
Expand|Select|Wrap|Line Numbers
- var ajax = new Array();
- function getContainerList(materialSel,materialType,containerSel) {
- var material = materialSel.options[materialSel.selectedIndex].value;
- document.getElementById(containerSel).options.length = 0; // Empty the select box
- if(material.length>0){
- var index = ajax.length;
- ajax[index] = new sack();
- ajax[index].requestFile = 'http://www.leadingedgeroofing.com/manage/inc/get_material_containers.php?material_type='+materialType+'&manf_id='+material; // Specifying which file to get
- ajax[index].onCompletion = function(){ createContainers(index,containerSel) }; // Specify function that will be executed after file has been found
- ajax[index].runAJAX(); // Execute AJAX function
- }
- }
- function createContainers(index,containerSel) {
- var obj = document.getElementById(containerSel);
- eval(ajax[index].response); // Executing the response from Ajax as Javascript code
- }
- function getWarrantyCost(materialSel,warrantyCost) {
- var material = materialSel.options[materialSel.selectedIndex].value;
- document.getElementById(warrantyCost).value = ''; // Empty the hidden input box
- document.getElementById(warrantyCost + '-disabled').value = ''; // Empty the 'disabled' input box
- if(material.length>0){
- var index = ajax.length;
- ajax[index] = new sack();
- ajax[index].requestFile = 'http://www.leadingedgeroofing.com/manage/inc/get_manufacterer_warranty.php?manf_id='+material; // Specifying which file to get
- ajax[index].onCompletion = function(){ createWarrantyCost(index,warrantyCost) }; // Specify function that will be executed after file has been found
- ajax[index].runAJAX(); // Execute AJAX function
- }
- }
- function createWarrantyCost(index,warrantyCost) {
- var obj = document.getElementById(warrantyCost);
- var obj2 = document.getElementById(warrantyCost + '-disabled');
- eval(ajax[index].response); // Executing the response from Ajax as Javascript code
- }