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;
$namec = $rowc;
$activec = $rowc;
echo "<option value=$catIDc>$namec</option>";
}
?>