arrays..

hi guys i have a litter problem

i have the follwing table structure

[CODE]CREATE TABLE `survey_type` (
`type_id` int(10) unsigned NOT NULL auto_increment,
`type_name` varchar(45) NOT NULL default ”,
PRIMARY KEY (`type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;[/CODE]

on a php page im trying to fill the combo with the type_name like that

[code=php]<select name=”survey” dir=”rtl”>
<?php
$data = get_survey_types_name();

foreach ($data as $survey)
{
echo “<option value=$survey>$survey</option>”;
}
?>
</select>[/code]

where get_survey_types_name() function is

[code=php]function get_survey_types_name()
{
db_connect();
$sql = “select type_name from survey_type”;
$result = mysql_query($sql) or die(mysql_error());

if (!$result)
return false ;

$poll_data = array();

for ($count=0 ; $row=mysql_fetch_array($result) ; $count++)
{
$poll_data[$count] = $row[0] ;

}

return $poll_data;
} [/code]

im was trying to retuen the type_id from the same function and place them as values for the options cuz later i’ll use that for updating the database..

any ideas how to do that ??

Regards,

Noor

Also in #PHP _↴