Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New to the CF scene
    Join Date
    Aug 2006
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    A strange timestamp do not convert

    hello.

    I'm using phpbb, and the phpbb store the date with timestamp, but this timestamp is sotered with the GMT. So the problem is this:

    - I would like to create a colun at my website with the recent's topics at a board in my phpbb, so i do it right, everything was ok, but when i want to display the date from the topic, it returns a timestamp format the: 1133027084
    - At the php code, i write:
    PHP Code:
    $resultNovidades = mysql_query("SELECT forum_id, topic_poster, topic_replies, topic_id, topic_title, topic_time as data FROM phpbb_topics WHERE forum_id = '19' ORDER BY topic_time DESC LIMIT 9", $connection) or die("Não foi possível conectar, erro em Novidades.");
    $recordcountNovidades = mysql_num_rows($resultNovidades);
    <?echo $row['data']?>
    It returns the timestamp, how can i show this date with the (GMT -3) at a goof format as d/m/y???/

    Thanks a lot and sorry about my english!

  • #2
    UE Antagonizer Fumigator's Avatar
    Join Date
    Dec 2005
    Location
    Utah, USA, Northwestern hemisphere, Earth, Solar System, Milky Way Galaxy, Alpha Quadrant
    Posts
    7,691
    Thanks
    42
    Thanked 637 Times in 625 Posts


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •