cross referencing a query with an array for a loop?

[sabret00the]

can this be done?

the query pulls out the information from the database using the $grps_ids array to limit the information, then the foreach sorts the information pulling it from the database and if i've done it right the template will echo out the information i require via $grps_mygroupinfo[value]?

PHP Code:

        if (!empty($bbuserinfo[grps]))
           {
               $grps_ids_imploded = implode(",", $grps_ids);
   
               $grps_mygroupsinfo = $DB_site->query("
              SELECT grps.groupid, grps.title, grps.description, grps.approved, grps.leaderid, grps_setting.image_name
                   FROM grps
              LEFT JOIN " . TABLE_PREFIX . "user ON (user.userid = grps.leaderid)
              LEFT JOIN grps_setting ON (grps_setting.groupid = grps.groupid)
              WHERE grps.approved=1 AND grps.groupid IN($grps_ids_imploded)
               ");
   //                ORDER BY grps.title ASC
       
               $mygroupscounter = 0;
             foreach($grps_ids AS $grps_mygroupsid => $grps_mygroupsinfo)
               {
               //$mygroup = $DB_site->fetch_array($grps_mygroup);
              $grps_mygroupsinfo['image_name'] = iif($grps_mygroupsinfo[image_name], TRUE, "<img src=\"" . $stylevar[imgdir_grps] . "/grps_mygroups_noimage.gif\" alt=\"" . $grps_mygroupsinfo[title] . "\" border=\"0\" />");
              $grps_mygroupsinfo['leader'] = iif($grps_mygroupsinfo[leaderid] == $grps_mygroupsinfo[userid], TRUE, "<img src=\"" . $stylevar[imgdir_grps] . "/grps_leader.gif\" alt=\"" . $grps_mygroupsinfo[title] . " Leader\" border=\"0\" />");
              eval('$grps_mygroupsbits .= "' . fetch_template("groups_groupshome_mygroupsbits") . '";');
                 //echo "<!-- ".print_r($mygroup, TRUE)." -->";
                   $mygroupscounter++;
                   if ($mygroupscounter % 4 == 0)
                   {
                  $grps_mygroupsbits .= "<br />";
                   }
               }
           }
           else
           {
               if ($bbuserinfo[userid])
               {
              $grps_mygroupsbits = $bbuserinfo[username] . ", You Are Not Subscribed To Any " . $vboptions[hometitle] . " Groups At Present!";
               }
               else
               { //guest message
              $grps_mygroupsbits = "You must be a member in order to use " . $vboptions[hometitle] . " Groups<br /><br />If you would like to register for " . $vboptions[hometitle] . " please click <a href=\"" . $vboptions[bburl] . "/register.php? " . $session[sessionurl] . "\">here</a>";
               }
           } 


never done this before and got confused by php.net and they never cross referenced it with a query there either, but i was originally taught how to do this for making a calender drop down so it don't help much.

this is only returning the number 1?

[Marco van Herwaarden]

Use the following syntax:

PHP Code:

// Assign select query to rowset
$rowset = $DB_site->query("SELECT *  FROM " . TABLE_PREFIX . "table");
while ($row = $DB_site->fetch_array($rowset))
{
  // Process row
  echo "$row[column]";
} 


[sabret00the]

thank you so much marco, you really really really helped me.

i guess i'll have to learn using foreach() with queries another day

thank you again