I've got the following error:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/wbdfdart/public_html/wbdfforum/verwijder.php on line 13
verwijder.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
<?php
include "connect.php";
if (isset ($cat) AND isset ($topic) AND isset ($message)) {
$query = "SELECT user FROM reply WHERE id='$message'";
$exec = mysql_query($query);
$result = mysql_fetch_array($exec);
$owner = $result["user"];
$moderator_check_query = "SELECT * FROM moderator WHERE category=$cat AND user=$myid";
$moderator_check_exec = mysql_query($moderator_check_query);
$moderator_result = mysql_num_rows($moderator_check_exec);
if ($moderator_result == 1 OR $owner == $myid) {
$moderator = 1;
}
else {
$moderator = 0;
}
if ($moderator == 1) {
$replydelete_query="DELETE FROM reply WHERE id ='$id'";
mysql_query($replydelete_query) or die(mysql_error());
$topicmineen_query="UPDATE topic SET replies='replies -1' WHERE id='$topic'";
mysql_query($topicmineen_query) or die(mysql_error());
echo "<script>location.href='index.php?cat=".$cat."&top ic=".$topic."&page=".$page."'</script>";
}
else {
echo "<script>location.href='index.php?cat=".$cat."&top ic=".$topic."&page=".$page."'</script>";
}}
?>
What i did wrong?