Can i write two foreach in only one?

Question

In my code I have this:

$im  = $database->query("SELECT * FROM cms_messaggi_importanti WHERE messo_da = :id ORDER BY ID DESC", array("id"=>$functions->Utente("id")));
foreach($im as $imp){
    $mex_i  = $database->query("SELECT * FROM cms_messaggi WHERE id = :id ORDER BY ID DESC", array("id"=>$imp['id_mex']));
     foreach($mex_i as $mex_imp){ 
     }
}

Can I write this code in only one? Because I have to use a lot of variable with this method. Is there a solution to my problem? For example, using "JOIN"?

There are many MySQL guides and tutorials out there that will teach you how to write a simple JOIN. You should take the time to actually learn what you're doing instead of just copy/pasting what someone else gives you. — Patrick Q, Sep 08 '16 at 14:46
Duplicate: http://stackoverflow.com/questions/32061254/how-can-i-loop-through-two-arrays-at-once — Tommy, Sep 08 '16 at 14:48

score 0 · Accepted Answer · answered Sep 10 '16 at 20:24

You can (and should) do your query in one go, and then iterate over those results:

$im  = $database->query("
    SELECT    * 
    FROM      cms_messaggi_importanti mi
    LEFT JOIN cms_messaggi m ON m.id = mi.id_mex
    WHERE     messo_da = :id 
    ORDER BY  mi.ID DESC, 
              m.ID DESC", 
        array("id"=>$functions->Utente("id")));

foreach($im as $imp){
    //...
}

You will probably need to replace the SELECT * by a more precise column list, which will be the columns available in the result set.

Can i write two foreach in only one?

1 Answers1