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]?

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:

// 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 :)