Multiple Select HTML-PHP

cbjewelz

Hey so Im trying to display in an edit form what a user has previously selected when they first submitted this form. For a select menu I use this code which works flawlessly:
after connection to db and doing my query

now I don't know how to achieve the same thing using a MULTIPLE select menu. This information is stored in an array in the db so I was thinking I might have to use the in_array() function but i can't seem to get it to work. Here's what I currently have which doesn't work at all (although it does display the multiple select properly, it just doesn't show what has been selected according to the db):
ive got two queries one of which is not shown which is $user_profile[friends]. This is the array where what has been previously selected is stored in the db.

$query_n = "SELECT nickname, id from table ORDER BY nickname ASC";
$getnick = mysql_query($query_n); 

while($nickname = mysql_fetch_assoc($getnick)) {  

?>

<option value="<?php echo $nickname[id]; ?>"
<?php 
$find = array($user_profile[friends]);
if (in_array($nickname[id], $find)) {
   echo "SELECTED";
} ?>>

<?php } ?>

Here I'm trying to loop through the id's from the table and for each one I search within the friends array from a different table to see if there is a match and if so then echo SELECTED. any help please

Bobulous

I don't understand this line:

$find = array($user_profile[friends]);

If $user_profile[friends] is the array whose elements are the items you want to mark as selected, then surely you want this code instead:

if (in_array($nickname[id], $user_profile[friends])) {
   echo "SELECTED";
}

Also, unless the term friends is a constant, shouldn't it be $user_profile['friends'] so that 'friends' is a string key for the array?

cbjewelz

woohoo i solved it..you were right i had to not use tyhe $find var but i also had to unserialize friends first..thnks