Hey all, I would like to add an if statement to the following function so that the value 1 is assigned "corporate" and the value is 2 assign "standard" to it. Would you show me an example on adding it to the below function? If there is a better way to reassign the value please share. Thank you, Chris public function ShowType() { $sql = "SELECT DISTINCT store_type FROM store_list WHERE id_markets=$_POST[id]"; $res = mysql_query($sql,$this->conn); $Type = '<option value="0">store type...</option>'; while($row = mysql_fetch_array($res)) { $Type .= '<option value="' . $row['id_store'] . '">' . $row['store_type'] . '</option>'; } return $Type; } -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php