DaniWeb Forum Index > Web Development > PHP

drop down menu not being populated

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

•

Join Date: Feb 2008

Posts: 347

Reputation: kevin wood is an unknown quantity at this point

Solved Threads: 1

kevin wood kevin wood is offline

Offline

Posting Whiz

drop down menu not being populated

Apr 1st, 2009

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

 Help with Code Tags 
 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.

•

Join Date: Nov 2007

Posts: 3,761

Reputation: nav33n is a jewel in the rough

Solved Threads: 332

nav33n

Offline

Senior Poster

Re: drop down menu not being populated

Apr 1st, 2009

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

 Help with Code Tags 
 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...

Ignorance is definitely not bliss!

*PM asking for help will be ignored*

•

Join Date: Feb 2008

Posts: 347

Reputation: kevin wood is an unknown quantity at this point

Solved Threads: 1

kevin wood kevin wood is offline

Offline

Posting Whiz

Re: drop down menu not being populated

Apr 1st, 2009

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