Ad:

PHP Discussion Thread
Unsolved
Views: 12084

May 8th, 2008

Refresh + Combo Box

Expand Post »

Pretty simple, just dont know how to find the solution XS.

I have a combo box, that once u select the required attribute (A, B, C).

It should display the apporiate text of A, B, C below it.

So any ideas?

Thanks, Regards X

Similar Threads

How to clear or refresh a combo box? in VB.NET
can not update combo box... in VB.NET
Updating Combo Box in Visual Basic 4 / 5 / 6
problem in listing directories in list box in Java
updating DataGrid on Button Press in ASP.NET

OmniX

Reputation Points: 31

Solved Threads: 10

Practically a Master Poster

Offline

652 posts
since Dec 2007

Permalink

May 8th, 2008

Re: Refresh + Combo Box

you can using this:
$_POST['dropdown list name'];
if this not true please give me more explains.

almualim

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

28 posts
since May 2008

Permalink

May 8th, 2008

Re: Refresh + Combo Box

I said it in the other thread, have an onchange event to submit the page when you select a value from the dropdown list. When the page is submitted, you can know which option was selected from the dropdown list. ($val = $_POST['dropdownlistname']; ) Then query the table with this value as condition and retrieve the data.

nav33n

Moderator

Featured Poster

Reputation Points: 524

Solved Threads: 356

Purple hazed!

Offline

3,878 posts
since Nov 2007

Permalink

May 8th, 2008

Re: Refresh + Combo Box

Hi nav33n, my php GURU!

PHP Syntax (Toggle Plain Text)
<?php	$con = mysql_connect("localhost","root");	mysql_select_db("test");	$query = "select col1 from table";	$result = mysql_query($query);	echo "<form method='post' action='test.php'>";	echo "<select name=dropdown1 onchange='javascript: document.form.submit();'>";	while($row = mysql_fetch_array($result)) {		$value = $row['col1'];		echo "<option value='".$value."'>$value</option>";	}	echo "</select>"; 	$firstdropdownlistvalue = $_POST['dropdown1'];	$query2 = "select * from table where col2 = '$firstdropdownlistvalue'";	$result2 = mysql_query($query2);	echo "<select name=dropdown2>";	while($row2 = mysql_fetch_array($result2)) {		$value2 = $row2['col1'];		echo "<option value='".$value2."'>$value2</option>";	}	echo "</select>";	echo "</form>";?><?php
	$con = mysql_connect("localhost","root");
	mysql_select_db("test");
	$query = "select col1 from table";
	$result = mysql_query($query);
	echo "<form method='post' action='test.php'>";
	echo "<select name=dropdown1 onchange='javascript<b></b>: document.form.submit();'>";
	while($row = mysql_fetch_array($result)) {
		$value = $row['col1'];
		echo "<option value='".$value."'>$value</option>";
	}
	echo "</select>";
 
	$firstdropdownlistvalue = $_POST['dropdown1'];
	$query2 = "select * from table where col2 = '$firstdropdownlistvalue'";
	$result2 = mysql_query($query2);
	echo "<select name=dropdown2>";
	while($row2 = mysql_fetch_array($result2)) {
		$value2 = $row2['col1'];
		echo "<option value='".$value2."'>$value2</option>";
	}
	echo "</select>";
	echo "</form>";
?>
<?php	$con = mysql_connect("localhost","root");	mysql_select_db("test");	$query = "select col1 from table";	$result = mysql_query($query);	echo "<form method='post' action='test.php'>";	echo "<select name=dropdown1 onchange='javascript<b></b>: document.form.submit();'>";	while($row = mysql_fetch_array($result)) {		$value = $row['col1'];		echo "<option value='".$value."'>$value</option>";	}	echo "</select>"; 	$firstdropdownlistvalue = $_POST['dropdown1'];	$query2 = "select * from table where col2 = '$firstdropdownlistvalue'";	$result2 = mysql_query($query2);	echo "<select name=dropdown2>";	while($row2 = mysql_fetch_array($result2)) {		$value2 = $row2['col1'];		echo "<option value='".$value2."'>$value2</option>";	}	echo "</select>";	echo "</form>";?><?php
	$con = mysql_connect("localhost","root");
	mysql_select_db("test");
	$query = "select col1 from table";
	$result = mysql_query($query);
	echo "<form method='post' action='test.php'>";
	echo "<select name=dropdown1 onchange='javascript<b></b>: document.form.submit();'>";
	while($row = mysql_fetch_array($result)) {
		$value = $row['col1'];
		echo "<option value='".$value."'>$value</option>";
	}
	echo "</select>";
	
	$firstdropdownlistvalue = $_POST['dropdown1'];
	$query2 = "select * from table where col2 = '$firstdropdownlistvalue'";
	$result2 = mysql_query($query2);
	echo "<select name=dropdown2>";
	while($row2 = mysql_fetch_array($result2)) {
		$value2 = $row2['col1'];
		echo "<option value='".$value2."'>$value2</option>";
	}
	echo "</select>";
	echo "</form>";
?>

From your other thread a few questions, as mine is linked to a mysql database which the values are retrieved from that.

I have pretty much everything you have there already minus the on change even like you said.

PHP Syntax (Toggle Plain Text)

echo "<select name=dropdown1 onchange='javascript: document.form.submit();'>";

So this is the only code I need to add to let my form submit itself and show the appropriate data?

Also another quick Q, once I have selected the drop down item and refreshed the page, I wish to keep the selected item in the combo box and not be reset to the intial value.Any ideas?

Thanks for all your help again, ill try that now. - I just tested it and it works BUT my first drop down isnt refreshing but my second is =S (Ill go debug and keep you posted)

Regards, X

Last edited by OmniX; May 8th, 2008 at 9:31 pm.

OmniX

Reputation Points: 31

Solved Threads: 10

Practically a Master Poster

Offline

652 posts
since Dec 2007

Permalink

May 8th, 2008

Re: Refresh + Combo Box

After a whole bunch of debugging everything is done!
Thanks nav once again your a legend

OmniX

Reputation Points: 31

Solved Threads: 10

Practically a Master Poster

Offline

652 posts
since Dec 2007

Permalink

May 9th, 2008

Re: Refresh + Combo Box

lol.. no ! I am a learner.. I am glad your problem was fixed !

nav33n

Moderator

Featured Poster

Reputation Points: 524

Solved Threads: 356

Purple hazed!

Offline

3,878 posts
since Nov 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: JPGraph+IMG TAG

Next Thread in PHP Forum Timeline: please help me in drop down list

DaniWeb Message

Cancel Changes

User Name
Password