Hello everyone,

I am very new to PHP and MySQL. I am currently following a tutorial and having couples of errors but I manage to solve most of them.
But there is one last thing to be completed. The tutorial is on a 'Simple Forum Board'. Actually, I do not know how to describe this problem technically and precisely but I can explain by an example.

Whenever a 'New Topic' is created, the author name, time and date of the post will be displayed. Let say the author posting time is March 8, 2012, 10.20am. When another person reply to the topic at let say March 9, 2012, 4.50pm, the author posting time will change to March 9, 2012, 4.50pm as well. Meaning to say, the author posting time will change and same as the posting time of the last poster. I have put my best effort and did not find any solution yet.

Here's the code
Index code
PHP Code:
<?php 

include "connect.php"//mysql db connection here

print "<link rel='stylesheet' href='style.css' type='text/css'>";

print 
"<A href='post.php'>New Topic</a><br>";

print 
"<table class='maintable'>";

print 
"<tr class='headline'><td width=50%>Discussion Topic</td><td width=20%>Author</td><td>Replies</td><td>Last replied time</td></tr>";

$getthreads="SELECT * from forum where parentid='0' order by postid DESC";

$getthreads2=mysql_query($getthreads) or die("Could not get threads");


while(
$getthreads3=mysql_fetch_array($getthreads2))

{

  
$getthreads3['title']=strip_tags($getthreads3['title']);

  
$getthreads3['author']=strip_tags($getthreads3['author']);
 
  print 
"<tr class='mainrow'><td><a href='message.php?id=$getthreads3[postid]'>$getthreads3[title]</a></td><td>$getthreads3[author]</td><td>$getthreads3[numreplies]</td><td>
$getthreads3[showtime]<br>Last post by <b>$getthreads3[lastposter]</b></td></tr>";

}

print 
"</table>";



?>  

<a href="forum.php?"><img src="image/button_back1.gif" border="0" align="right"/></a>

Post code
PHP Code:
<?php

include "connect.php"//connection string

print "<link rel='stylesheet' href='style.css' type='text/css'>";

print 
"<table class='maintables'>";

print 
"<tr class='headline'><td>Post a message</td></tr>";

print 
"<tr class='maintables'><td>";

if(isset(
$_POST['submit']))

{

   
$name=$_POST['name'];

   
$yourpost=$_POST['yourpost'];

   
$subject=$_POST['subject'];

   if(
strlen($name)<1)

   {

      print 
"You did not type in a name."//no name entered

   
}

   else if(
strlen($yourpost)<1)

   {

      print 
"You did not type in a post."//no post entered

   
}

   else if(
strlen($subject)<1)

   {

      print 
"You did not enter a subject."//no subject entered

   
}

   else

   {
       
date_default_timezone_set('Asia/Brunei');
       
$thedate=date("U"); //get unix timestamp
    
      
$displaytime=date("F j, Y, h:i a");

      
//we now strip HTML injections

      
$subject=strip_tags($subject);

      
$name=strip_tags($name);

      
$yourpost=strip_tags($yourpost); 

      
$insertpost="INSERT INTO elec_forum(author,title,post,showtime,realtime,lastposter) values('$name','$subject','$yourpost','$displaytime',$thedate,'$name')";

      
mysql_query($insertpost) or die("Could not insert post"); //insert post

      
print "Message posted, go back to <A href='elec_forum.php'>Forum</a>.";

   }



}

else

{

   print 
"<form action='elec_post.php' method='post'>";

   print 
"Your name:<br>";

   print 
"<input type='text' name='name' size='20'><br>";

   print 
"Subject:<br>";

   print 
"<input type='text' name='subject' size='20'><br>";

   print 
"Your message:<br>";

   print 
"<textarea name='yourpost' rows='5' cols='40'></textarea><br>";

   print 
"<input type='submit' name='submit' value='submit'></form>";



}

print 
"</td></tr></table>";

?>
Reply code
PHP Code:
<?php

include "connect.php"//connection string

print "<link rel='stylesheet' href='style.css' type='text/css'>";

print 
"<table class='maintables'>";

print 
"<tr class='headline'><td>Reply</td></tr>";

print 
"<tr class='maintables'><td>";

if(isset(
$_POST['submit']))

{

   
$name=$_POST['name'];

   
$yourpost=$_POST['yourpost'];

   
$subject=(isset($_POST['subject']))?$_POST['subject']:null;;

   
   
$id=$_POST['id'];

   if(
strlen($name)<1)

   {

      print 
"You did not type in a name."//no name entered

   
}

   else if(
strlen($yourpost)<1)

   {

      print 
"You did not type in a post."//no post entered

   
}

   else

   {
      
date_default_timezone_set('Asia/Brunei');
      
$thedate=date("U"); //get unix timestamp

      
$displaytime1=date("F j, Y, h:i a");

      
//we now strip HTML injections

      
$subject=strip_tags($subject);

      
$name=strip_tags($name);

      
$yourpost=strip_tags($yourpost); 

      
$insertpost="INSERT INTO elec_forum(author,title,post,showtime,realtime,lastposter, parentid) values('$name','$subject','$yourpost','$displaytime1','$thedate','$name','$id')";

      
mysql_query($insertpost) or die("Could not insert post"); //insert post

      
$updatepost="Update elec_forum set numreplies=numreplies+'1', lastposter='$name', showtime='$displaytime1',lastrepliedto='$thedate' where postid='$id'";

      
mysql_query($updatepost) or die("Could not update post");
      print 
"Message updated, go back to <A href='elec_message.php?id=$id'>Message</a>.";

   }



}

else

{

   
$id=$_GET['id'];

   print 
"<form action='elec_reply.php' method='post'>";

   print 
"<input type='hidden' name='id' value='$id'>";

   print 
"Your name:<br>";

   print 
"<input type='text' name='name' size='20'><br>";

   print 
"Your message:<br>";

   print 
"<textarea name='yourpost' rows='5' cols='40'></textarea><br>";

   print 
"<input type='submit' name='submit' value='submit'></form>";



}

print 
"</td></tr></table>";

?>
Message code
PHP Code:
<?php 

include "connect.php"//mysql db connection here

$id=(isset($_GET['id']))?$_GET['id']:null;;


print 
"<link rel='stylesheet' href='style.css' type='text/css'>";

print 
"<A href='elec_forum.php'>Back to main forum</a>-<A href='post.php'>New Topic</a>-<A href='elec_reply.php?id=$id'>Reply<br>";

print 
"<table class='maintable'>";

print 
"<tr class='headline'><td width=20%>Author</td><td width=80%>Post</td></tr>";

$gettopic="SELECT * from forum where postid='$id'";

$gettopic2=mysql_query($gettopic) or die("Could not get topic");

$gettopic3=mysql_fetch_array($gettopic2);

print 
"<tr class='mainrow'><td valign='top'>$gettopic3[author]</td><td valign='top'>Last replied to $gettopic3[showtime]<br><hr>";

$message=strip_tags($gettopic3['post']);

$message=nl2br($message);

print 
"$message<hr><br>";

print 
"</td></tr>";

$getreplies="Select * from forum where parentid='$id' order by postid DESC"//getting replies

$getreplies2=mysql_query($getreplies) or die("Could not get replies");

while(
$getreplies3=mysql_fetch_array($getreplies2))

{

   print 
"<tr class='mainrow'><td valign='top'>$getreplies3[author]</td><td valign='top'>Last replied to $getreplies3[showtime]<br><hr>";

   
$message=strip_tags($getreplies3['post']);

   
$message=nl2br($message);

   print 
"$message<hr><br>";

   print 
"</td></tr>";

}

print 
"</table>";



?>
Connect code
PHP Code:
<?php



$db 
mysql_connect("localhost""MentorMenteeData""mentormenteedata") or die("Could not connect.");

if(!
$db

    die(
"no db");

if(!
mysql_select_db("mentormenteesystem",$db))

     die(
"No database selected.");

if(!
get_magic_quotes_gpc())

{

  
$_GET array_map('mysql_real_escape_string'$_GET); 

  
$_POST array_map('mysql_real_escape_string'$_POST); 

  
$_COOKIE array_map('mysql_real_escape_string'$_COOKIE);

}

else

{  

   
$_GET array_map('stripslashes'$_GET); 

   
$_POST array_map('stripslashes'$_POST); 

   
$_COOKIE array_map('stripslashes'$_COOKIE);

   
$_GET array_map('mysql_real_escape_string'$_GET); 

   
$_POST array_map('mysql_real_escape_string'$_POST); 

   
$_COOKIE array_map('mysql_real_escape_string'$_COOKIE);

}



?>
Database Table:

PHP Code:
-- phpMyAdmin SQL Dump
-- version 3.4.5
-- [url]http://www.phpmyadmin.net[/url]
--
-- 
Hostlocalhost
-- Generation TimeMar 092012 at 10:05 AM
-- Server version5.5.16
-- PHP Version5.3.8


SET SQL_MODE
="NO_AUTO_VALUE_ON_ZERO";
SET time_zone "+00:00";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;


--
-- 
Database: `mentormenteesystem`
--

-- --------------------------------------------------------

--
-- 
Table structure for table `forum`
--

CREATE TABLE IF NOT EXISTS `elec_forum` (
  `
postidbigint(20NOT NULL AUTO_INCREMENT,
  `
authorvarchar(255NOT NULL DEFAULT '',
  `
titlevarchar(255NOT NULL DEFAULT ''
  `
postmediumtext NOT NULL,
  `
showtimevarchar(255NOT NULL DEFAULT '',  
 `
realtimebigint(20NOT NULL DEFAULT '0',  
 `
lastpostervarchar(255NOT NULL DEFAULT '',  
 `
numrepliesbigint(20NOT NULL DEFAULT '0',  
 `
parentidbigint(20NOT NULL DEFAULT '0',  
 `
lastrepliedtobigint(20NOT NULL DEFAULT '0'
PRIMARY KEY (`postid`)

ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=

Please guide and advise. I really do need a help here. thanks in advance