[PHP] pobierz, plaintext 
<?php
$announcements = new announcements();
$select = $announcements->select()->where('date BETWEEN '.$time.' AND '.time().'')->order('id DESC');
?>
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
<?php
$announcements = new announcements();
$select = $announcements->select()->where('date BETWEEN '.$time.' AND '.time().'')->order('id DESC');
echo 'liczba rekordów: ' . count($select);
?>
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
<?php
class Announcements extends Zend_Db_Table {
    protected $_name = 'announcements';
}
?>
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
<?php
$announcements = new announcements();
        $time = time() - $time_from_base; // pod tą drugą zmienną jest czas z bazy (w sekundach) (tzn. ile czasu mają być wyświetlane ogłoszenia)
        $select = $announcements->select()->where('date BETWEEN '.$time.' AND '.time().'')->order('id DESC');
        $this->view->ilosc = count($select); // dopisane
        $paginator = Zend_Paginator::factory($select)->setCurrentPageNumber($this->_getParam('page'))->setItemCountPerPage($announcementsPerPage)->setPageRange(5);
        $this->view->paginator = $paginator;
?>
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
<?php
$select = $announcements->select()->where('date BETWEEN '.$time.' AND '.time().'')->order('id DESC');
        $this->view->countannouncements = count($announcements->fetchAll($select));
?>
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
<?php
$countannouncements = count($announcements->fetchAll($select)); // ilość rekordów
            if ($countannouncements % 2 == 0) {
                $this->view->styleannouncements = 'announcements_link_1'; // klasa stylu
            } else {
                $this->view->styleannouncements = 'announcements_link_2'; // klasa stylu
            }
?>
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
<?php for ($i = 0; $i < $this->countannouncements; $i++) : ?>
                <?php if ($i % 2 == 0) : ?>
                    <tr class="announcements_link_1">
                        <td style="padding: 5px 10px 5px 10px;"><a href="<?php echo $this->baseUrl; ?>/announcements/show/id/<?php echo $row->id; ?>" style="display: block;"><?php echo $row->title; ?></a></td>
                        <td style="padding: 5px 10px 5px 10px;"><a href="<?php echo $this->baseUrl; ?>/announcements/show/id/<?php echo $row->id; ?>" style="display: block;"><?php $date = $row->date; echo date('d.m.Y', $date).'r.'. date(', H:i', $date); ?></a></td>
                    </tr>
                <?php else : ?>
                    <tr class="announcements_link_2">
                        <td style="padding: 5px 10px 5px 10px;"><a href="<?php echo $this->baseUrl; ?>/announcements/show/id/<?php echo $row->id; ?>" style="display: block;"><?php echo $row->title; ?></a></td>
                        <td style="padding: 5px 10px 5px 10px;"><a href="<?php echo $this->baseUrl; ?>/announcements/show/id/<?php echo $row->id; ?>" style="display: block;"><?php $date = $row->date; echo date('d.m.Y', $date).'r.'. date(', H:i', $date); ?></a></td>
                    </tr>
                <?php endif; ?>
            <?php endfor; ?>
[PHP] pobierz, plaintext 

Cytat(in5ane @ 16.07.2009, 16:48:53 )

[PHP] pobierz, plaintext 
<?php
$announcements = new announcements();
$select = $announcements->select()->where('date BETWEEN '.$time.' AND '.time().'')->order('id DESC');
?>
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
<?php
$announcements = new announcements();
$select = $announcements->select()->where('date BETWEEN '.$time.' AND '.time().'')->order('id DESC');
$odp=$announcements->fetchAll($select)->count();
?>
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
<?php
$announcements = new announcements();
$select = $announcements->select()->where('date BETWEEN '.$time.' AND '.time().'')->order('id DESC') -> columns(
array( 'count' => new Zend_Db_Expr('COUNT(*)'));
$odp=$announcements->fetchRow($select);
?>
[PHP] pobierz, plaintext