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 Link to comment https://forums.phpfreaks.com/topic/50255-solved-resource-id-11/ Share on other sites More sharing options...
trq Posted May 6, 2007 Share Posted May 6, 2007 Where do you define $resultoftitle? Link to comment https://forums.phpfreaks.com/topic/50255-solved-resource-id-11/#findComment-246682 Share on other sites More sharing options...
Shaun13 Posted May 6, 2007 Author Share Posted May 6, 2007 At the top under: //mysql queries Link to comment https://forums.phpfreaks.com/topic/50255-solved-resource-id-11/#findComment-246683 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 ?> Link to comment https://forums.phpfreaks.com/topic/50255-solved-resource-id-11/#findComment-246692 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.