hvad betyder mysql_result()
Warning: mysql_result(): supplied argument is not a valid MySQL result resource in c:\phpdev\www\brugersystem\showforum.php on line 39:Denne besked får jeg på min side som skal vise indholdet af mit forum. Men jeg kan ikke se hvad fejlen er.... Er der nogle af jer der kan det?
Her er min php stykke:
<?php
//-------------- Funktionen der tjekker om man er logget ind og samtidig henter brugernavn -------------
session_start();
$conn = mysql_connect("localhost" , "root");
mysql_select_db("fora3000" , $conn) or die (mysql_error());
//---------------------------------- Tjekker om man er logget ind -------------------------------------
if(!empty($_SESSION['user_name'])) {
//--------------------- Laver en query der finder ens brugerid i databasen ----------------------------
$query = mysql_query("SELECT * FROM members WHERE user_name='". $_SESSION['user_name'] ."'") or die(mysql_error());
$row = mysql_fetch_assoc($query);
$user_name = $row['user_name'];
;
}
//------------------------------checker om de "behøvede" info fra query'en ----------------------------
if (!$_GET[forum_id]) {
header("Location: topiclist.php");
exit;
}
//----------------------------chekker om der er oprettet et forum--------------------------------------
$verify_forum = "select forum_navn from forums where forum_id = $_GET[forum_id]";
$verify_forum_res = mysql_query($verify_forum, $conn) or die(mysql_error());
if (mysql_num_rows($verify_forum_res) < 1) {
//emnet findes ikke
$display_block = "<P><em>Emnet er ikke muligt. Prøv <a href=\"topiclist.php\">igen</a>.</em></p>";
} else {
//finder topic overskriften
$forum_navn = stripslashes(mysql_result($verify_forums_res,0, 'forum_navn'));
//samler posts
$get_topics = "select topic_id, topic_title, user_name, date_format(topic_create_time, '%e/%c-%y %T') as fmt_topic_create_time from topics where forum_id = $_GET[forum_id] order by topic_create_time asc";
$get_topics_res = mysql_query($get_topics,$conn) or die(mysql_error());
//------------------------------------------- Laver en udskrift-------------------------------------
$display_block .= "
$forum_navn
<table width=100% cellpadding=3 cellspacing=1 border=1>
<tr id='list3'>
<th width=40%>TOPIC TITLE</th>
<th width=20%>TOPIC STARTER</th>
<th width=10%># of POSTS</th>
<th width=30%>NYESTE POST</th>
</tr>";
while ($topic_info = mysql_fetch_array($get_topics_res)) {
$topic_id = $topic_info['topic_id'];
$topic_title = nl2br(stripslashes($topic_info['topic_title']));
$topic_create_time = $topic_info['fmt_topic_create_time'];
$topic_owner = stripslashes($topic_info['user_name']);
//-----------------------------------tilføjelse til udskriften------------------------------
$display_block .= "
<tr id='list2'>
<th width=35% valign=top><a href=\"showtopic.php?forum_id=$topic_id\">$topic_title</a></th>
<th width=35% valign=top>$topic_owner<br>[$topic_create_time]</th>
</tr>";
}
//close up the table
$display_block .= "</table>";
}
?>
<html>
<head>
<title><?php $forum_navn; ?></title>
<link rel="stylesheet" type="text/css" href="style.css">
</head>
<body bgcolor="#FFFFFF" Text="#000000" Link="#000000" vlink="#000000" alink="#000000"
leftmargin="100%" topmargin="10%" rightmargin="100%" marginheight="15" marginwidth="125">
<table width="100%" align="center">
<tr><img src="top.jpg" width="99.9%"></tr>
<tr id='list'>
<td>Velkommen <strong><?php print $user_name;?></strong></td>
<td align="right"><a href="din_side.php">Din side |</a> <a href="members.php"> Medlemmer |</a>
</tr>
</table>
<br><br>
<?php print $display_block;?>
</body>
</html>
