Mysql populate

[ngreenwood6]

I am trying to get my database to populate a select option. I have the following code:

 

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

$dates = $row['dates'];

foreach($dates as $key => $values){
$key = $values;
echo "<form>";
echo "<select>";
echo "<option values='$values'>$values</option";
echo "</select>";
echo "</form>";
echo $values;
}
}

 

I know that this has to be wrong. Can someone please help me with the foreach and the database values.

[premiso]

<?php
$output = "<form><select name=dates>";
while($row = mysql_fetch_array($results)){

$dates = $row['dates'];

foreach($dates as $key => $values){
// $key = $values; not sure what that is for 
$output .= "<option values='$values'>$values</option>";
//echo $values;
}
}
$output .= "</select></form>";

echo $output;
?>

 

Should work, assuming $dates is an array.

[ngreenwood6]

I have the select box but it is not populated with any data. I know that the data is in the database. Oh yean and I am still getting this error:

 

Warning: Invalid argument supplied for foreach() in C:\wamp\www\CMS\test.php on line 24

 

Line 24 is blank but line 25 is this:

foreach($dates as $key => $values){

[premiso]

<?php
$output = "<form><select name=dates>";
while($row = mysql_fetch_array($results)){
$output .= "<option values='" . $row['dates'] . "'>" . $row['dates'] . "</option>";
}
$output .= "</select></form>";

echo $output;
?>

 

Maybe that is what you are after?

[ngreenwood6]

Yeah the last post that you made worked like a charm.

[ngreenwood6]

When is the best time to use a foreach?

[premiso]

When is the best time to use a foreach?

 

When you need to iterate through all elements of an array. foreach