Initially selected in drop down menu

[petenaylor]

Hi all

 

I am trying to create a menu that shows the initially selected value depending on which page the user is on:

 

<?php

$fetchcategories=mysql_query("SELECT * FROM `product_categories` ORDER BY id ASC");

while($returnedcategories=mysql_fetch_array($fetchcategories)) {

echo "<option value=\"".$returnedcategories['name']."\" selected=\"selected\" >".$returnedcategories['name']."</option>";

}

?>

 

There are three product categories; Stone, Wood and Accessories. in the SQL.

 

When on the stone.php page I need the option value 'stone' to stay selected.

 

Many thanks for your help

 

Pete

[revraz]

Do a IF statement for your selected =