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.ph p";
if (isset ($cat) AND isset ($topic) AND isset ($message)) {
$query = "SELECT user FROM reply WHERE id='$message'";
$exec = mysql_query($qu ery);
$result = mysql_fetch_arr ay($exec);
$owner = $result["user"];
$moderator_chec k_query = "SELECT * FROM moderator WHERE category=$cat AND user=$myid";
$moderator_chec k_exec = mysql_query($mo derator_check_q uery);
$moderator_resu lt = mysql_num_rows( $moderator_chec k_exec);
if ($moderator_res ult == 1 OR $owner == $myid) {
$moderator = 1;
}
else {
$moderator = 0;
}
if ($moderator == 1) {
$replydelete_qu ery="DELETE FROM reply WHERE id ='$id'";
mysql_query($re plydelete_query ) or die(mysql_error ());
$topicmineen_qu ery="UPDATE topic SET replies='replie s -1' WHERE id='$topic'";
mysql_query($to picmineen_query ) or die(mysql_error ());
echo "<script>locati on.href='index. php?cat=".$cat. "&topic=".$topi c."&page=".$pag e."'</script>";
}
else {
echo "<script>locati on.href='index. php?cat=".$cat. "&topic=".$topi c."&page=".$pag e."'</script>";
}}
?>
What i did wrong?
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.ph p";
if (isset ($cat) AND isset ($topic) AND isset ($message)) {
$query = "SELECT user FROM reply WHERE id='$message'";
$exec = mysql_query($qu ery);
$result = mysql_fetch_arr ay($exec);
$owner = $result["user"];
$moderator_chec k_query = "SELECT * FROM moderator WHERE category=$cat AND user=$myid";
$moderator_chec k_exec = mysql_query($mo derator_check_q uery);
$moderator_resu lt = mysql_num_rows( $moderator_chec k_exec);
if ($moderator_res ult == 1 OR $owner == $myid) {
$moderator = 1;
}
else {
$moderator = 0;
}
if ($moderator == 1) {
$replydelete_qu ery="DELETE FROM reply WHERE id ='$id'";
mysql_query($re plydelete_query ) or die(mysql_error ());
$topicmineen_qu ery="UPDATE topic SET replies='replie s -1' WHERE id='$topic'";
mysql_query($to picmineen_query ) or die(mysql_error ());
echo "<script>locati on.href='index. php?cat=".$cat. "&topic=".$topi c."&page=".$pag e."'</script>";
}
else {
echo "<script>locati on.href='index. php?cat=".$cat. "&topic=".$topi c."&page=".$pag e."'</script>";
}}
?>
What i did wrong?
Comment