<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
$row=mysql_fetch_row
Moderator: General Moderators