How to insert data into a div using a foreach statement.

[shyam13]

How do I insert data which I retrieved from the database using a select statement and then using a for each loop insert the data into separate divs,

so far I have used a select statement to get the data but I am struggling to use the for each loop to insert the data into separate divs.

 

Any ideas anyone?

 

 

[Psycho]

while($row = mysql_fetch_assoc($result))
{
    echo "<div>\n";
    echo "{$row['field_name1']}<br>\n";
    echo "{$row['field_name2']}<br>\n";
    echo "{$row['field_name3']}<br>\n";
    echo "</div>\n";
}

[scootstah]

You need to use a while() loop. A foreach() loop is used to iterate through an array, and would only work if you only have one result to loop through.

 

$query = mysql_query("SELECT * FROM table");

while($row = mysql_fetch_assoc($query)) {
echo '<div>' . $row['column'] . '</div>';
}

[shyam13]

If I use this method, Would it be able to create a new div for each element?

[scootstah]

Why don't you try it and see for yourself?

 

The best way to learn something in programming is by experimenting.

[Psycho]

If I use this method, Would it be able to create a new div for each element?

 

Did you even look at the code we provided? What we both provided was very, very simple logic.