Forum board unsolved
I have written codes create a forum board to be added into my website by using php and mysql. I have some problem here, the 'Numbers of Reply', 'Last Replied Time' and 'Last Replied by who' could not being updated when there are replies. 

Here's the code (elec_forum.php):

    <p ><h3 align="center">Department of Electronic Engineering</h3> 
    <?php 
    
    include "connect.php"; //mysql db connection here 
    
    print "<link rel='stylesheet' href='style.css' type='text/css'>"; 
    
    print "<A href='elec_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 elec_forum where parentid='0' order by lastrepliedto 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='elec_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>"; 
    
    
    
    ?>

Here's the reply code (elec_reply.php):

    <?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
    
          $displaytime=date("F j, Y, g: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','$displaytime','$thedate','$name','$id')";
    
          mysql_query($insertpost) or die("Could not insert post"); //insert 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>";
    
    ?>

I am not sure where's the problem occurred. Please advice.
Forum board unsolved
===

I have written codes create a forum board to be added into my website by using php and mysql. I have some problem here, the 'Numbers of Reply', 'Last Replied Time' and 'Last Replied by who' could not being updated when there are replies. 

Here's the code (elec_forum.php):

    <p ><h3 align="center">Department of Electronic Engineering</h3> 
    <?php 
    
    include "connect.php"; //mysql db connection here 
    
    print "<link rel='stylesheet' href='style.css' type='text/css'>"; 
    
    print "<A href='elec_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 elec_forum where parentid='0' order by lastrepliedto 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='elec_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>"; 
    
    
    
    ?>

Here's the reply code (elec_reply.php):

    <?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
    
          $displaytime=date("F j, Y, g: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','$displaytime','$thedate','$name','$id')";
    
          mysql_query($insertpost) or die("Could not insert post"); //insert 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>";
    
    ?>

I am not sure where's the problem occurred. Please advice.