include('../globalinc/include.inc.php');
$sql = "SELECT
o.objekt_id,
o.objekt_anbieter_id,
o.objekt_name as name,
kat.kategorien_name_de as rasse,
kla.klassen_name_de as tierart,
u.uploads_dateiname as bild,
b.basisattribute_charakter_de as charakter,
b.basisattribute_lebenslauf_de as lebenslauf,
b.basisattribute_besonderheiten_d as besonderheit,
to_char(o.objekt_timestamp, 'DD.MM.YYYY') as datum
FROM
basisattribute_tbl b,
kategorien_tbl kat,
klassen_tbl kla,
objekte_tbl o LEFT JOIN
uploads_tbl u
ON
u.uploads_objekt_id = o.objekt_id AND
u.uploads_vorschaubild = 't'
WHERE
kat.kategorien_id = o.objekt_kategorie_id AND
kla.klassen_id = o.objekt_klasse_id AND
b.basisattribute_objekt_id = o.objekt_id AND
o.objekt_herkunft_id = '2' AND -- Fundtier
o.objekt_anbieter_id > '0' AND
o.objekt_anbieter_id NOT BETWEEN '2' AND '3' AND
o.objekt_anbieter_id NOT BETWEEN '190' AND '191' AND
o.objekt_anbieter_id != '249' AND
o.objekt_vermittelt = 'f' AND
o.objekt_aktiv = 't' AND
age(o.objekt_timestamp) <= '2 weeks'
ORDER BY
o.objekt_timestamp DESC
;";
$res = dbquery($sql);
?>
Tiervermittlung.net
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
Tiervermittlung.net - Die größte Tiervermittlung im Netz Unter Schirmherrschaft des Deutschen Tierschutzbundes e.V. |
 |
 |
|
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
|
 |
 |
|
 |
 |
 |
 |
 |
include_once('banner_top.inc.php');
?>
 |
 |
 |
 |
 |
for ($i = 0; $i < $res->n; $i++):
$row = pg_fetch_object($res->e, $i);
if ($row->bild == "")
$row->bild = "img/nixda2.gif";
else
$row->bild = PICURL . $row->objekt_anbieter_id . "/" . $row->bild;
$link = "tiere_suchen.php?file=objectcard.php&o_id=" . $row->objekt_id;
?>
 |
 |
=$row->datum?> |
|
 |
 |
 |
 |
endfor;
?>
|
 |
 |
include('banner.inc.php');
?>
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
|