AJAX

display details from drop down list

Please support our JavaScript / DHTML / AJAX advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: May 2008

Posts: 1

Reputation: syud_zack is an unknown quantity at this point

Solved Threads: 0

syud_zack

Offline

Newbie Poster

display details from drop down list

Jun 2nd, 2008

hi all

i have several drop down list. the first 2 drop down list, works fine.

i have the problem when i want to display the data that has been selected from second drop down list into textbox..let say in the second drop down list, i choose rider_name : "Nabil Ismail", the next column which textbox, will display the phone number of the rider.

here parts of my code

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
<--form page (entryform2.php) -->
 
<?php include('db_connect.php'); ?>
<script language="javascript" type="text/javascript">
function getXMLHTTP() { //fuction to return the xml http object
		var xmlhttp=false;	
		try{
			xmlhttp=new XMLHttpRequest();
		}
		catch(e)	{		
			try{			
				xmlhttp= new ActiveXObject("Microsoft.XMLHTTP");
			}
			catch(e){
				try{
				req = new ActiveXObject("Msxml2.XMLHTTP");
				}
				catch(e1){
					xmlhttp=false;
				}
			}
		}
 
		return xmlhttp;
    }
 
	function getRider(club_name){		
 
		var strURL="findRider2.php?club="+club_name;
		var req = getXMLHTTP();
 
		if (req) {
 
			req.onreadystatechange = function() {
				if (req.readyState == 4) {
					// only if "OK"
					if (req.status == 200) {						
						document.getElementById('riderdiv').innerHTML=req.responseText;						
					} else {
						alert("There was a problem while using XMLHTTP:\n" + req.statusText);
					}
				}				
			}			
			req.open("GET", strURL, true);
			req.send(null);
		}		
	}
 
	function getRiderPhoneNumber(club_name,rider_name){		
 
		var strURL="findRiderPhoneNumber.php?club="+club_name+"&rider="+rider_name;
 
		var req = getXMLHTTP();
 
		if (req) {
 
			req.onreadystatechange = function() {
				if (req.readyState == 4) {
					// only if "OK"
					if (req.status == 200) {						
						document.getElementById('riderPhoneNumberdiv').innerHTML=req.responseText;						
					} else {
						alert("There was a problem while using XMLHTTP:\n" + req.statusText);
					}
				}				
			}			
			req.open("GET", strURL, true);
			req.send(null);
		}		
	}
 
function getHorse(owner_name){		
 
		var strURL="findHorse.php?owner="+owner_name;
		var req = getXMLHTTP();
 
		if (req) {
 
			req.onreadystatechange = function() {
				if (req.readyState == 4) {
					// only if "OK"
					if (req.status == 200) {						
						document.getElementById('horsediv').innerHTML=req.responseText;						
					} else {
						alert("There was a problem while using XMLHTTP:\n" + req.statusText);
					}
				}				
			}			
			req.open("GET", strURL, true);
			req.send(null);
		}		
	}
</script>
<script src="Scripts/AC_RunActiveContent.js" type="text/javascript"></script>
<script type="text/javascript">
<!--
function MM_openBrWindow(theURL,winName,features) { //v2.0
  window.open(theURL,winName,features);
}
//-->
</script>
</head>
 
<body>
<p>&nbsp;</p>
<table width="722" height="715" border="0" align="center" bordercolor="#04571a" bgcolor="#7DB04F">
  <tr height="107">
    <td><p>&nbsp;</p>
        <table width="385" border="0" align="center">
          <tr>
            <th width="125" scope="col"><div align="center"><img src="/epsb/logo_3qclassic2008.gif" alt="3qe" width="90" height="90" /></div></th>
            <th width="44" scope="col"><div align="left"></div></th>
            <th width="194" scope="col"><div align="center"><img src="/epsb/logo_epsb.gif" alt="epsb" width="180" height="90" /></div></th>
          </tr>
      </table></td>
  </tr>
  <tr>
    <td valign="center" align="middle"><p>&nbsp;</p>
        <p align="center"><font size="5"><strong><span class="style21">3QE CLASSIC 2008 <br />
          EQUESTRIAN COMPETITION<br />
          <font size="4">10 - 13 JULY 2008</font></span></strong></font></p></td>
  </tr>
  <tr>
    <td><table width="200" border="0" align="center" bgcolor="#2ED861">
      <tr>
        <td><span class="style1 style22"><strong>.:: NEW ENTRY FORM ::.</strong></span></td>
      </tr>
    </table></td>
  </tr>
  <tr>
    <td><table width="161" height="42" border="0" align="right">
      <tr>
        <th width="158" scope="row"><div align="left">
          <script type="text/javascript">
AC_FL_RunContent( 'codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0','width','155','height','30','src','button22','quality','high','pluginspage','http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash','bgcolor','#7DB04F','movie','button22' ); //end AC code
                  </script>
          <noscript>
            <object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0" width="155" height="30">
              <param name="BGCOLOR" value="#7DB04F" />
              <param name="movie" value="button22.swf" />
              <param name="quality" value="high" />
              <embed src="button22.swf" width="155" height="30" quality="high" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" bgcolor="#7DB04F" ></embed>
            </object>
            </noscript>
        </div></th>
      </tr>
    </table></td>
  </tr>
  <tr height="248">
    <!-- Row 1 -->
    <td height="449"><form id="form1" name="form1" method="post" action="">
      <table width="600" border="1" align="center" cellpadding="6" cellspacing="0" bordercolor="#C6BF93">
        <tr>
          <td width="205" bgcolor="#FFFFFF"><div align="right" class="style10 style25"><span class="style7">CLUB/COUNTRY</span></div></td>
          <td width="379" bgcolor="#C2F1BC"><select name="club" onChange="getRider(this.value)">
	<option value="">Select Club</option>
	<? 
			  mysql_select_db($database_link, $link);
			  $query_club = "SELECT * FROM club order by club_name ASC";
			  $club = mysql_query($query_club, $link) or die(mysql_error());
			  $row_club = mysql_fetch_assoc($club);
			  $totalRows_club = mysql_num_rows($club);
 
			  ?>
              <?php
do {  
?>
              <option value="<?php echo $row_club['club_name']?>"><?php echo $row_club['club_name']?></option>
              <?php
} while ($row_club = mysql_fetch_assoc($club));
  $rows = mysql_num_rows($club);
  if($rows > 0) {
      mysql_data_seek($club, 0);
	  $row_club = mysql_fetch_assoc($club);
  }
?>      
        </select>
              <a href="add_club1.php">Add New Club</a></td>
        </tr>
        <tr>
          <td bgcolor="#FFFFFF"><div align="right" class="style26"><span class="style7">NAME OF RIDER</span></div></td>
          <td bgcolor="#C2F1BC"><div id="riderdiv"><select name="rider" id="rider">
            <option>Select Club First</option>
          </select>
              <a href="add_rider1.php">Add New Rider </a>&nbsp;</div></td>
        </tr>
        <tr>
          <td bgcolor="#FFFFFF"><div align="right" class="style26"><span class="style7">RIDER CONTACT NO.</span></div></td>
          <td bgcolor="#C2F1BC"><div id="riderPhoneNumberdiv"><input name="riderPhoneNumber" type="text" id="riderPhoneNumber" /></div></td>
        </tr>
        <tr>
          <td bgcolor="#FFFFFF"><div align="right" class="style26"><span class="style7">OWNER NAME</span></div></td>
          <td bgcolor="#C2F1BC"><select name="owner" id="owner" onchange="getHorse(this.value)">
            <option value="">Select Owner</option>
            <? 
			  mysql_select_db($epsb, $link);
$query_owner = "SELECT * FROM owners order by owner_name ASC";
$owner = mysql_query($query_owner, $link) or die(mysql_error());
$row_owner = mysql_fetch_assoc($owner);
$totalRows_owner = mysql_num_rows($owner);
 
?>
            <?php
do {  
?>
            <option value="<?php echo $row_owner['owner_name']?>"><?php echo $row_owner['owner_name']?></option>
            <?php
} while ($row_owner = mysql_fetch_assoc($owner));
  $rows = mysql_num_rows($owner);
  if($rows > 0) {
      mysql_data_seek($owner, 0);
	  $row_owner = mysql_fetch_assoc($owner);
  }
?>
          </select>
              <a href="add_owner1.php"> Add Owner</a></td>
        </tr>
        <tr>
          <td bgcolor="#FFFFFF"><div align="right" class="style26"><span class="style7">NAME OF HORSE</span></div></td>
          <td bgcolor="#C2F1BC"><div id="horsediv"><select name="horse" id="horse" >
            <option value="">Select Owner First</option>
          </select>
              <a href="add_horse1.php"> Add New Horse</a></div></td>
        </tr>
        <tr>
          <td bgcolor="#FFFFFF"><div align="right" class="style26"><span class="style7">HORSE NO</span></div></td>
          <td bgcolor="#C2F1BC"><input name="horseno" type="text" id="horseno" size="50" maxlength="10" /></td>
        </tr>
        <tr>
          <td height="38" valign="top" bgcolor="#FFFFFF"><div align="right" class="style26"><span class="style7">CLASS ENTRY</span></div></td>
          <td valign="top" bgcolor="#C2F1BC"><p>
            <input name="addrider2" type="button" id="addrider2" onclick="MM_openBrWindow('participantClass.php?ownerid=<?=$owner2?>','addrider','width=600,height=400')" value="Class Entered" />
            &nbsp;</p>
                <table border="1">
                  <? 
 $query_class = "SELECT * FROM class_details "; 
$class = mysql_query($query_class) or die(mysql_error()); 
$row_class = mysql_fetch_array($class); 
$totalRows_class = mysql_num_rows($class); 
 ?>
                  <?php 
$fields = mysql_num_fields($class); 
echo "<tr>\n";// dptkan nama medan 
echo "<td></td>\n"; 
for ($f=0; $f<$fields; $f++) 
{ echo "<td>".mysql_field_name($class,$f)."</td>\n"; } 
echo "</tr>\n"; 
 
do { ?>
                  <tr>
                    <td width="20"><input type="checkbox" name="class_id[]" value="<?php echo $row_class['class_number']; ?>" /></td>
                    <td width="71"><span class="style26"><?php echo $row_class['0']; ?>
                          </div>
                    </span></td>
                    <td width="57"><span class="style26"><?php echo $row_class['1']; ?>
                          </div>
                    </span></td>
                    <td width="64"><span class="style26"><?php echo $row_class['2']; ?>
                          </div>
                    </span></td>
                    <td width="64"><span class="style26"><?php echo $row_class['3']; ?>
                          </div>
                    </span></td>
                    <td width="64"><span class="style26"><?php echo $row_class['4']; ?>
                          </div>
                    </span></td>
                  </tr>
                  <?php } while ($row_class = mysql_fetch_array($class)); ?>
                </table></td>
        </tr>
        <tr bgcolor="#FFFFFF">
          <td height="57" colspan="2" valign="top"><div align="right">
            <input type="submit" name="register" id="register" value="Save" />
            <input type="reset" name="Reset" value="Reset" />
          </div></td>
        </tr>
      </table>
    </form>
        <p align="center"><font color="#008000" face="Arial" 
      size="1"><strong><br />
          </strong></font><font face="Arial" 
      size="1"><strong><span class="style1">Copyright Reserved <br />
            Equestrian Promotion Sdn Bhd</span></strong></font></p></td>
    <!-- Col 1 -->
  </tr>
</table>
</body>
</html>
<--form page (entryform2.php) -->

<?php include('db_connect.php'); ?>
<script language="javascript" type="text/javascript">
function getXMLHTTP() { //fuction to return the xml http object
		var xmlhttp=false;	
		try{
			xmlhttp=new XMLHttpRequest();
		}
		catch(e)	{		
			try{			
				xmlhttp= new ActiveXObject("Microsoft.XMLHTTP");
			}
			catch(e){
				try{
				req = new ActiveXObject("Msxml2.XMLHTTP");
				}
				catch(e1){
					xmlhttp=false;
				}
			}
		}
		 	
		return xmlhttp;
    }
	
	function getRider(club_name){		
		
		var strURL="findRider2.php?club="+club_name;
		var req = getXMLHTTP();
		
		if (req) {
			
			req.onreadystatechange = function() {
				if (req.readyState == 4) {
					// only if "OK"
					if (req.status == 200) {						
						document.getElementById('riderdiv').innerHTML=req.responseText;						
					} else {
						alert("There was a problem while using XMLHTTP:\n" + req.statusText);
					}
				}				
			}			
			req.open("GET", strURL, true);
			req.send(null);
		}		
	}
	
	function getRiderPhoneNumber(club_name,rider_name){		
		
		var strURL="findRiderPhoneNumber.php?club="+club_name+"&rider="+rider_name;

		var req = getXMLHTTP();
		
		if (req) {
			
			req.onreadystatechange = function() {
				if (req.readyState == 4) {
					// only if "OK"
					if (req.status == 200) {						
						document.getElementById('riderPhoneNumberdiv').innerHTML=req.responseText;						
					} else {
						alert("There was a problem while using XMLHTTP:\n" + req.statusText);
					}
				}				
			}			
			req.open("GET", strURL, true);
			req.send(null);
		}		
	}
	
function getHorse(owner_name){		
		
		var strURL="findHorse.php?owner="+owner_name;
		var req = getXMLHTTP();
		
		if (req) {
			
			req.onreadystatechange = function() {
				if (req.readyState == 4) {
					// only if "OK"
					if (req.status == 200) {						
						document.getElementById('horsediv').innerHTML=req.responseText;						
					} else {
						alert("There was a problem while using XMLHTTP:\n" + req.statusText);
					}
				}				
			}			
			req.open("GET", strURL, true);
			req.send(null);
		}		
	}
</script>
<script src="Scripts/AC_RunActiveContent.js" type="text/javascript"></script>
<script type="text/javascript">
<!--
function MM_openBrWindow(theURL,winName,features) { //v2.0
  window.open(theURL,winName,features);
}
//-->
</script>
</head>

<body>
<p>&nbsp;</p>
<table width="722" height="715" border="0" align="center" bordercolor="#04571a" bgcolor="#7DB04F">
  <tr height="107">
    <td><p>&nbsp;</p>
        <table width="385" border="0" align="center">
          <tr>
            <th width="125" scope="col"><div align="center"><img src="/epsb/logo_3qclassic2008.gif" alt="3qe" width="90" height="90" /></div></th>
            <th width="44" scope="col"><div align="left"></div></th>
            <th width="194" scope="col"><div align="center"><img src="/epsb/logo_epsb.gif" alt="epsb" width="180" height="90" /></div></th>
          </tr>
      </table></td>
  </tr>
  <tr>
    <td valign="center" align="middle"><p>&nbsp;</p>
        <p align="center"><font size="5"><strong><span class="style21">3QE CLASSIC 2008 <br />
          EQUESTRIAN COMPETITION<br />
          <font size="4">10 - 13 JULY 2008</font></span></strong></font></p></td>
  </tr>
  <tr>
    <td><table width="200" border="0" align="center" bgcolor="#2ED861">
      <tr>
        <td><span class="style1 style22"><strong>.:: NEW ENTRY FORM ::.</strong></span></td>
      </tr>
    </table></td>
  </tr>
  <tr>
    <td><table width="161" height="42" border="0" align="right">
      <tr>
        <th width="158" scope="row"><div align="left">
          <script type="text/javascript">
AC_FL_RunContent( 'codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0','width','155','height','30','src','button22','quality','high','pluginspage','http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash','bgcolor','#7DB04F','movie','button22' ); //end AC code
                  </script>
          <noscript>
            <object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0" width="155" height="30">
              <param name="BGCOLOR" value="#7DB04F" />
              <param name="movie" value="button22.swf" />
              <param name="quality" value="high" />
              <embed src="button22.swf" width="155" height="30" quality="high" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" bgcolor="#7DB04F" ></embed>
            </object>
            </noscript>
        </div></th>
      </tr>
    </table></td>
  </tr>
  <tr height="248">
    <!-- Row 1 -->
    <td height="449"><form id="form1" name="form1" method="post" action="">
      <table width="600" border="1" align="center" cellpadding="6" cellspacing="0" bordercolor="#C6BF93">
        <tr>
          <td width="205" bgcolor="#FFFFFF"><div align="right" class="style10 style25"><span class="style7">CLUB/COUNTRY</span></div></td>
          <td width="379" bgcolor="#C2F1BC"><select name="club" onChange="getRider(this.value)">
	<option value="">Select Club</option>
	<? 
			  mysql_select_db($database_link, $link);
			  $query_club = "SELECT * FROM club order by club_name ASC";
			  $club = mysql_query($query_club, $link) or die(mysql_error());
			  $row_club = mysql_fetch_assoc($club);
			  $totalRows_club = mysql_num_rows($club);

			  ?>
              <?php
do {  
?>
              <option value="<?php echo $row_club['club_name']?>"><?php echo $row_club['club_name']?></option>
              <?php
} while ($row_club = mysql_fetch_assoc($club));
  $rows = mysql_num_rows($club);
  if($rows > 0) {
      mysql_data_seek($club, 0);
	  $row_club = mysql_fetch_assoc($club);
  }
?>      
        </select>
              <a href="add_club1.php">Add New Club</a></td>
        </tr>
        <tr>
          <td bgcolor="#FFFFFF"><div align="right" class="style26"><span class="style7">NAME OF RIDER</span></div></td>
          <td bgcolor="#C2F1BC"><div id="riderdiv"><select name="rider" id="rider">
            <option>Select Club First</option>
          </select>
              <a href="add_rider1.php">Add New Rider </a>&nbsp;</div></td>
        </tr>
        <tr>
          <td bgcolor="#FFFFFF"><div align="right" class="style26"><span class="style7">RIDER CONTACT NO.</span></div></td>
          <td bgcolor="#C2F1BC"><div id="riderPhoneNumberdiv"><input name="riderPhoneNumber" type="text" id="riderPhoneNumber" /></div></td>
        </tr>
        <tr>
          <td bgcolor="#FFFFFF"><div align="right" class="style26"><span class="style7">OWNER NAME</span></div></td>
          <td bgcolor="#C2F1BC"><select name="owner" id="owner" onchange="getHorse(this.value)">
            <option value="">Select Owner</option>
            <? 
			  mysql_select_db($epsb, $link);
$query_owner = "SELECT * FROM owners order by owner_name ASC";
$owner = mysql_query($query_owner, $link) or die(mysql_error());
$row_owner = mysql_fetch_assoc($owner);
$totalRows_owner = mysql_num_rows($owner);

?>
            <?php
do {  
?>
            <option value="<?php echo $row_owner['owner_name']?>"><?php echo $row_owner['owner_name']?></option>
            <?php
} while ($row_owner = mysql_fetch_assoc($owner));
  $rows = mysql_num_rows($owner);
  if($rows > 0) {
      mysql_data_seek($owner, 0);
	  $row_owner = mysql_fetch_assoc($owner);
  }
?>
          </select>
              <a href="add_owner1.php"> Add Owner</a></td>
        </tr>
        <tr>
          <td bgcolor="#FFFFFF"><div align="right" class="style26"><span class="style7">NAME OF HORSE</span></div></td>
          <td bgcolor="#C2F1BC"><div id="horsediv"><select name="horse" id="horse" >
            <option value="">Select Owner First</option>
          </select>
              <a href="add_horse1.php"> Add New Horse</a></div></td>
        </tr>
        <tr>
          <td bgcolor="#FFFFFF"><div align="right" class="style26"><span class="style7">HORSE NO</span></div></td>
          <td bgcolor="#C2F1BC"><input name="horseno" type="text" id="horseno" size="50" maxlength="10" /></td>
        </tr>
        <tr>
          <td height="38" valign="top" bgcolor="#FFFFFF"><div align="right" class="style26"><span class="style7">CLASS ENTRY</span></div></td>
          <td valign="top" bgcolor="#C2F1BC"><p>
            <input name="addrider2" type="button" id="addrider2" onclick="MM_openBrWindow('participantClass.php?ownerid=<?=$owner2?>','addrider','width=600,height=400')" value="Class Entered" />
            &nbsp;</p>
                <table border="1">
                  <? 
 $query_class = "SELECT * FROM class_details "; 
$class = mysql_query($query_class) or die(mysql_error()); 
$row_class = mysql_fetch_array($class); 
$totalRows_class = mysql_num_rows($class); 
 ?>
                  <?php 
$fields = mysql_num_fields($class); 
echo "<tr>\n";// dptkan nama medan 
echo "<td></td>\n"; 
for ($f=0; $f<$fields; $f++) 
{ echo "<td>".mysql_field_name($class,$f)."</td>\n"; } 
echo "</tr>\n"; 

do { ?>
                  <tr>
                    <td width="20"><input type="checkbox" name="class_id[]" value="<?php echo $row_class['class_number']; ?>" /></td>
                    <td width="71"><span class="style26"><?php echo $row_class['0']; ?>
                          </div>
                    </span></td>
                    <td width="57"><span class="style26"><?php echo $row_class['1']; ?>
                          </div>
                    </span></td>
                    <td width="64"><span class="style26"><?php echo $row_class['2']; ?>
                          </div>
                    </span></td>
                    <td width="64"><span class="style26"><?php echo $row_class['3']; ?>
                          </div>
                    </span></td>
                    <td width="64"><span class="style26"><?php echo $row_class['4']; ?>
                          </div>
                    </span></td>
                  </tr>
                  <?php } while ($row_class = mysql_fetch_array($class)); ?>
                </table></td>
        </tr>
        <tr bgcolor="#FFFFFF">
          <td height="57" colspan="2" valign="top"><div align="right">
            <input type="submit" name="register" id="register" value="Save" />
            <input type="reset" name="Reset" value="Reset" />
          </div></td>
        </tr>
      </table>
    </form>
        <p align="center"><font color="#008000" face="Arial" 
      size="1"><strong><br />
          </strong></font><font face="Arial" 
      size="1"><strong><span class="style1">Copyright Reserved <br />
            Equestrian Promotion Sdn Bhd</span></strong></font></p></td>
    <!-- Col 1 -->
  </tr>
</table>
</body>
</html>

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
<--form findeRider2.php -->
 
<? 
$club=$_GET['club'];
 
include 'db_connect.php';
 
$query="SELECT rider_name FROM riders WHERE club_name='".$club."' order by rider_name ASC";
 
$result=mysql_query($query);
 
?>
 
<tr>
<td>
    <select name="rider" onchange="getRiderPhoneNumber(<?=$club?>,this.value)">
    <option>Select Rider</option>
    <? while($row=mysql_fetch_array($result)) { ?>  
    <option value=<?=$row['rider_name']?>><?=$row['rider_name']?></option>
<? } ?>
</select>
     <a href="add_rider1.php">Add New Rider </a>&nbsp;</div></td>
     </tr>[/COLOR]
[COLOR="Red"]<--for findRiderPhoneNumber.php-->
 
 
<? 
 
$club =$_GET['club'];
 
$rider=$_GET['rider'];
 
include 'db_connect.php';
 
$query="SELECT rider_phone FROM riders WHERE club_name = '".$club."' AND rider_name='".$rider."'";
 
$result=mysql_query($query);
 
$row_rider = mysql_fetch_assoc($result);
 
$totalRows_rider = mysql_num_rows($result);
 
?>
 
<tr> 
<input name="riderPhoneNumber" type="text" id="riderPhoneNumber" value="<?=$row_rider['rider_phone']?>"
/>       
</tr>
<--form findeRider2.php -->

<? 
$club=$_GET['club'];

include 'db_connect.php';

$query="SELECT rider_name FROM riders WHERE club_name='".$club."' order by rider_name ASC";

$result=mysql_query($query);

?>

<tr>
<td>
    <select name="rider" onchange="getRiderPhoneNumber(<?=$club?>,this.value)">
    <option>Select Rider</option>
    <? while($row=mysql_fetch_array($result)) { ?>  
    <option value=<?=$row['rider_name']?>><?=$row['rider_name']?></option>
<? } ?>
</select>
     <a href="add_rider1.php">Add New Rider </a>&nbsp;</div></td>
     </tr>[/COLOR]
[COLOR="Red"]<--for findRiderPhoneNumber.php-->


<? 

$club =$_GET['club'];

$rider=$_GET['rider'];

include 'db_connect.php';

$query="SELECT rider_phone FROM riders WHERE club_name = '".$club."' AND rider_name='".$rider."'";

$result=mysql_query($query);

$row_rider = mysql_fetch_assoc($result);

$totalRows_rider = mysql_num_rows($result);

?>

<tr> 
<input name="riderPhoneNumber" type="text" id="riderPhoneNumber" value="<?=$row_rider['rider_phone']?>"
/>       
</tr>

i need help on this...

Last edited by peter_budo; Jun 4th, 2008 at 4:11 am. Reason: Keep It Organized - please use [code] tags

Quick Reply to Thread

Show Printable Version

Similar Threads

Starting Python (Python)
XP not booting - lsass.exe not found (Windows NT / 2000 / XP)
Hi guys please clear my doubt. (ASP.NET)
Pascal assistance (Pascal and Delphi)
ideas (PHP)
view employee info for the employee selected from the drop down list (PHP)
"Cannot find server or DNS Error" and Trojan Virus (Viruses, Spyware and other Nasties)
HJT Log file (Viruses, Spyware and other Nasties)
can someone help me ive been up for 6 hours (Viruses, Spyware and other Nasties)

Other Threads in the JavaScript / DHTML / AJAX Forum

Previous Thread: How to create a scolling combo box?
Next Thread: Dragging layers

Thread Tools	Search this Thread
Show Printable Version Email this Page

DaniWeb Message

Cancel Changes