Help in the date of last post in Threads
Asked Modified Viewed 3,127 times
asked
I need help in calculating the date of the last post to today's date
like
If time is more than 360 days display the following code
bla bla bla
else {
echo "bla bla bla ";
}
help me with coding this
like
If time is more than 360 days display the following code
bla bla bla
else {
echo "bla bla bla ";
}
help me with coding this
GMUDuckman
GMUDuckman 10
- Senior Member, joined since
- Contributed 266 posts on the community forums.
- Started 6 threads in the forums
http://forums.mysql.com/read.php?52,2...#msg-24052
this should help
this should help
Edited by GMUDuckman on 08-11-2010 05:05,
answered
i want this but not work where is the wrong
[syntaxhighlighter brush=plain,first-line=1,highlight=0,collapse=false,html-script=false]$result = dbquery(
"SELECT p.*
FROM ".DB_POSTS." p
WHERE p.thread_id='".$_GET['thread_id']."' ORDER BY post_datestamp "
);
$tt = time()-$data['post_datestamp'];
if (dbrows($result)){
if ($tt < 86400 ) {
echo "<td align='center' class='tbl2'><label>bla bla</label></td>\n";
}else{
echo "";
}
}[/syntaxhighlighter]
[syntaxhighlighter brush=plain,first-line=1,highlight=0,collapse=false,html-script=false]$result = dbquery(
"SELECT p.*
FROM ".DB_POSTS." p
WHERE p.thread_id='".$_GET['thread_id']."' ORDER BY post_datestamp "
);
$tt = time()-$data['post_datestamp'];
if (dbrows($result)){
if ($tt < 86400 ) {
echo "<td align='center' class='tbl2'><label>bla bla</label></td>\n";
}else{
echo "";
}
}[/syntaxhighlighter]
Edited by PHPar on 08-11-2010 07:34,
GMUDuckman
GMUDuckman 10
- Senior Member, joined since
- Contributed 266 posts on the community forums.
- Started 6 threads in the forums
gotta have $data = dbarray($result) before you can use $data['post_datestamp']
Edited by GMUDuckman on 08-11-2010 16:09,
answered
hmm still not work
GMUDuckman
GMUDuckman 10
- Senior Member, joined since
- Contributed 266 posts on the community forums.
- Started 6 threads in the forums
after $data = dbarray($result) and $tt = time()-$data['post_datestamp']; write this:
[syntaxhighlighter brush=php,first-line=1,highlight=0,collapse=false,html-script=false]echo "$tt - ".time()." - ".$data['post_datestamp'];[/syntaxhighlighter]
you should have values for for all 3 variables, if not, this display should help you determine which variable is the troublesome one.
[syntaxhighlighter brush=php,first-line=1,highlight=0,collapse=false,html-script=false]echo "$tt - ".time()." - ".$data['post_datestamp'];[/syntaxhighlighter]
you should have values for for all 3 variables, if not, this display should help you determine which variable is the troublesome one.
Category Forum
Modifications and Requests - 8Labels
None yet
Statistics
- Views 0 views
- Posts 5 posts
- Votes 0 votes
- Topic users 2 members
2 participants
PHPar 10
- Member, joined since
- Contributed 118 posts on the community forums.
- Started 7 threads in the forums
- Started this discussions
GMUDuckman 10
- Senior Member, joined since
- Contributed 266 posts on the community forums.
- Started 6 threads in the forums
Notifications
Track thread
You are not receiving notifications from this thread.
Related Questions