Selected Value for MySQL generated Drop Down List

Question

I have a mysql generate dropdown list..need to add in a pre selected option such as "Please Choose Availability". Not too sure how to do this as the drop down content is generated from a database

<?php


$sql = "SELECT DISTINCT availability FROM properties";
$result = mysql_query($sql);

echo "<select name='property'>";
while ($row = mysql_fetch_array($result)) {
echo "<option value='". $row['availability']. "'>" . $row['availability'] ."</option>";
}
echo "</select>";

?>

It seems this is a duplicate query: stackoverflow.com/questions/9848079/… — dAm2K
– dAm2K, Commented Mar 27, 2012 at 10:33

Rukmi Patel · Accepted Answer · 2012-03-27 10:35:55Z

1

if you want static first value for dropdown then you can do it like this.

echo "<select name='property'><option value=''>Please Choose Availability </option>";

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

answered Mar 27, 2012 at 10:35

Rukmi Patel

2,5619 gold badges29 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

slash197 · Accepted Answer · 2012-03-27 10:37:54Z

1

echo "<select name='property'><option value=''>Please Choose Availability</option>";

edited Mar 27, 2012 at 10:37

answered Mar 27, 2012 at 10:32

slash197

9,0246 gold badges44 silver badges71 bronze badges

Collectives™ on Stack Overflow

Selected Value for MySQL generated Drop Down List

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related