Ответов: 4 Просмотров: 2758
|
[img][/img]
\\Кто может помогите добавить навигацию (странички) что бы выводились не все записи, а по 10
\\вот код таблицы
PHP:
скопировать код в буфер обмена
<table id="calendar" cellpadding="0" cellspacing="0" class="jsnoborders"> <?PHP for($i=0;$i<count($this->matshes);$i++){ $match = $this->matshes[$i]; ?> <tr> <td class="m_name" nowrap="nowrap"><?PHP echo $match->m_name.":"?></td> <td nowrap="nowrap"><?PHP echo date_bl($match->m_date,$match->m_time);?></td> <td class="team_thome"><?PHP echo $match->home?></td> <td class="match_result" nowrap="nowrap"> <?PHP if($match->m_played == 1){ echo $match->score1?> : <?PHP echo $match->score2; if($this->enbl_extra && $match->is_extra){ echo " ";} }else{ echo " - : - "; } ?> </td> <td class="team_taway"><?PHP echo $match->away?></td> <td class="match_details"> <a href="<?PHP echo JRoute::_('index.php?option=com_joomsport&task=view_match&id='.$match->mid.'&Itemid='.$Itemid).'">'.$this->bl_lang['BL_LINK_DETAILMATCH'].' '?></a> </td> </tr> <?PHP } ?> </table>
Вот запрос матчей в БД
CODE ( SQL):
скопировать код в буфер обмена
$query = "SELECT md.m_name,m.id as mid,m.m_date,m.m_time, t1.t_name as home, t2.t_name as away, score1,score2,m.is_extra, m.m_played FROM #__bl_matchday as md, #__bl_match as m, #__bl_teams as t1, #__bl_teams as t2 WHERE m.m_id = md.id AND m.published = 1 AND (m.team1_id = ".$team_id." OR m.team2_id = ".$team_id.") AND m.team1_id = t1.id AND m.team2_id = t2.id ORDER BY m.m_date,m.m_time"; $db->setQuery($query); $matshes = $db->loadObjectList();
************************************************************* |