Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 316
  • Last Modified:

help in jquery

Hi am using autocomplete....
what i want is to populate 2 diferent sets of auto values based on the option button selection

what happens is when i choose the first option values are loaded properly but when i switch to 2 option values corresponding to 2 option are not loaded...values relating to first option only pops up...only when i refresh the page the other option value gets loaded....

values does not change based on option button change..but they change each time the page is refreshed.
<head>
<script type="text/javascript" src="jquery-autocomplete/lib/jquery.js"></script>  
<script type="text/javascript" src="jquery-autocomplete/jquery.autocomplete.js"></script>  
<script type="text/javascript" src="jquery-autocomplete/searchdata.php"></script>   
<link rel="stylesheet" type="text/css" href="jquery-autocomplete/jquery.autocomplete.css" />  
 
<script type="text/javascript">  
$(document).ready(function() { 
if(document.test.test1[0].checked)
 {
  
  $("#cse_search").autocomplete(searchdata2); 
  }
  if(document.test.test1[1].checked)
 {
 $("#cse_search").autocomplete(searchdata1);  
}
});  
</script>
</head>
<center>
<body onLoad="showClock()">
<form name='test' method='POST' action='<? $_SERVER['PHP_SELF'] ?>'>
 
 
<!-- start here Test Listing table -->
<div class="b2">
<fieldset>
<legend>&nbsp;<b>Test Listing&nbsp;</b></legend>
<table 	 cellspacing="2" cellpadding="2" border="0">
<tr>
 
<!-- start here Radio button table -->
 <td>
<table width="350"  height="55" border="0	" cellpadding="0" cellspacing="1" align="center"   >
 <tr>
<td><input type="radio" name="test1"></td><td>Testing</td>
<td><input type="radio" name="test1"></td><td>Profile</td>
<td><input type="radio" name="testing"></td><td>Master Profile</td>
 </tr>
 <tr>
 <td colspan="9"><input type="text" id="cse_search" name="q" size="31" /></td>
</tr>
</table>
 
...........................
searchdata.php
.............................
 
<?php  
    /* This script parses the Popular Queries feed from Google's CSE product and outputs 
       the recent queries in a JavaScript array for use with the jQuery Autocomplete plugin. */  
    // There may be some search queries you want to include in the autocomplete box  
    // that aren't necessarily popular searches and therefore don't show up in your   
    // Google CSE feed.  You can add those terms to this array to ensure they show up.  
    // You will want to make sure you enter the terms in lowercase.
	
	$server="localhost";
	$user="root";
	$password="";
	$database="lab";
	
	
	mysql_connect($server,$user,$password) or
	die("Unable to connect to the localhost");
	mysql_select_db($database) or 
	die("Database 'Products' doesn't exist!");
	
	$table="doctor";
	$query="select d_name from $table";
	$result=mysql_query($query);
	//$data=mysql_fetch_array($result);
	$num_rows = mysql_num_rows($result);
	
	
	
	
	// Load the Popular Queries RSS Feed from Google's CSE using SimpleXML  
     // The URL is available by clicking "Statistics" from inside your CSE control panel.  
   
    while($data1=mysql_fetch_array($result))
	 {
	 $data[]=$data1['d_name'];
	 }
	  
	
     // Format the data for JavaScript output. 
 
		sort($data); //alphabetize the array  
     foreach($data as $search_term) 
	 { 
	 $js_data[] ="\"" . $search_term . "\""; 
	 }     
     
    // Let's inform the browser that we're sending JavaScript.  
     //header("Content-type: text/javascript\n\n");  
      
     // Next we'll escape from PHP and create a JavaScript array. Inside the array, we'll return t 
    // PHP and use implode() to return a comma-separated string of all the data inside $js_data.  
 ?>  
 var searchdata1 = [<?php echo implode($js_data, ", "); ?>];  
 
<? 
 $table1="test_list";
	$query1="select tst_code from $table1";
	$result1=mysql_query($query1);
	//$data=mysql_fetch_array($result);
	$num_rows1 = mysql_num_rows($result1);
	
	
	
	
	// Load the Popular Queries RSS Feed from Google's CSE using SimpleXML  
     // The URL is available by clicking "Statistics" from inside your CSE control panel.  
   
    while($data2=mysql_fetch_array($result1))
	 {
	 $dat[]=$data2['tst_code'];
	 }
	  
	
     // Format the data for JavaScript output. 
 
		sort($dat); //alphabetize the array  
     foreach($dat as $search_trm) 
	 { 
	 $js_dat[] ="\"" . $search_trm . "\""; 
	 }     
     
    // Let's inform the browser that we're sending JavaScript.  
     //header("Content-type: text/javascript\n\n");  
      
     // Next we'll escape from PHP and create a JavaScript array. Inside the array, we'll return t 
    // PHP and use implode() to return a comma-separated string of all the data inside $js_data.  
 ?>  
 var searchdata2 = [<?php echo implode($js_dat, ", "); ?>];

Open in new window

0
whspider
Asked:
whspider
1 Solution
 
davidsperlingCommented:
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now