Fout in script
Ik heb een fout in mijn script.
Maar ik weet maar niet wat ik fout doe!! :S
De foutmelding is die ik krijg:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in c:\wamp\www\paginas\forum\handlers\handle_selecttopic.php on line 39
Kan iemand mij de uitleg geven wat ik fout doe ?
<link href="/paginas/css/lettertypen.css" rel="stylesheet" type="text/css" />
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
<?php
if ($_SESSION['user_ID'] == "")
{
print("<div align=\"center\"><span class=\"xbig\">Je bent niet ingelogd!</span><br /> <br /><span class=\"style4\"><a href=\"/paginas/login.php\">Hier</a> kun je je inloggen</span></div>");
exit;
}
//Informatie uit GET halen.
$topic_name = $_GET['topic'];
$topic_id = $_GET['id'];
$parent1 = $_GET['parent1'];
//verbinding maken met da database!
$dbc = mysql_connect('localhost', '****', '******);
mysql_select_db('knorfski', $dbc);
//Query's aanmaken
$query2 = "select * from forum_inhoud WHERE parent2='$topic_name' order by id DESC";
//Query's uitvoeren
$result2 = mysql_query($query2, $dbc);
?>
if ($_SESSION['user_ID'] == "")
{
print("<div align=\"center\"><span class=\"xbig\">Je bent niet ingelogd!</span><br /> <br /><span class=\"style4\"><a href=\"/paginas/login.php\">Hier</a> kun je je inloggen</span></div>");
exit;
}
//Informatie uit GET halen.
$topic_name = $_GET['topic'];
$topic_id = $_GET['id'];
$parent1 = $_GET['parent1'];
//verbinding maken met da database!
$dbc = mysql_connect('localhost', '****', '******);
mysql_select_db('knorfski', $dbc);
//Query's aanmaken
$query2 = "select * from forum_inhoud WHERE parent2='$topic_name' order by id DESC";
//Query's uitvoeren
$result2 = mysql_query($query2, $dbc);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml"><head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Topic</title>
</head>
<body>
<div align="center">
<table width="500" height="103" border="1">
<tr>
<td height="53"><div align="center" class="style4">
<p><strong> schreef:</strong></p>
<p align="center"><strong><br />
</strong></p>
</div></td>
</tr>
<tr>
<td>
<div align="center">Gepost op: </div>
</td>
</tr>
<br />
Code (php)
1
<?php } ?>
</table>
<br />
<br />
<table width="500" border="1">
<tr>
<td height="318"><form id="form1" name="form1" method="post" action="/paginas/forum/handlers/handle_postreply.php?topic=&parent1="><textarea name="reply" rows="15" cols="100"></textarea>
</label>
<p align="center">
<label>
<input type="submit" name="Submit" value="Post reply!" />
</label>
</p>
</form>
</td>
</tr>
</table>
<br />
<br />
</div>
</body>
</html>
</div>
Verder horen variabelen niet tussen quotes te staan. Niet in queries, print of wat dan ook.
dus in plaats van
//Query's uitvoeren
$result2 = mysql_query($query2, $dbc);
Doe je
//Query's uitvoeren
$result2 = mysql_query($query2, $dbc) or die (mysql_error ());
Notice: Undefined variable: query2 in c:\wamp\www\paginas\forum\handlers\handle_selecttopic.php on line 20
Query was empty
Edit:
Foutje...
order by id
//moest zijn:
order by post_id
Dank u allemaal (K)
Gewijzigd op 16/11/2005 20:11:00 door Knorfski