Javascript - get data from db on form fill x 2

Hello,

Well it is just a simple form:

<label>Email Address<span style="color:#F50">*</span><br />
<input type="text" class="input2" name="userId" id="clientID" value="" /></label><br /><br />

and the new one is

<label>Zip Code<span style="color:#F50">*</span><br />
<input type="text" class="input2" name="zip" id="zipCode" value="" /></label><br /><br />

The PHP for the clientID is:

<?php
/* Replace the data in these two lines with data for your db connection */
include ('db.php');

if(isset($_GET['getClientId'])){  
  $res = mysql_query("select * from members where userId='".$_GET['getClientId']."'") or die(mysql_error());
  if($inf = mysql_fetch_array($res)){
    echo "formObj.firstname.value = '".$inf["firstname"]."';\n";    
    echo "formObj.lastname.value = '".$inf["lastname"]."';\n";    
    echo "formObj.phonenumber.value = '".$inf["phonenumber"]."';\n";    
    echo "formObj.phonenumberext.value = '".$inf["phonenumberext"]."';\n";    
    echo "formObj.brokeredby.value = '".$inf["brokeredby"]."';\n";    
   
  }else{
    echo "formObj.firstname.value = '';\n";    
    echo "formObj.lastname.value = '';\n";    
    echo "formObj.phonenumber.value = '';\n";    
    echo "formObj.phonenumberext.value = '';\n";    
    echo "formObj.brokeredby.value = '';\n";        
  }    
}
?>

Hello again,

Below is the code I am using, they both work great unless they are on the same page, can someone please tell me what needs to be changed to let them work on the same form together.

I am assuming that I am erroring out the first one because of a call on the second one but I do not know enough about java to know what it is.

<script type="text/javascript">
	/************************************************************************************************************
	Ajax client lookup
	Copyright (C) 2006  DTHMLGoodies.com, Alf Magne Kalleland
	
	This library is free software; you can redistribute it and/or
	modify it under the terms of the GNU Lesser General Public
	License as published by the Free Software Foundation; either
	version 2.1 of the License, or (at your option) any later version.
	
	This library is distributed in the hope that it will be useful,
	but WITHOUT ANY WARRANTY; without even the implied warranty of
	MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
	Lesser General Public License for more details.
	
	You should have received a copy of the GNU Lesser General Public
	License along with this library; if not, write to the Free Software
	Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301  USA
	
	Dhtmlgoodies.com., hereby disclaims all copyright interest in this script
	written by Alf Magne Kalleland.
	
	Alf Magne Kalleland, 2006
	Owner of DHTMLgoodies.com
	
	
	************************************************************************************************************/	
	var ajax = new sack();
	var currentClientID=false;
	function getClientData()
	{
		var clientId = document.getElementById('clientID').value;
		if(clientId!=currentClientID){
			currentClientID = clientId
			ajax.requestFile = 'getClient.php?getClientId='+clientId;	// Specifying which file to get
			ajax.onCompletion = showClientData;	// Specify function that will be executed after file has been found
			ajax.runAJAX();		// Execute AJAX function			
		}
		
	}
	
	function showClientData()
	{
		var formObj = document.forms['clientForm'];	
		eval(ajax.response);
	}
	
	
	function initFormEvents()
	{
		document.getElementById('clientID').onkeyup = getClientData; // If you wish to have a lookup "as you type"
	}
	
	
	window.onload = initFormEvents;
	</script>
	<script type="text/javascript">
	
	var ajax = new sack();
	var currentZipID=false;
	function getZipData()
	{
		var zipId = document.getElementById('zipID').value;
		if(zipId!=currentZipID){
			currentZipID = zipId
			ajax.requestFile = 'getClient.php?getZipId='+zipId;	// Specifying which file to get
			ajax.onCompletion = showZipData;	// Specify function that will be executed after file has been found
			ajax.runAJAX();		// Execute AJAX function			
		}
		
	}
	
	function showZipData()
	{
		var formObj = document.forms['clientForm'];	
		eval(ajax.response);
	}
	
	
	function initFormEvents()
	{
		document.getElementById('zipID').onkeyup = getZipData; // If you wish to have a lookup "as you type"
	}
	
	
	window.onload = initFormEvents;
	</script>

Select all Open in new window

Hello,

It sounds like you know what you have a great idea how to fix this but it is hard for me to read what your saying and understand how to translate it to the code.

Could you please show me, I would really appreciate it, it has been a 24 ordeal.

Thanks for all of your great help.