I have created a PHP code to echo the following div
<div id="main_catsel">
<select id="maincat" >
<option value="1">none</option>
<option value="2">Computer</option>
<option value="4">Refrigerator</option>
<option value="13" selected="selected" >Grinder</option>
<option value="21">Bed</option>
</select>
</div>
I am using the option values and name as result from query . But now the default result still shown first is according to the id not according to selected="selected". Can any one sugsest a solution for this. Cant remove the id ,because its needed for insertion.
$maincat .='<div class="main_catsel">';
$sqlmaincat = $ilance->db->query("SELECT
cid FROM " . DB_PREFIX . "seller_profile
WHERE userid = '" . $uid . "'");
$row = $ilance->db->fetch_array($sqlmaincat);
$sqlcat = $ilance->db->query("SELECT
cid,title_spa
FROM " . DB_PREFIX . "categories
WHERE parentid = '0'
");
if ($ilance->db->num_rows($sqlcat) > 0)
{
$maincat .='<h2><select id="maincat">';
while ($rows = $ilance->db->fetch_array($sqlcat))
{
if($rows['cid']==$row['cid'])
{
$maincat .='<option selected="selected" value="'.$rows['cid'].'">'.$rows['title_spa'].'</option>';
}
else
{
$maincat .='<option value="'.$rows['cid'].'">'.$rows['title_spa'].'</option>';
}
}
$maincat .='</select></h2>';
}
$maincat .='</div>';
