Re: dependable combo boxes with mysql database (Solved)

[Bhoomi Vora <bvora1@xxxxxxxxx>]

I have got it done.
Below is the code:
-------------------------
<form name="from_service" method="post">
<FONT style="FONT-SIZE:12pt" color="#00008B"
face="Courier New"><B>Service</B></FONT>
</DIV>

<select name="D1" size="1"
style="position:absolute;left:230px;top:68px;z-index:7"
onChange="form_service.submit();">
<?php
display_db_combo("service_master","service_name",$conn);

	$ser=$_POST['D1'];
	if ($ser == ""){
	
	print("<option selected>Select Service</option>");
	}
	else {
	
		print("<option selected>$ser</option>");
	}
?>
</select>

<DIV style="position:absolute; left:65px; top:106px;
width:83px; height:22px; z-index:4"  align="left"
valign="top">
<FONT style="FONT-SIZE:12pt" color="#00008B"
face="Courier New"><B>Product</B></FONT>
</DIV>
<select name="D2" size="1"
style="position:absolute;left:230px;top:108px;z-index:8"
onChange="form_service.submit();">
<?php
display_db_combo1("service_master","service_id","service_name","product_master","product_name",$conn);

	$ser=$_POST['D1'];
	$prd=$_POST['D2'];	

	$a='Select Product';
	
	if ($prd == ""){
	
	print("<option selected>$a</option>");
	}
	else {
		print("<option selected>$prd</option>");
	}

?>
</select>

<DIV style="position:absolute; left:65px; top:152px;
width:103px; height:44px; z-index:5"  align="left"
valign="top">
<FONT style="FONT-SIZE:12pt" color="#00008B"
face="Courier New"><B>Nature of Problem</B></FONT>
</DIV>
<select name="D3"
style="position:absolute;left:230px;top:170px;z-index:9"
size="1" onChange="form_service.submit()";>
<?php
display_db_combo2("product_master","product_id","product_name","problem_products","problem",$conn);


	$prb=$_POST['D3'];
	$prd=$_POST['D2'];
	

	if ($prb == "" || $prd == "Select Product") {
			print("<option selected>Select Problem</option>");
		}

	else	{
			print("<option selected>$prb</option>");
	}

?>
</select>
</form>
---------------------------------------------
regards,

Bhoomi

--- "Pranav Negandhi (concept-I)"
<pranav@xxxxxxxxxxxxxxx> wrote:

> This might be slightly OT on this list, but here
> goes nothing.
> 
> 1. Submit the form when the user shifts focus from
> D1 using Javascript's 
> onBlur event
> 2. On the server side, use PHP to retrieve the
> values for D2 and 
> generate the page again
> 3. Repeat 1 & 2 when the value of D2 changes.
> 
> HTH
> Pranav
> www.concept-i.co.in
> 
> 
> Bhoomi Vora wrote:
> > Hello All,
> > 
> > I have a php page which contains three combo
> boxes.
> > The first one will have the value 
> > 
> > from the mysql database table on page load itself.
> > 
> > Then depending upon the value selected in the
> first
> > combobox the second combo box 
> > 
> > should be populated with the respective values
> from
> > another mysql database table, and 
> > 
> > once again depending upon the value selected in
> second
> > combobox the third combobox 
> > 
> > should be populated with the respective values
> from
> > one more different database table.
> > 
> > I have read through mailing list and also searched
> in
> > google and found that it can be 
> > 
> > done with javascript onblur function but nothing
> is
> > working. Here is the code:
> .....d similarly
> > D3 should be populated on event like 'onblur' to
> D2.
> > 
> > Pl. give me the exact code or proper guideline how
> > should I accomplish this on the same page.
> > 
> > Appreciate your replies.
> > 
> > Thanks and regards.
> > 
> > BJV
> > 
> > 
> > 		
> > __________________________________ 
> > Yahoo! FareChase: Search multiple travel sites in
> one click.
> > http://farechase.yahoo.com
> > 
> 
> -- 
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
> 
> 



		
__________________________________ 
Yahoo! FareChase: Search multiple travel sites in one click.
http://farechase.yahoo.com

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php