[SOLVED] Resource id #11?

[Shaun13]

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

 

[trq]

Where do you define $resultoftitle?

[Shaun13]

At the top under:

 

//mysql queries

 

[MadTechie]

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
?>