Re: dynamic calendar in flux-cms

>     $query="select * from ".$prefix."events order by von asc";
>
> to
>
>      $res = $GLOBALS['POOL']->db->query("select location, id,
> description, uri, title,
>         bis,
>         date_format(von,'%Y%m%dT%H%i%SZ') as von,
>         date_format(bis,'%Y%m%dT%H%i%SZ') as bis
>         from ".$tablePrefix."events");


i now did

//$query="select * from ".$prefix."events order by von asc";

$res = $GLOBALS['POOL']->db->query("select location, id, description,  
uri, title, bis, date_format(von,'%d%m%YT%H%i%SZ') as von, date_format 
(bis,'%d%m%YT%H%i%SZ') as bis from ".$tablePrefix."events");


meaning i uncommented the $query -line and the old $res-line. and  
changed the date format.

but the calendar didn't change... did i do something wrong?

another question:
which influence does the date_format in the query have on the output?  
i mean can i set the output that the date is shown in a "normal swiss  
format"?


thanx
adrian
-- 
bitflux-cms mailing list
[email protected]
http://lists.bitflux.ch/cgi-bin/listinfo/bitflux-cms