Foreach loop, not looping?

[lalnfl]

$array = array("1","2","3");

 

foreach ($array as $value){

 

echo $value;

 

}

 

Put its only echoing out 3, not the whole array.

[kenrbnsn]

It should echo "123"

 

Try

<?php
$array = array("1","2","3");

foreach ($array as $value){

echo $value . '<br>';

}
?>

 

Another way to do this is

<?php
$array = array("1","2","3");
echo implode('<br>',$array);
?>

 

Ken

[fugix]

Try printr($array) to see what displays

[lalnfl]

$sql_get_worker = mysql_query("SELECT id FROM Worker WHERE mem_id='$id' AND retired='n'");

$get_worker = mysql_fetch_assoc($sql_get_worker);

 

foreach ($get_worker as $value){

 

$sql_get_worker = mysql_query("SELECT * FROM Worker WHERE id='$value'");

$get_worker = mysql_fetch_array($sql_get_worker);

 

$worker_firstname = $get_worker['firstname'];

$worker_lastname = $get_worker['lastname'];

 

$worker_options .= "<option value='$value'>$worker_firstname $worker_lastname</option>";

 

}

 

How about this then? There are two rows that return with this id, but yet only one is returning.

[Pikachu2000]

Each iteration of mysql_fetch_assoc() only retrieves one record. You need a while() loop if you're expecting the result set to be more than one record.

[lalnfl]

Now I see it. Thanks!