Not getting data in list box

Expand Post »

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

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.

Similar Threads

getting data from a list box. in Visual Basic 4 / 5 / 6
Deleting A row from a List Box in Visual Basic 4 / 5 / 6
Data dissappears when moving from a List box in Visual Basic 4 / 5 / 6
Adding To a list box from multiple text boxes in Visual Basic 4 / 5 / 6
Multiline in a list box in Visual Basic 4 / 5 / 6

anumitadas

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

17 posts
since Nov 2008

Permalink

Nov 22nd, 2008

Re: Not getting data in list box

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

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

Jaseva

Reputation Points: 17

Solved Threads: 3

Junior Poster

Offline

111 posts
since Jan 2007

Permalink

Nov 24th, 2008

Re: Not getting data in list box

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.

TopDogger

Reputation Points: 15

Solved Threads: 5

Junior Poster in Training

Offline

87 posts
since Aug 2005

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: hello guys I need help with this:<td>  <? echo $row["referalvisits"]; ?>

Next Thread in PHP Forum Timeline: Encoding and saving password during login

DaniWeb Message

Cancel Changes

User Name
Password