Little Problem With Colum Echoing

[ATLien]

function schools(){
	$conn = db_connect();
		if (!$conn)
		   return 'Could not connect to database server - please try later.';
	echo '<select name="school">';
	$school = mysql_query("select college_name from sv_colleges");
}

I would like to echo all the values that are in colum 1, as a drop down box.

I wanted to echo this for each value. I am trying to make a drop down box of all the values.

<option>Colum Value</options>

[stolzyboy]

<select name="dropdown">
<?
$query = "select college_name from sv_colleges order by college_name;";
$result = mysql_query($query) or die(mysql_error());

while ($row = mysql_fetch_array($result))
{
?>
<option value="<? echo $row['fieldname']; ?>"><? echo $row['fieldname']; ?></option>
<?
}
?>
</select>

[ATLien]

function schools(){
	echo '<select name="school">';
	$resultschools = mysql_query("select * from sv_colleges order by college_name;") or die(mysql_error()); 
	$rows = mysql_fetch_array($resultschools);
	foreach ($rows as $row){
	echo "<option value=" . $row['college_name'] . ">" . $row['college_name']. "</option>";
	} 
	echo '</select>';
}

Ok that is what I have but it is not echoing the schools in to the drop down menu.

[stolzyboy]

<?
function schools(){ 
    echo "<select name=\"school\">"; 
    $resultschools = mysql_query("select * from sv_colleges order by college_name;") or die(mysql_error());
    while ($row = mysql_fetch_array($resultschools)) 
	{
	echo "<option value=" . echo $row['fieldname'] . ">" . echo $row['fieldname'] . "</option>";
	}
    echo '</select>'; 
}
?>

[laserlight]

More likely:

<?php
function schools()
{
    echo "<select name=\"school\">";
    $resultschools = mysql_query("select * from sv_colleges order by college_name;")
    	or die(mysql_error());
    while ($row = mysql_fetch_array($resultschools))
    {
    	echo "<option value=" . $row['fieldname'] . ">" . $row['fieldname'] . "</option>";
    }
    echo '</select>';
}
?>