Echo separate array results as part of a MySql query PHP foreach loop

Question

I'm sure this is simple but I can't figure it out. I'm running a php foreach loop to echo out results from a MySQL query into individual DIV containers. The Divs are various sizes determined by CSS classes. I'm trying to put the order of classes into the foreach loop to format the DIVs as they are generated from the loop.

I control how many results come from the MySql query so can ensure the separate array has one item per result. The array looks like this

$flex = array("large", "large", "small", "small", 
"small-third", "small-third", "small", "small", "large", "large", );

And this is an example of how I'm doing my foreach loop:

        foreach ($result AS $row) {
    
        $title = $row['title'];
        $under_image = $row['under_image'];
        $over_image = $row['over_image'];
        
        echo '<div class="'. $flex .'"> 
    <p>'. $title .'</p>
    </div>'}

Where $flex would actually pull the next result from the array. How would I achieve this?

Hope that's clear, thanks for the help.

Dwight · Accepted Answer · 2022-03-10 22:31:08Z

1

foreach($result as $key=>$row){
...your code, 

echo '<div class="'. $flex[$key] .'"> 
...rest of your code
}

answered Mar 10, 2022 at 22:31

Dwight

721 silver badge6 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

themeparkfocus Over a year ago

That appears to have worked, thank you. I would have never figured it out. Now to study it so I understand how it works. Thanks again!

Dwight Over a year ago

for reference $key is index of array, in this case $result array.

Collectives™ on Stack Overflow

Echo separate array results as part of a MySql query PHP foreach loop

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related