<?php echo $llpaging; ?> </div> <!-- closes postbox--> </div> <!-- closes contenttab--> <div class="contenttabpeer"> <br /><br /><br /> <div class="peergroup"> <?php mostlikelifestyle($lifestylelid); echo $peergroup; } // closes last elseif ?> </div> <!-- closes peergroup --> </div> <!-- closes contettabpeer --> <br /> <br /> </div> <!-- closes right box-->
function pergroupdplay($lifestyleid, $feedid) { global $ppeergroup; global $peergroup; // input, need to know what lifestyle is in context (and if ll on multiple lifestlye then produce peer group on those priorities e.g. yoga flitered to those post authored by a triathlete) $lifeid = $lifestyleid; //$lifeid = 1; //$feedid = 1; if ($feedid == 598) { //echo 'dispaly aveage'; // average then list peers from daily peers mostlikelifestyle($lifestyleid); echo $peergroup; } else { // user has feedid then get personalized peers on that basis // need to combine with feeds to get url info for each to be able to display. Also maybe save personalized peer grounds in a new table? $db->query = "SELECT * FROM " . RSSDATA . ".perpeers LEFT JOIN " . RSSDATA . ".feeds ON " . RSSDATA . ".feeds.id = " . RSSDATA . ".perpeers.peerid WHERE " . RSSDATA . ".perpeers.idlifestart = '{$lifeid}' AND " . RSSDATA . ".perpeers.feedid = '{$feedid}' "; //echo $db->query; // eat the last comma //$db->query =substr($db->query,0,(strLen($db->query)-2));//this will eat the last or $db->query .= " LIMIT 50"; //echo $db->query; $resultppeer = mysql_query($db->query) or die(mysql_error()); $ppeergroup = ''; if (mysql_num_rows($resultppeer) > 0) { $ppeergroup .= "<img src=\"/lifestylelinking/images/peergroup.gif\">"; // display search results $ppeergroup .= "<table width=\"100\" border=\"1\" style='table-layout:fixed' >"; $nocolumns = 5; //column width //$colwidth = (int)(100/$nocolumns); $colwidth = 25; $i = 0; while ($row = mysql_fetch_object($resultppeer)) { if ($i % $nocolumns == 0) { // start a new row $peergroup .= "<tr>"; } $noproducts = mysql_num_rows($resultppeer); $norows = ceil($noproducts / $nocolumns); //echo $norows; if ($noproducts > 1) { $imagef = $row->image; } //$imagef = "/images/meico.gif"; if (strlen($imagef) == 0) { $imagef = "/lifestylelinking/images/meico.gif"; } $ppeergroup .= "<td width = " . $colwidth . " ><a href=\"" . $row->url . "\"><img src=\"" . $imagef . "\" alt=\"" . $row->url . "\" width=\"16\" height=\"16\"></a> <br /></td>"; if ($i % $nocolumns == $nocolumns - 1) { //end this row $ppeergroup .= "</tr>"; } $i += 1; } //print blank columns if ($i % $nocolumns != 0) { while ($i++ % $nocolumns != 0) { $ppeergroup .= "<td width = " . $colwidth . "'%'> </td>"; } $ppeergroup .= "</tr>"; } $ppeergroup .= "</table>"; } // closes if } // closes else }