DaniWeb Forum Index > Web Development > PHP

Not getting data in list box

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

•

Join Date: Nov 2008

Posts: 13

Reputation: anumitadas is an unknown quantity at this point

Solved Threads: 0

anumitadas anumitadas is offline

Offline

Newbie Poster

Not getting data in list box

Nov 22nd, 2008

I want to fetch data from Mysql database in list box..but it's not happening
The code is:

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
<?php
  		include("connection.php");
 
  			$sql= "select student_age from student_data";
  			$result= mysql_query($sql);
			if(!$result)
			{
			die('could not connect:'.mysql_error());
			}
 
 
  		while($row = mysql_fetch_array($result))
 		 {
		 echo "anumita";
  	?>
     <option value="<?=$row[0]?>">
    	 <?=$row[0]?>
   		</option>
  	<?php
 	 }
 	 ?>
<?php
  		include("connection.php");
  
  			$sql= "select student_age from student_data";
  			$result= mysql_query($sql);
			if(!$result)
			{
			die('could not connect:'.mysql_error());
			}
			
  
  		while($row = mysql_fetch_array($result))
 		 {
		 echo "anumita";
  	?>
     <option value="<?=$row[0]?>">
    	 <?=$row[0]?>
   		</option>
  	<?php
 	 }
 	 ?>

Last edited by peter_budo; Nov 24th, 2008 at 6:25 pm. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.

•

Join Date: Jan 2007

Posts: 104

Reputation: Jaseva is an unknown quantity at this point

Solved Threads: 0

Jaseva

Offline

Junior Poster

Re: Not getting data in list box

Nov 22nd, 2008

Your code should work. The only things I see missing are the <select> tags to start and end the list box.

 Help with Code Tags 
 html Syntax (Toggle Plain Text) 
?><select><?
while($row = mysql_fetch_array($result))
...
?><select><?
while($row = mysql_fetch_array($result))
...

~Jaseva

•

Join Date: Aug 2005

Posts: 87

Reputation: TopDogger is an unknown quantity at this point

Solved Threads: 5

TopDogger

Offline

Junior Poster in Training

Re: Not getting data in list box

Nov 24th, 2008

Here is a tutorial for building a select box from MySQL data.

Populating a Select Box With PHP and MySQL

I think Jaseva is right. You probably will not see the select box without the select tags. Use View, Source to take a look at the code being generated.

Last edited by TopDogger; Nov 24th, 2008 at 8:51 am.

Filezilla Tutorials :: Cool Gadgets :: Phoenix SEO