Nasihun Amin Suhardiyan Nasihun Amin Suhardiyan - 1 year ago 71
PHP Question

PHP Loop inside array

How can I loop inside an

in my code?

This is the static version of my script:

array("value" => "Male","label" => "Male"),
array("value" => "Female","label" => "Femal"),


Then, I need to retrieve the
from the database.

So I customized my previous code to:

while($h = mysql_fetch_array($qwery)){
array("value" => "$h[id]","label" => "$h[div]"),


When I run it I get this
Error message

Parse error: syntax error, unexpected 'while' (T_WHILE), expecting ')'

Can anyone help me?

I want to loop the join data from my database into :

input type="Select"

Answer Source

You can't use a loop directly as a value in an array. Instead, loop over and add each array for each iteration of the while-loop.

Using $div[] = "value", you add that value as a new element in that array.

$div = array(); // Initialize the array 

// Loop through results
while ($h = mysql_fetch_array($qwery)) { 
    // Add a new array for each iteration
    $div[] = array("value" => $h['id'], 
                   "label" => $h['div']);

This will create a two-dimensjonal array which would look (as an example) like

        "value" => "Male",
        "label" => "Male"
        "value" => "Female",
        "label" => "Female"

...which you then can look through with a foreach to do what you want with it.

If you want this to be output as options in a select-element, you could just do that directly

<select name="sel">
    while ($row = mysql_fetch_array($qwery)) { 
        echo '<option value="'.$row['id'].'">'.$row['div'].'</option>';
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download