Selecting Listbox Items from Database

klycette

I've been able to retrieve multiple rows from a table and cause the selection of the first one in a list box using this code:

<select name="categories[]" size="6" multiple id="categories">
<option value="Accounting" <?php if ("Accounting" == $cat_row['category']) {echo "SELECTED";} ?>>Accounting</option>

Naturally, this is just part of the list box, but it continues in this same way. As it is right now, the first record found will get selected in the listbox, but no others. I know I have to loop through, but I'm not sure of the syntax. I've tried using

while ($cat = mysql_fetch_assoc($cat_result))

just and then putting all of the listbox code in {}, but it still doesn't work. I thought I'd be able to use this to walk through each record and make the selection in the listbox each time, but something isn't working. Does anyone know what I might be missing? Thanks.

bad76

Hi,
You can put the values in array whit some like this
while ($cat = mysql_fetch_assoc($cat_result)) $cat_all[]=$cat["category"];

and use in_array()

For more help look this:

http://www.phpbuilder.com/board/showthread.php?s=&threadid=10250072

see you

drawmack

while a little less efficient you can also use something dirty like this

//execute the query and skip processing code if not rows are returned.
if($query = mysql_query($whater)) {
  for($i=0;$i<mysql_num_rows($query);$i++) {
    echo "<option value=\"" . mysql_result($i,$col) .
    if ($var == mysql_result($query,$i,$col)) {echo " selected";}
    echo "\">" .  mysql_result($i,$col) . "</selected>\n";
  } //end for
} else {
   //code for when db table is empty
} //end  if

klycette

I'm not sure if echoing is what I'm looking for. I've created the listbox in html and have filled it this way too. I'm trying to highlight all of the items in the lsitbox that are coming back from a query, but I'm only managing to highlight the first one. It's the placement and syntax of the loop that I'm having a problem with.