explode with multiple select box selected

[project3]

ok I have used explode on a list where the list size changes all the time.

 

  $split_m = explode(",",$d_mtime);

 

then I have the following sql to build multiple select box.

I want to select the options that would match the results of the explode.

How would I go about this?

 

 

$query = "SELECT * FROM ds_mealtimes WHERE rid = '$xxid'";

    $result = mysql_query($query) or die(mysql_error());

    while($row = mysql_fetch_array($result, MYSQL_ASSOC))

 

    { 

          $d_name = $row['name'];

   

            print "<option value=$d_name>$d_name</option>";

 

 

  }

[Psycho]

Well, you didn't state what value in the query should match the $d_mtime values, so I will go with the field name 'value'

 

<?php

$split_m = explode(",",$d_mtime);

$values = "'" . implode("','", $split_m) . "'";

$query = "SELECT * FROM ds_mealtimes WHERE rid = '$xxid' AND value IN ($values)";
$result = mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{  
    $d_name = $row['name'];
    print "<option value=$d_name>$d_name</option>";
}

?>

[project3]

Well, you didn't state what value in the query should match the $d_mtime values, so I will go with the field name 'value'

 

<?php

$split_m = explode(",",$d_mtime);

$values = "'" . implode("','", $split_m) . "'";

$query = "SELECT * FROM ds_mealtimes WHERE rid = '$xxid' AND value IN ($values)";
$result = mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{  
    $d_name = $row['name'];
    print "<option value=$d_name>$d_name</option>";
}

?>

 

the select statement can't change like that I want all results to be listed.

 

what i want to do is match the explode the the $d_name and if they match then print selected in the print statemnt.