Page 3 of 3

Posted: Mon Mar 10, 2003 3:26 pm
by meandrew
<select name="catID">
<option value="" disabled selected>Select Category</option>
<option value="" disabled>---------------</option><?
$result = mysql_query("SELECT * FROM category", $db);
while($row = mysql_fetch_array($result)) {?>
<option value="<? echo $row['catID']; ?>"><? echo $row['catName']; ?></option>
<? } ?>
</select>

I have tried changing this and cant get this part

option value="" disabled selected>Select Category</option>

to work?

Any ideas what I am doing wrong?

<?
require("connection.php");

mysql_connect("$DBHost", "$DBUser", "$DBPass") or
die("could not connect");
mysql_select_db("$DBName");

echo "<select name='CountyID' size='1' class='menuForm'>";

$result=mysql_query("SELECT County, CountyID FROM county ORDER BY County");
while ($row = mysql_fetch_array($result)) {
$county_id=$row['CountyID'];
$county=$row['County'];
echo "<option value='$county_id'";
if ($CountyID == $county_id)
{echo " selected";}
echo "> $county </option>";
}
echo "</select>";
?>

Andrew