PHP - Links On Topic Name

I am having trouble adding sub-topics to my home made blog system running under PHP-Fusion CMS with PHPver7.4.16 with cgi/fcgi interface and MySQL5.7.34-log. Here are 2 images:

Here is the module that produces the output.

<?php
echo "<div class='col-sm-12'>\n";
echo "<table width='100%' border='0'><tr><td><span class='hdspan2'><b>".$locale['gb_810']."</b></span></td></tr></table>\n";
echo "<table align='center' width='80%' border='0'>\n";
$result = dbquery("SELECT * FROM ".DB_GRIMS_BLOG_TOPICS." ORDER BY topic_order ASC");
if (dbrows($result)) {
$cnt = 0;
	while($data = dbarray($result)) {
		$id = $data['topic_id'];
		$title = $data['topic_title'];
		$sub = $data['topic_sub'];
			$result1 = dbquery("SELECT * FROM ".DB_GRIMS_BLOG_POST." WHERE topic_id='$id'");
			$num_rows = dbrows($result1);
		if ($sub == '1') {
echo "<tr><td width='15'></td><td><a class='lnk-side' href='".BASEDIR."grims_blog/topics_page.php?topic_id=".$id."'>$title</a><span style='font-size:11px;color:white;'>&nbsp;[$num_rows posts]</span></td></tr>\n";
		} else {
echo "<tr><td colspan='2'><a class='lnk-side' href='".BASEDIR."grims_blog/topics_page.php?topic_id=".$id."'>$title</a><span style='font-size:11px;color:white;'>&nbsp;[$num_rows posts]</span></td></tr>\n";
		}
	}
$cnt++;
}
echo "</table><p></div>\n";
?>

The topic_order field is a new field I added to get the desired output but it's not standard procedure and is in fact not really workable in a live setting because I would have to use php_myadmin to modify it everytime I added or deleted a topic or sub-topic.

So the bottom line is that I can't figure out anyway to code the script to always show the sub-topic right under the associated main topic and all in order. If I add a sub-topic to one of the upper main topics it shows up at the bottom; hence the addition of the topic_order field. So right now it's basically a mess and I can't figure out how to code everything to work correctly. I have searched the forums here as well as several other sites and cannot get any clues.

Ok I found the culprit and it's easy!

Code: [Select]
function  timeAgo2($timestamp, $granularity=3, $format='d:H:i:s'){
        $difference = $timestamp;
        if($difference < 0) return '0 seconds ago';
        elseif($difference < 864000){
                   $periods = array('week' => 604800,'day' => 86400,'hours' => 3600,'min' => 60,'seconds' => 1);
                $output = '';
                foreach($periods as $key => $value){
                        if($difference >= $value){
                                $time = round($difference / $value);
                                $difference %= $value;
                                $output .= ($output ? ' ' : '').$time.' ';
                                $output .= (($time > 1 && $key == 'day') ? $key.'s' : $key);
                                $granularity--;
                        }
                        if($granularity == 0) break;
                }
                return ($output ? $output : '0 seconds').'';
        }
        else return date($format, $timestamp);
}

Now I will use:

Code: [Select]
timeAgo2(136622,5)
Which works and it will output:
2 days 14 hours 57 min 2 seconds


But, if I add another "1" to it like this:

Code: [Select]
timeAgo2(1136622,5)

It shows:
Code: [Select]
14:03:43:42
Which is not right, it needs to show, 14 Days, 3hours 43minutes and 42 seconds.... Thank you, I finally explained myself better here, hope you understand

I've already made fully working create topic, etc; what would I need to make to reply to a thread?

I've gotten this so far...
<?php
$result = mysql_query("SELECT id FROM b ORDER BY id DESC");
while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
    printf("<a href='reply.php?id=%s'>Reply</a><hr><br /><br />", $row[0]);
}

mysql_free_result($result);
?>
reply.php?id=%s (%s equaling the thread id) when I click it, it does bring me to the appropriate page, but I don't know where to go from there. Any help? 
any other info you might need just ask

ignore

This topic has been moved to PHPFreaks.com Questions, Comments, & Suggestions.

http://www.phpfreaks.com/forums/index.php?topic=332508.0