Subversion-Projekte lars-tiefland.content-management

Revision

Details | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
1 lars 1
<?
2
	function getShops($erfassung = NULL)
3
	{
4
		$buffer = array();
5
		$query = array();
6
 
7
		$query[] = "select ID, Name from shops";
8
 
9
		if (isset($erfassung))
10
		{
11
			$query[] = "where";
12
			$query[] = "erfassung = '$erfassung'";
13
		}
14
 
15
		$query[] = "order by ID";
16
 
17
		$result = mysql_query(implode(" ",$query)) or die (mysql_errno().": ".mysql_error().pre($query,true));
18
 
19
		while($r = mysql_fetch_array($result))
20
		{
21
			$buffer[$r["ID"]] = $r["Name"];
22
		}
23
		return $buffer;
24
	}
25
?>