Lav koden om til at række over 14 dage

hvis det er mysql:


SELECT * FROM [tbl_name]
-> WHERE DATE_ADD(CURDATE(),INTERVAL 14 DAY) <= [Dato];

hmmm hvad siger den hvis du brænder det direkte af i din mysql, og må jeg se det du skriver ?


SELECT * FROM [tbl_name]
WHERE DATE_ADD(CURDATE(),INTERVAL 14 DAY) <= [Dato];

Der skal ikke være den -> ved linie skift

/J

Kode 

			case 'by_day':
				$query = $select.' SELECT * FROM [tbl_name]
                  WHERE DATE_ADD(CURDATE(),INTERVAL 14 DAY) <= [Dato] AND;'.$published.$order;
				 break;

Kode 

$select = 'SELECT DAY(historicdate) as theday,MONTH(historicdate) as themonth, YEAR(historicdate) as theyear, historicdate as thedate,title,description'.' FROM #__efemerides WHERE';

Kode 

<?php
/**
 * Efemerides Model for Efemerides Component
 * 
 * @package    Efemerides
 * @subpackage Components
 * @link http://revolucionemosoaxaca.org
 * @license    GNU/GPL
 */

// Check to ensure this file is included in Joomla!
defined('_JEXEC') or die();

jimport( 'joomla.application.component.model' );

/**
 * Efemerides Model
 *
 * @package    Efemerides
 * @subpackage Components
 */
class EfemeridesModelEfemerides extends JModel
{
    /**
    * Gets the greeting
    * @return string The greeting to be displayed to the user
    */
	
	function putFormattedDate($list)
	{
		jimport( 'joomla.utilities.date' );
  	        $config =& JFactory::getConfig();
                $offset = $config->getValue('config.offset' );
		foreach ($list as $l)
		{
			$date = new JDate( $l->thedate, $config->getValue('config.offset' ));
			$l->formatteddate = JHTML::_('date', $date->toFormat(), JText::_('DATE_FORMAT_LC'));
			$newlist[] = $l;
		}
		return $newlist;
	}

	function getEfemerides($date_range)
    {
        $db =& JFactory::getDBO();
	$published = ' published=1';
		$select = 'SELECT DAY(historicdate) as theday,MONTH(historicdate) as themonth, YEAR(historicdate) as theyear, historicdate as thedate,title,description'.' FROM #__efemerides WHERE';
		$order = ' ORDER BY MONTH(historicdate),DAY(historicdate),YEAR(historicdate)';
		$query = ''.$select.$published.$order;
		switch($date_range)
		{
			case 'by_day':
				$query = $select.' SELECT * FROM [tbl_name]
                  WHERE DATE_ADD(CURDATE(),INTERVAL 14 DAY) <= [Dato] AND;'.$published.$order;
				 break;
			 case 'by_month':
				 $query = $select.' MONTH(NOW())=MONTH(historicdate) AND'.$published.$order;
				 break;
			case 'by_year':
				$query = ''.$select.$published.$order;
				break;
	    }		
		$db->setQuery($query);
		$db->query();
		$efemerides = $db->loadObjectList();
		$efemerides = $this->putFormattedDate($efemerides);
		//print_r($efemerides);
		return $efemerides;
    }
}
?>

Kode 

<?php
/**
 * @package    Efemerides
 * @subpackage Components
 * @link http://revolucionemosoaxaca.org
 * @license    GNU/GPL
*/

// no direct access

defined( '_JEXEC' ) or die( 'Restricted access' );

jimport( 'joomla.application.component.view');

/**
 * HTML View class for the Efemerides Component
 *
 * @package    Efemerides
 */

class EfemeridesViewEfemerides extends JView
{	
	
    function display($tpl = null)
    {
		$params = &JComponentHelper::getParams( 'com_efemerides' );

		//print_r($params->get('range_to_see'));
		
        $model =& $this->getModel();
		$efemerides = $model->getEfemerides($params->get('date_range'));

	$title = $params->get('optional_title');
/*	if (strcmp($title,"") == 0){
     		$tile = 'Efemerides Today';
   	}*/
		
		
        $this->assignRef( 'efemerides', $efemerides );
		$this->assignRef( 'formatted', $params->get('formatted_date'));
	$this->assignRef( 'title', $title);
        parent::display($tpl);
    }
}
?>

Kode 

<?php // no direct access
defined('_JEXEC') or die('Restricted access'); ?>
<h1><?php echo JText::_($this->title); ?></h1>
<?php
	$n=count($this->efemerides);
	if ($n<=0)
    {	
  ?>
  <h2> <?php echo JText::_('Der er ingen tekster at vise.'); ?></h2>
<?php 
    } else {
   ?>
<table>
	<thead>
	  <tr>
		<th>
			<?php echo JText::_( 'Dato' ); ?>
		</th>
		<th>
			<?php echo JText::_( 'Titel' ); ?>
		</th>		
		<th>
			<?php echo JText::_( 'Beskrivelse' ); ?>
		</th>
	  </tr>
	</thead>
	<?php
		
		for ($i=0; $i < $n; $i++)
		{
			$row = &$this->efemerides[$i];
			?>
				<tr>
					<td>
						<?php
						if ($this->formatted=='1')
						{
						  echo $row->formatteddate; 
						}
						else
						{
						  echo $row->theday."/".$row->themonth."/".$row->theyear;
						  
						}							
							?>
					</td>
					<td>
						<?php echo $row->title; ?>		
					</td>
					<td>
					 <?php echo $row->description; ?>
					</td>
				</tr>				
			<?php
		}
    ?>
</table>
<?php
	}
	?>