Shaun13 Posted May 6, 2007 Share Posted May 6, 2007 Ok, here is a script of mine: <?php session_start(); error_reporting(E_ALL ^ E_NOTICE); // database info $host="localhost"; // Host name $username="=P"; // Mysql username $password="=P"; // Mysql password $db_name="=P"; // Database name // end database info // connect to database mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot select DB"); // end connect to database // table info $tablemembers="members"; $tableposts="posts"; $tablereplies="replies"; // end table info // etc. variables $myusername=$_SESSION['myusername']; // end etc. variables // actions $viewtopic=$_REQUEST['viewtopic']; $action=$_REQUEST['action']; // end actions // mysql queries $sql="SELECT * FROM $tableposts ORDER BY id DESC"; $result=mysql_query($sql); $sql1="SELECT * FROM $tableposts WHERE id='$id'"; $result1=mysql_query($sql1); $rows1=mysql_fetch_array($result1); $dnsql="SELECT displayname FROM $tablemembers WHERE username = '$myusername'"; $dnresult=mysql_query($dnsql); $sql2="SELECT * FROM $tablereplies WHERE questionid='$id'"; $result2=mysql_query($sql2); $sql3="SELECT views FROM $tableposts WHERE id='$id'"; $result3=mysql_query($sql3); $rows3=mysql_fetch_array($result3); $views3=$rows3['views']; $sql4="INSERT INTO $tableposts(views) VALUES('$views3') WHERE id='$id'"; $sql5="update $tableposts set views='$addview' WHERE id='$id'"; $sql6="SELECT * FROM $tableposts WHERE id='$id'"; $result6=mysql_query($sql6); $sql7="SELECT * FROM $tableposts WHERE id='$id'"; $result7=mysql_query($sql7); $rows7=mysql_fetch_array($result7); $sql9="SELECT * FROM $tableposts ORDER BY id DESC"; $sql8="SELECT * FROM $tableposts WHERE id='$id'"; $result8=mysql_query($sql9); $rows8=mysql_fetch_array($result8); $title="SELECT title FROM $tableposts WHERE id='$viewtopic'"; $resultoftitle=mysql_query($title); // end mysql queries ?> <center> <?php // start header code if (mysql_num_rows($dnresult)>0) { while ($dn = mysql_fetch_assoc($dnresult)) { extract($dn); if(isset($myusername)) { echo "Welcome , $displayname | <a href='logout.php'>Logout</a>"; } } } elseif (!isset($myusername)) { echo "<a href='login.php'>Login</a> | <a href='register.php'>Register</a>"; } echo "<br>Your Location: <a href='index.php'>ShaunsBoards</a>"; if(isset($_REQUEST['viewtopic'])) { echo " > <a href='index.php?viewtopic=".$_REQUEST['viewtopic']."'>".$resultoftitle."<br><br>"; } else { echo "<a href='index.php'></a>"; } // end header code // begin viewtopic action if (isset($viewtopic)) { $id=$viewtopic; echo "<table width='100%' border='0' align='center' cellpadding='0' cellspacing='1' bgcolor='#CCCCCC'> <tr> <td><table width='100%' border='0' cellpadding='3' cellspacing='1' bordercolor='1' bgcolor='#FFFFFF'> <tr> <td bgcolor='#F8F7F1'><strong>".$rows8['title']."</strong></td> </tr> <tr> <td bgcolor='#F8F7F1'>".$rows8['content']."</td> </tr> <tr> <td bgcolor='#F8F7F1'><strong>By :</strong>".$rows8['authordisplay']."</td> </tr> <tr> <td bgcolor='#F8F7F1'><strong>Date/time : </strong>".$rows8['datetime']."</td> </tr> </table></td> </tr> </table> <BR>"; echo "<table width='100%' border='0' align='center' cellpadding='0' cellspacing='1' bgcolor='#CCCCCC'> <tr> <td><table width='100%' border='0' cellpadding='3' cellspacing='1' bgcolor='#FFFFFF'> <tr> <td width='18%' bgcolor='#F8F7F1'><strong>By</strong></td> <td width='5%' bgcolor='#F8F7F1'>:</td> <td width='77%' bgcolor='#F8F7F1'>".$rowsstuff['authordisplay']."</td> </tr> <tr> <td bgcolor='#F8F7F1'><strong>Post</strong></td> <td bgcolor='#F8F7F1'>:</td> <td bgcolor='#F8F7F1'>".$rowsstuff['content']."</td> </tr> <tr> <td bgcolor='#F8F7F1'><strong>Date/Time</strong></td> <td bgcolor='#F8F7F1'>:</td> <td bgcolor='#F8F7F1'>".$rowsstuff['datetime']."</td> </tr> </table></td> </tr> </table><br>"; if(session_is_registered(myusername)) { echo "<table width='400' border='0' align='center' cellpadding='0' cellspacing='1' bgcolor='#CCCCCC'> <tr> <form name='form1' method='post' action='index.php?action=reply'> <td> <table width='100%' border='0' cellpadding='3' cellspacing='1' bgcolor='#FFFFFF'> <tr> <td valign='top'><strong>Post</strong></td> <td valign='top'>:</td> <td><textarea name='content' cols='45' rows='3' id='content'></textarea></td> </tr> <tr> <td> </td> <td><input name='id' type='hidden' value='".$id."'></td> <td><input type='submit' name='Submit' value='Submit'> <input type='reset' name='Submit2' value='Reset'></td> </tr> </table> </td> </form>"; } else { echo "<a href='login.php'>Login</a> to reply to topics!"; } if(empty($views3)) { $views3=1; $result4=mysql_query($sql4); } $addview=$views3+1; $result5=mysql_query($sql5); exit; } // vars echo "</center> <br /><br /> <table width='90%' border='0' align='center' cellpadding='3' cellspacing='1' bgcolor='#CCCCCC'> <tr> <td width='40%' align='center' bgcolor='#CCDDCC'><strong>Topic</strong></td> <td width='20%' align='center' bgcolor='#CCDDCC'><strong>Author</strong></td> <td width='15%' align='center' bgcolor='#CCDDCC'><strong>Views</strong></td> <td width='13%' align='center' bgcolor='#CCDDCC'><strong>Replies</strong></td> <td width='13%' align='center' bgcolor='#CCDDCC'><strong>Date/Time</strong></td> </tr>"; while($rowstopics=mysql_fetch_array($result)){ // Start looping table row echo "<tr> <td bgcolor='#FFFFFF'><a href='index.php?viewtopic=".$rowstopics['id']."'>".$rowstopics['title']."</a><BR></td> <td align='center' bgcolor='#FFFFFF'>".$rowstopics['authordisplay']."</td> <td align='center' bgcolor='#FFFFFF'>".$rowstopics['views']."</td> <td align='center' bgcolor='#FFFFFF'>".$rowstopics['posts']."</td> <td align='center' bgcolor='#FFFFFF'>".$rowstopics['datetime']."</td> </tr>"; } echo "<tr> <td colspan='5' align='right' bgcolor='#CCDDCC'>"; if(isset($_SESSION['myusername'])) { echo "<a href='create_topic.php'><strong>Create New Topic</strong></a><br>"; } else { echo "<a href='login.php'>Login</a> to start topics!"; } ?> </center> The part of the code I think has the problems is here: echo "<br>Your Location: <a href='index.php'>ShaunsBoards</a>"; if(isset($_REQUEST['viewtopic'])) { echo " > <a href='index.php?viewtopic=".$_REQUEST['viewtopic']."'>".$resultoftitle."<br><br>"; } else { echo "<a href='index.php'></a>"; } What I want it to do is show where you are viewing a topic for example index.php?viewtopic=1, ex. ShaunsBoards > PhpFreaks! What it is doing is: ShaunsBoards > Resource id #11 Any help? ~Shaun Quote Link to comment Share on other sites More sharing options...
trq Posted May 6, 2007 Share Posted May 6, 2007 Where do you define $resultoftitle? Quote Link to comment Share on other sites More sharing options...
Shaun13 Posted May 6, 2007 Author Share Posted May 6, 2007 At the top under: //mysql queries Quote Link to comment Share on other sites More sharing options...
MadTechie Posted May 6, 2007 Share Posted May 6, 2007 change <?php $title="SELECT title FROM $tableposts WHERE id='$viewtopic'"; $resultoftitle=mysql_query($title); // end mysql queries ?> to <?php $title="SELECT title FROM $tableposts WHERE id='$viewtopic'"; $resultoftitle=mysql_query($title); $GetTitle =mysql_fetch_array($resultoftitle); $resultoftitle = $GetTitle['title']; // end mysql queries ?> Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.