www.illinoisbmx.com
/////////////////////
// GET INFORMATION //
/////////////////////
$fullcountresult=$xoopsDB->query("select count(*) from ".$xoopsDB->prefix("xteams_sponsors")." where lid=$lid ");
list($s_numrows) = $xoopsDB->fetchRow($fullcountresult);
// $getsponsors = "select * from ".$xoopsDB->prefix("xteams_sponsors")." where lid=$lid order by sort ASC";
$getsponsors=$xoopsDB->query("select lid, sid, name, website, address, zip, city, state, country, phone, email, info, sort, logourl from ".$xoopsDB->prefix("xteams_sponsors")." where lid=$lid ORDER BY sort");
// $result=$xoopsDB->query($getsponsors);
while(list($s_lid,$s_sid,$s_name,$s_website,$s_address,$s_zip,$s_city,$s_state,$s_country,$s_phone,$s_email,$s_info,$s_sort,$s_logourl) = $xoopsDB->fetchRow($getsponsors))
{
$xoopsTpl->assign('x',array('s_lid' => $s_lid,'s_sid' => $s_sid,'s_sponsor' => $s_name,'s_website' => $myts->makeTboxData4Show($s_website),'s_logourl' =>$s_logourl,'s_numrows' => $s_numrows));
}
mysql_free_result($getsponsors);
/////////////////////
<!-- Start new link loop -->
<{section name=i loop=$x}>
<{$x[i].s_sponsor}><{$x[i].s_website}><br><{$x[i].s_logourl}>
<{/section}>
<!-- End new link loop -->
if ($xoopsUser && $xoopsUser->isAdmin($xoopsModule->mid()))
// If not submitter, redirect
if (!is_object($xoopsUser)) {
redirect_header('index.php',3,_US_NOEDITRIGHT);
exit();
}