posted June 21, 2000 06:07 PM            

I can add values to it but can't get rid of them.

Does anyone have a suggestion on this?

Here is the code I'm using:
________select statement________
<select name="cid[]" size="5" multiple>
<?php
$result_selected = mysql_query("select f.rid,f.cid,c.id,c.title from foodlookup f,category c where f.rid=$rid and c.id=f.cid;",$db);
$myrow = mysql_fetch_array($result_selected);
do {
printf("\t<option value=\"%s\" selected>%s\n",$myrow["id"],$myrow["title"]);
} while ($myrow = mysql_fetch_array($result_selected));
?>
<?php

//query for displaying your user information.
$result_master = mysql_query("select title,id, COUNT(rid) AS count FROM category LEFT JOIN foodlookup ON cid=id and rid=$rid GROUP BY id having count=0;",$db);
$myrow = mysql_fetch_array($result_master);
do{
printf("\t<option value=\"%s\">%s\n",$myrow["id"],$myrow["title"]);
} while ($myrow = mysql_fetch_array($result_master));
?>
</select>

_______ends________
I populate the select statement in two parts - one to find the selected values, and then the second part populates the ones that have not been selected. It may look a little cryptic but I was the only way I could get it to work!

_______submit_______
for ($i=0;$i<count($cid);$i++) {
$sql2 = "INSERT INTO FoodLookup (rid,cid) VALUES ('$rid','$cid[$i]')";
$result2 = mysql_query($sql2);
}
_______end_______
this submit to the database command runs through the values submitted (as it is a multiple select) and inserting them all - it works fine.

Any suggestions on this would be much appreciated

posted June 21, 2000 08:36 PM            

if ($myvar = true)
{
echo "<option value=\"$name\"> $name </option>\n";
}
else
{
echo "<option value=\"$name\" selected> $name </option>\n";
}

Don't know if that helps or not. if it doesn't, just spend my $0.02 on something nice.

posted June 21, 2000 09:15 PM            

So, If I enter a restaurant and say it offers Thai, Lao and Indonesian cuisine, then on the select I pick Thai, Lao and Indonesian and enter it - no probvlems - that all works.

Now lets say a year from now, the restaurant changes hands and does Pizza instead. What I want to be able to do is bring up the record (which will appear with Thai, Lao and Indonesian slected) and de-select these and reselect Pizza.

The problem, is, the script will let me add pizza, but I can't get it to delete records (any or all of them).

I put in another <option> called "delete" which was supposed to let the user delete all foot category entries and start again, and I tested for it by the sql insert statement, but that wouldn't work!

Do you see what my problem is??