DaniWeb Forum Index > Web Development > PHP

Select List Values Retained

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

•

Join Date: Jan 2008

Posts: 19

Reputation: Morty222 is an unknown quantity at this point

Solved Threads: 0

Morty222

Offline

Newbie Poster

Select List Values Retained

Feb 12th, 2008

I am using the following query to pull categories from the DB then creating a select list.

Can some tell me how to make the current value selected in the list when they open the category?

<?php
include("mysql.php");
$queryc = "select * from tbl_category WHERE active = 'yes' ORDER by name ASC";
$resultc = mysql_query($queryc);
while ($rowc = mysql_fetch_array($resultc)) {
$catIDc = $rowc['catID'];
$namec = $rowc['name'];
$activec = $rowc['active'];

echo "<option value=$catIDc>$namec</option>";
}
?>

•

Join Date: Feb 2008

Posts: 9

Reputation: monkey56657 is an unknown quantity at this point

Solved Threads: 1

monkey56657 monkey56657 is offline

Offline

Newbie Poster

Re: Select List Values Retained

Feb 12th, 2008

I am not quite sure what you are wanting here.

Remember you can only select one item from a drop down by default and since you outputing all that are equal to yes I get confused as to the purpose of the while loop (unless there are many rows...which wouldnt work).

To set the default selected item on a drop down do it like so...

Help with Code Tags

PHP Syntax (Toggle Plain Text)

<option value="..." selected="selected"></option>

Could you offer more of an explantion?

-------------------------------------------------------------------

Website Tutorials

Last edited by monkey56657; Feb 12th, 2008 at 7:11 pm.

•

Join Date: Nov 2007

Posts: 3,760

Reputation: nav33n is a jewel in the rough

Solved Threads: 332

nav33n

Offline

Senior Poster

Re: Select List Values Retained

Feb 12th, 2008

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
<?php
//connection
//select db
$selected_id=$_POST['select'];
$query="Select * from table";
$result=mysql_query($query);
$options="";
while($row=mysql_fetch_array($result)){
   $name=$row['name'];
   $id=$row['id'];
   if($selected_id==$id){ 
          $selected="selected": 
    }
   else {
      $selected=""; 
   }
   $options.="<option value='$id' $selected>$name</option>";
}
?>
<html>
<body>
<form method="post" action="test.php">
Select something: <select name="select">
<?php echo $options; ?>
</select><br />
<input type="submit" name="submit" value="submit">
</form>
</body>
</html>
<?php
//connection
//select db
$selected_id=$_POST['select'];
$query="Select * from table";
$result=mysql_query($query);
$options="";
while($row=mysql_fetch_array($result)){
   $name=$row['name'];
   $id=$row['id'];
   if($selected_id==$id){ 
          $selected="selected": 
    }
   else {
      $selected=""; 
   }
   $options.="<option value='$id' $selected>$name</option>";
}
?>
<html>
<body>
<form method="post" action="test.php">
Select something: <select name="select">
<?php echo $options; ?>
</select><br />
<input type="submit" name="submit" value="submit">
</form>
</body>
</html>