Serving XOOPSers in the Nordic Countries

XOOPS NORDIC

Nordic Support Site for XOOPS CMS

Login

Username:

Password:

Remember me



Lost Password?

Register now!

Who's Online

11 user(s) are online (6 user(s) are browsing Forum)

Members: 0
Guests: 11

more...

New Members

driftmass 2010/9/7
docosma 2010/9/3
loniexoo 2010/9/3
Stuartbinn 2010/9/1
andeny 2010/8/24
davie_018 2010/8/21
Greek 2010/8/20
Kamlesh 2010/8/18
hilly3625 2010/8/4
AndySmiths 2010/7/30
http://tracking.euroads.dk/system/tracking.php?sid=1&cpid=2179&adid=346138&acid=1375&eatrackid=1060






Fra SQL til block
Webmaster
Joined:
2008/7/11 16:29
Posts: 271
Jeg har for en gangs skyld ikke selv svaret.

Problemet er at jeg har SQL-requestet
Quote:

SELECT *
FROM `præfiks_extcal_event`
ORDER BY `event_approved` DESC
LIMIT 0 , 1


Her får jeg den record jeg ønsker at indhold fra i en blok.

event_approved er i UNIX format (sekunder efter 1970)

Denne dato ønsker jeg at få vist i DD-MM-ÅÅÅÅ i en blok.

Er der nogen smart løsning, eller skal jeg absolut hacke i modulet (extcal)?

Posted on: 1/21 20:09
Transfer the post to other applications Transfer


Re: Fra SQL til block
Webmaster
Joined:
2008/7/11 16:29
Posts: 271
Gik lige en omvej.
Rettede i RSS feed på extcal, så den viser last approved og ikke hvornår eventen finder sted.

XHLD0 modulet til at læse RSS feed

www.roarhytten.dk i højre nederste blok

Posted on: 1/21 21:52
Transfer the post to other applications Transfer


Re: Fra SQL til block
Module Developer
Joined:
2008/9/11 18:19
From Skagen
Posts: 86
$timestamp = "1265090400";
$datetime = date("d-m-Y", $timestamp);
echo $datetime;
// echo "02-02-2010" egentlig 02-02-2010 @ 00:00:00 men det er den du skal bruge :)

Posted on: 2/2 12:07
_________________
..~~¨¨ Make it idiot proof and someone will make a better idiot ¨¨~..
Transfer the post to other applications Transfer






You can view topic.
You cannot start a new topic.
You cannot reply to posts.
You cannot edit your posts.
You cannot delete your posts.
You cannot add new polls.
You cannot vote in polls.
You cannot attach files to posts.
You cannot post without approval.

[Advanced Search]


Translate to other languages
 
Create a XOOPS module
This site have PageRank
Min PageRank!
Powered by Danordesign

Suomen webmaster?

Tarvitsemme suomi webmaster hallinnoida suomi osa XOOPS Nordic. Ota meihin yhteyttä, jos olet kiinnostunut!