Stotty Posted December 30, 2008 Share Posted December 30, 2008 Well on some Custom forums my Cusion made me ive heavly edited but i cannot seem to get this to work i want on messages.php?forumID=1&ID=1 the thread like say the titles Title in header should display Title - phpMM ( Title of my site is phpMM ) this is messages.php <?php include "connect.php"; session_start(); ?> <link rel="stylesheet" href="../style.css" type="text/css"> <?php if (isset($_SESSION['player'])) { $player=$_SESSION['player']; $userstats="SELECT * from km_users where playername='$player'"; $userstats2=mysql_query($userstats) or die("Could not get user stats"); $userstats3=mysql_fetch_array($userstats2); if(isset($_GET['ID'])) { $ID=$_GET['ID']; $getmessage="SELECT * from km_messages a, km_users b where b.ID=a.posterid and a.msgid='$ID'"; $getmessage2=mysql_query($getmessage) or die(mysql_error()); $getmessage3=mysql_fetch_array($getmessage2); $getforum="SELECT forumname from km_forums where forumID='$getmessage3[forumparent]'"; $getforum2=mysql_query($getforum) or die("Could not get forum"); $getforum3=mysql_fetch_array($getforum2); print "<p align='right'>"; print "<center>"; print "<table class='maintable'>"; print "<tr class='headline'><td colspan='2'><center>Navigation</center></td></tr>"; print "<tr class='mainrow'><td><A href='../index.php'>Kill Monster Main</a>--<A href='index.php'>Forum Main</a>--<A href='forum.php?ID=$getmessage3[forumparent]'>$getforum3[forumname]</a></td><td><p align='right'><A href='post.php?forumid=$getmessage3[forumparent]'>Post</a>--<A href='reply.php?forumid=$getmessage3[forumparent]&ID=$ID'>Reply</a></td></tr>"; print "</table><br><br>"; print "<table class='maintable'>"; print "<tr class='headline'><td width=25%>Author</td><td width=75%><center>Post</center></td></tr>"; print "<tr class='mainrow'><td width=25%><b>$getmessage3[playername]</b><br>"; if($getmessage3[status]==3) { print "Administrator(Lord and Master)"; } else { print "Member"; } $getmessage3[message]=stripslashes($getmessage3[message]); $getmessage3[message]=strip_tags($getmessage3[message]); $getmessage3[message]=nl2br($getmessage3[message]); print "</td><td width=75%>Last replied to on $getmessage3[realtime]<br>"; if($userstats3['ID']==$getmessage3['posterid'] || $userstats3[status]==3) { print "<A href='edit.php?ID=$getmessage3[msgid]'>Edit</a>-<A href='delete.php?ID=$getmessage3[msgid]'>Delete</a><br>"; } print "<hr>$getmessage3[message]</td></tr>"; $getreplies="SELECT * from km_messages a, km_users b where b.ID=a.posterid and a.parentid='$ID'"; $getreplies2=mysql_query($getreplies) or die("Could not get replies"); while ($getreplies3=mysql_fetch_array($getreplies2)) { print "<tr class='mainrow'><td width=25%><b>$getreplies3[playername]</b><br>"; if($getreplies3[status]==3) { print "Administrator(Lord and Master)"; } else { print "Member"; } $getreplies3[message]=stripslashes($getreplies3[message]); $getreplies3[message]=strip_tags($getreplies3[message]); $getreplies3[message]=nl2br($getreplies3[message]); print "</td><td width=75%>Posted on $getreplies3[realtime]<br>"; if($userstats3['ID']==$getreplies3['posterid'] || $userstats3[status]==3) { print "<A href='edit.php?ID=$getreplies3[msgid]'>Edit</a>-<A href='delete.php?ID=$getreplies3[msgid]'>Delete</a>"; } print "<hr>$getreplies3[message]</td></tr>"; } print "</table>"; } } else { print "You are not logged in."; } ?> How would i go about doing this can someone do it for me ?? also my mySQL Layout is like this CREATE TABLE `km_messages` ( `msgid` bigint(20) NOT NULL auto_increment, `posterid` bigint(20) NOT NULL default '0', `parentid` bigint(20) NOT NULL default '0', `time` bigint(20) NOT NULL default '0', `numreplies` bigint(20) NOT NULL default '0', `realtime` varchar(255) NOT NULL default '', `subject` tinytext NOT NULL, `message` mediumtext NOT NULL, `lastreplied` varchar(255) NOT NULL default '', `forumparent` bigint(20) NOT NULL default '0', PRIMARY KEY (`msgid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; Thanks in Advanced ASAP Link to comment https://forums.phpfreaks.com/topic/138928-topic-titles-basic/ Share on other sites More sharing options...
Maq Posted December 30, 2008 Share Posted December 30, 2008 How would i go about doing this can someone do it for me ?? That's a good one. You would have to do a small sql statement that gets the Title, but according to your structure there is no Title. Maybe the parent ID? I think you need to utilize 2 tables to get the Title, show me the table structure with the parents (forum titles). Anyway after you extract it from the data base just do: - phpMM Link to comment https://forums.phpfreaks.com/topic/138928-topic-titles-basic/#findComment-726543 Share on other sites More sharing options...
Stotty Posted December 30, 2008 Author Share Posted December 30, 2008 Subject is the Title Link to comment https://forums.phpfreaks.com/topic/138928-topic-titles-basic/#findComment-726544 Share on other sites More sharing options...
Maq Posted December 30, 2008 Share Posted December 30, 2008 Try something like this: $sql = "SELECT subject FROM km_messages WHERE msgid = '{$_GET['ID']}'"; $result = mysql_query($sql) or die(mysql_error()); $row = mysql_fetch_assoc($result); ?> - phpMM Link to comment https://forums.phpfreaks.com/topic/138928-topic-titles-basic/#findComment-726549 Share on other sites More sharing options...
Stotty Posted December 30, 2008 Author Share Posted December 30, 2008 Perfect TYVM Link to comment https://forums.phpfreaks.com/topic/138928-topic-titles-basic/#findComment-726556 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.