| sabret00the |
01-24-2005 12:30 PM |
cross referencing a query with an array for a loop?
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? |
More Information