drop down menu not being populated

Expand Post »

this code was working fine until i changed the way the site loads the content (it now loads the content into a div tag) and since then it will not populate the menu.

the page can be viewed at

this site

you will need to go to the sub links on the left and click the Register Interest in Courses link.

here is the code that is not working

PHP Syntax (Toggle Plain Text)
case 10:
			echo'';
			$db = "pipdb"; 
			$con = mysql_connect("localhost","pip","piptables")or die(mysql_error());
 
			mysql_select_db($db)or die(mysql_error());
			$query="SELECT id, title FROM training";
			$result = mysql_query($query) or die(mysql_error());
 
			$options = "";
 
			while ($row=mysql_fetch_array($result)) {
 
				$id = $row['id'];
				$title = $row['title'];
				$options.="<OPTION VALUE=\"$id\">".$title;
			}
 
		echo'<form action=\"insert_interest.php\" method=\"POST\">
 
		<h4>Select which course you would like to register your interest in</h4>
 
		<h5>Option 1</h5>
		   <select name=\"radio\">
				  <OPTION VALUE=0>Please select an option
				  <?=$options?>
		   </select>
		<h5>Option 2</h5>
		(only select more options if needed)<br />
		<br />
			<select name="radio1">
				<OPTION VALUE=0>Please select an option
				<?=$options?>
		    </select>
		<h5>Option 3</h5>
			<select name="radio2">
				<OPTION VALUE=0>Please select an option
				<?=$options?>
		    </select>
		    <br /><br /><h4>Enter the required information</h4>
		    <b>Name:</b><br />
		    <input type="text" name="name" /><br />
		    <b>Address:</b><br />
		    <textarea cols="50" rows="7" name="address" onkeyup="textLimit(this, 150);"></textarea><br />
			<b>Housing Association:</b><br />
		    <input type="text" name="housing" /><br />
		   <b>Email:</b><br />
		   <input type="text" name="email" /><br />
		   <br />
		   <input type="submit" value="Register Interest" />
		      </p>
		</form>';
				break;
case 10:
			echo'';
			$db = "pipdb"; 
			$con = mysql_connect("localhost","pip","piptables")or die(mysql_error());
			
			mysql_select_db($db)or die(mysql_error());
			$query="SELECT id, title FROM training";
			$result = mysql_query($query) or die(mysql_error());
			
			$options = "";
			
			while ($row=mysql_fetch_array($result)) {
			
				$id = $row['id'];
				$title = $row['title'];
				$options.="<OPTION VALUE=\"$id\">".$title;
			}
			
		echo'<form action=\"insert_interest.php\" method=\"POST\">

		<h4>Select which course you would like to register your interest in</h4>
		
		<h5>Option 1</h5>
		   <select name=\"radio\">
				  <OPTION VALUE=0>Please select an option
				  <?=$options?>
		   </select>
		<h5>Option 2</h5>
		(only select more options if needed)<br />
		<br />
			<select name="radio1">
				<OPTION VALUE=0>Please select an option
				<?=$options?>
		    </select>
		<h5>Option 3</h5>
			<select name="radio2">
				<OPTION VALUE=0>Please select an option
				<?=$options?>
		    </select>
		    <br /><br /><h4>Enter the required information</h4>
		    <b>Name:</b><br />
		    <input type="text" name="name" /><br />
		    <b>Address:</b><br />
		    <textarea cols="50" rows="7" name="address" onkeyup="textLimit(this, 150);"></textarea><br />
			<b>Housing Association:</b><br />
		    <input type="text" name="housing" /><br />
		   <b>Email:</b><br />
		   <input type="text" name="email" /><br />
		   <br />
		   <input type="submit" value="Register Interest" />
		      </p>
		</form>';
				break;

any help would be great with this.

i know it has something to do with how i am echoing the information out.

Similar Threads

Dynamic drop down box, populated from MySQL Db in JavaScript / DHTML / AJAX
need some help with a dynamically populated dropdown menu... in PHP
How do I get a drop down jump menu to submit? in PHP
opopulate textfields based on drop down menu selection in ColdFusion
Table Populated by Database when picked by menu in PHP

kevin wood

Reputation Points: 27

Solved Threads: 1

Posting Whiz

Offline

347 posts
since Feb 2008

Permalink

Apr 1st, 2009

Re: drop down menu not being populated

Pretty straight forward. You are having <?=$options?> in echo.
End the echo statement then echo $options.
Example,

php Syntax (Toggle Plain Text)
	echo'<form action=\"insert_interest.php\" method=\"POST\">
 
		<h4>Select which course you would like to register your interest in</h4>
 
		<h5>Option 1</h5>
		   <select name=\"radio\">
				  <OPTION VALUE=0>Please select an option';
				  echo $options;
		   echo '</select>
		<h5>Option 2</h5>
		(only select more options if needed)<br />
		<br />
			<select name="radio1">
				<OPTION VALUE=0>Please select an option';
				echo $options;
//and so on...
	echo'<form action=\"insert_interest.php\" method=\"POST\">

		<h4>Select which course you would like to register your interest in</h4>
		
		<h5>Option 1</h5>
		   <select name=\"radio\">
				  <OPTION VALUE=0>Please select an option';
				  echo $options;
		   echo '</select>
		<h5>Option 2</h5>
		(only select more options if needed)<br />
		<br />
			<select name="radio1">
				<OPTION VALUE=0>Please select an option';
				echo $options;
//and so on...

nav33n

Moderator

Featured Poster

Reputation Points: 524

Solved Threads: 356

Purple hazed!

Offline

3,878 posts
since Nov 2007

Permalink

Apr 1st, 2009

Re: drop down menu not being populated

thanks once again for your help.

i had tried nearly every variation of putting the echo in different places and closing it out on different lines. just didnt think about the fact that the page was php and didnt need the html tags to display the php variables.

thank you again

kevin wood

Reputation Points: 27

Solved Threads: 1

Posting Whiz

Offline

347 posts
since Feb 2008

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

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: The specified CGI application misbehaved by not returning a complete set of HTTP head

Next Thread in PHP Forum Timeline: i can't load my image in preview

DaniWeb Message

Cancel Changes

User Name
Password