Subversion-Projekte lars-tiefland.php_share

Revision

Details | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
3 lars 1 
<?
2 
	function getNews($limit="",$id="")
3 
	{
4 
		$query="
5 
			SELECT
6 
				*,
7 
				IF (bild_1_url ='', NULL, concat('<img src=".$_SESSION['INI']['news']['imagePath']."1/',bild_1_url,'>')) as bild_1_url,
8 
				IF (bild_2_url ='', NULL, concat('<img src=".$_SESSION['INI']['news']['imagePath']."2/',bild_2_url,'>')) as bild_2_url,
9 
				DATE_FORMAT(gueltig_von,'%d.%m.%Y') as Datum
10 
			FROM
11 
				news
12 
			WHERE
13 
				NOW() BETWEEN gueltig_von AND gueltig_bis
14 
				AND
15 
				shops_ID = ".$_SESSION['INI']['shops_ID']."
16 
				$id
17 
			ORDER BY
18 
				gueltig_von desc
19 
		";
20 
		if (!empty($limit))
21 
		{
22 
			$query=$query." limit ".$limit;
23 
		}
24 
 
25 
		$buffer=array();
26 
		$result = mysql_query ($query) or die (mysql_errno().": ".mysql_error()."<hr>$query<hr>");
27 
		while($zeile=mysql_fetch_assoc($result))
28 
		{
29 
			$buffer[]=$zeile;
30 
		}
31 
		return $buffer;
32 
	}
33 
?>