4WebHelp
 FAQ  •  Search  •  User Groups  •  Forum Admins  •  Smilies List  •  Statistics  •  Rules   •  Login   •  Register
Toggle Navigation Menu

 Timestamp at phpBB
Post New TopicReply to Topic
View Previous Topic Print this topic View Next Topic
Author Message
ZIN
Junior WebHelper
Junior WebHelper


Joined: 28 Aug 2006
Posts: 1

PostPosted: Mon Aug 28, 2006 2:47 pm (11 years, 3 months ago) Reply with QuoteBack to Top

Hello.

I'm trying to make a colun at my website that display the recent topics from a specific forum_id.

And then, to display the topic_title and topic_time in this colun.
Everything is ok, the topic_title apears and the link works fine, but the time is not working, it display the default timestamp 1970/1/1 too all the topics in the colun.

I already tried a lot of different things, i'm going to explain what i'm doing:

Code:
// This will make the SQL consult topic_id, topic_title, topic_time
// I rename topic_time to data and set UNIX_TIMESTAMP to topic_time
$resultNovidades = mysql_query("SELECT forum_id, topic_poster, topic_replies, topic_id, topic_title, UNIX_TIMESTAMP(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);


At my html page i display:
Code:
// gmdate because the GMT -3 from brazil.
<?echo gmdate("l Y m d - H:i:s", $data);?>


But it apears like it:
Code:
Thursday 1970 01 01 - 00:00:00
topic title


Now, how can i display the correct date from the first post???


Well, i'm getting crazy haha.


Thanks for the help.
OfflineView User's ProfileFind all posts by ZINSend Personal Message
Daniel
Team Member



Joined: 06 Jan 2002
Posts: 2564

PostPosted: Mon Aug 28, 2006 6:38 pm (11 years, 3 months ago) Reply with QuoteBack to Top

There's probably something wrong with the timestamp. If you try:

Code:
<? echo $data; ?>


what do you get?

________________________________
Image
OfflineView User's ProfileFind all posts by DanielSend Personal Message
adam
Forum Moderator & Developer



Joined: 26 Jul 2002
Posts: 704
Location: UK

PostPosted: Mon Aug 28, 2006 10:17 pm (11 years, 3 months ago) Reply with QuoteBack to Top

From the code you posted it's a little unclear what you've done with the MySQL result after the query. You've used $data, but where was that defined? I assume you have something similar to the following?

Code:
$resultNovidades_a = mysql_fetch_assoc($resultNovidades);
$data = $resultNovidades_a['data'];

________________________________
It's turtles all the way down...
OfflineView User's ProfileFind all posts by adamSend Personal MessageVisit Poster's Website
Display posts from previous:      
Post New TopicReply to Topic
View Previous Topic Print this topic View Next Topic


 Jump to:   




You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot edit your posts in this forum.
You cannot delete your posts in this forum.
You cannot vote in polls in this forum.


Page generation time: 0.051349 seconds :: 17 queries executed :: All Times are GMT
Powered by phpBB 2.0 © 2001, 2002 phpBB Group :: Based on an FI Theme