Select box help

[kevincro]

I have a select box coded that displays MySQL data as options in the pull down menu.  What I need to know is if and how I can make it so that each option has given background.  Can I assign a class to each option?  The code for my select box looks like this:

 

?
// Get data to populate select box
$query=("SELECT name,date  FROM Applicants where number='$data_key' ORDER BY points DESC");



$result = mysql_query ($query);
echo '<select name=Applicants> <option value="">Applicants</option>';
// printing the list box select command

while($nt=mysql_fetch_array($result)){//Array or records stored in $nt
echo "<option value=$nt[Name]>$nt[Name]</option>";
/* Option values are added by looping through the array */
}
echo "</select>";// Closing of list box
//end select box
?>

[phpSensei]

i dont understand what you mean but

 

<?php

$data = mysql_query("SELECT * FROM table_name"); // the query

echo '<select name="select" class=';
while($row = mysql_fetch_array($data)){



if($row['value']=="a certain number or string"){


echo 'The Class with a black background';

}
elseif($row['value']=="a certain number or string"){


echo 'The Class with a white background';

}

echo'>
  <option value="'.$row['value'].'">'..$row['value']'</option>


}
</select>';

?>

[teng84]

i dont understand what you mean but

 

<?php

$data = mysql_query("SELECT * FROM table_name"); // the query

while($row = mysql_fetch_array($data)){

echo '<select name="select" class=';


if($row['value']=="a certain number or string"){


echo 'The Class with a black background';

}
elseif($row['value']=="a certain number or string"){


echo 'The Class with a white background';

}

echo'>
  <option value="'.$row['value'].'">'..$row['value']'</option>
</select>';


}
?>

 

running your code will give so many drop down box?

[phpSensei]

i forgot to seperate it from the while statement.

[phpSensei]

<?php

$data = mysql_query("SELECT * FROM table_name"); // the query

echo '<select name="select" class="';

while($row = mysql_fetch_array($data)){
                           
                if($row['value']=="a certain number or string")
                {
                 
                echo 'The Class with a black background' . '">';

                }
               elseif($row['value']=="a certain number or string")
               {

               echo 'The Class with a white background' .'">';

               }

echo'<option value="'.$row['value'].'">'.$row['value'].'</option>


}
</select>';

?>