[RESOLVED] Populating select box using database values

[mosherben]

Hi all,
I'm trying to populate a select list from values in a table. I cannot get it to work, so I would appreciate any assistance in getting the values to be displayed. Here is my code:

<form name="addStudent" method="post">
        Student: <select><?php 
		$sql="SELECT name FROM student";
		$result = mysql_query($sql);
		$row = mysql_fetch_assoc($result);
		foreach($result as $row->$name)
		{
			?><option value="<?php echo $name; ?>"><?php echo $name; ?></option> <?php
		}
		?></select><br />
        </form>

Cheers,

[mikeclarke]

Try this

<form name="addStudent" method="post">
        Student: <select><?php 
		$sql="SELECT name FROM student";
		$result = mysql_query($sql);
		$row = mysql_fetch_assoc($result);
		foreach($result as $row->name)
		{
                       $name = $row->name;

		?><option value="<?php echo $name; ?>"><?php echo $name; ?></option> <?php
	}
	?></select><br />
    </form>

[mikeclarke]

An alternative to that is ....

<form name="addStudent" method="post">
        Student: <select><?php 
		$sql="SELECT name FROM student";
		$result = mysql_query($sql);
		$row = mysql_fetch_assoc($result);
		$num_rows = mysql_num_rows($result);
		$count = 0;

	while ($count <= $num_rows)     {
		$count++
		$name = $row->name;

		?>
<option value="<?php echo $name; ?>"><?php echo $name; ?></option> <?php
					}
	?></select><br />
</form>

[mosherben]

Hi,
thanks for your reply. The first suggustion didn't work, it said that there was an invalid argument, pointing toward the foreach() line, but the second one worked 🙂

Cheers

[mikeclarke]

Glad its working for you 🙂