Mysql doet raar bij een raar teken
Ik heb dus een member system waar je automatich kan registreren, het is zo beveiligd dat je maar 1 keer dezelfde gebruikersnaam kan gebruiken.
Maar nu is dat niet gebeurt (toch werkt de beveileging)
er is 2 keer deze user aangemaakt -->
bg_Xel'Naga (zit een raar teken in --> ' )
en hij kan hem niet inloggen -->
zo zit het in de database -->
Host: localhost
Database : che-live_starcraft
Generatie Tijd: 22 Jun 2004 om 02:05
Gegenereerd door: phpMyAdmin 2.5.6 / MySQL 4.0.16
SQL-query: SELECT * FROM members WHERE membercode = '21' OR membercode = '22 ' LIMIT 0, 50;
Rijen: 2
membercode user pass
21 bg_Xel'Naga a5dbfe1cdfe4632a3575ca3877826d10
22 bg_Xel'Naga a5dbfe1cdfe4632a3575ca3877826d10
En dan heb ik nog een pagina waar statics kunt bekijken van die user die werkt ook niet (alleen bij deze user)
Kijk maar -->
http://www.che-lives-clan.com/starcraft/members_statics.php?id=21
http://www.che-lives-clan.com/starcraft/members_statics.php?id=22
Dan kreeg ik deze error -->
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/che-live/public_html/starcraft/members_statics.php on line 19
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/che-live/public_html/starcraft/members_statics.php on line 23
maar die error krijg ik aleen bij die user.
Dit is de broncode van die statics -->
<title>Starcraft Source Statics</title>
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
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
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
36
37
38
39
40
41
42
<?php
if($ingelogd==1){
if($_GET[id]==""){
$_GET[id]=$members[membercode];
}
$sql = "SELECT * FROM members WHERE membercode = '$_GET[id]'";
$res = mysql_query($sql);
$user = mysql_fetch_array($res);
$sql = "SELECT count(*) FROM topics WHERE naam = '$user[user]'";
$res = mysql_query($sql);
$row = mysql_fetch_array($res);
$topics=$row[0];
$sql = "SELECT count(*) FROM replys WHERE naam = '$user[user]'";
$res = mysql_query($sql);
$row = mysql_fetch_array($res);
$replys=$row[0];
$sql = "SELECT count(*) FROM pm WHERE aan = '$user[membercode]' AND readed = '1'";
$res = mysql_query($sql);
$row = mysql_fetch_array($res);
$new_pm=$row[0];
$sql = "SELECT count(*) FROM pm WHERE aan = '$user[membercode]'";
$res = mysql_query($sql);
$row = mysql_fetch_array($res);
$pm=$row[0];
$lastonline=date("H:i \- d.m.Y",$user[lastonline]);
echo "<br><br><table width=\"40%\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\">\n";
echo "<tr><td class=\"menu_title\" align=\"center\"><b>$user[user] Statics</b></td></tr>\n";
echo "<tr><td class=\"menu\">\n";
echo "» Topics: <b>$topics</b><br>\n";
echo "» Replys: <b>$replys</b><br>\n";
echo "» New pm: <b>$new_pm</b><br>\n";
echo "» Pm: <b>$pm</b><br>\n";
echo "» Profile views: <b>$user[profileviews]</b><br>\n";
echo "» Site views: <b>$user[pageviews]</b><br>\n";
echo "» Last online: <b>$lastonline</b><br>\n";
echo "</td></tr>";
echo "</table><br><br>";
}
else{
header("Location: http://www.che-lives-clan.com/starcraft");
}
?>
if($ingelogd==1){
if($_GET[id]==""){
$_GET[id]=$members[membercode];
}
$sql = "SELECT * FROM members WHERE membercode = '$_GET[id]'";
$res = mysql_query($sql);
$user = mysql_fetch_array($res);
$sql = "SELECT count(*) FROM topics WHERE naam = '$user[user]'";
$res = mysql_query($sql);
$row = mysql_fetch_array($res);
$topics=$row[0];
$sql = "SELECT count(*) FROM replys WHERE naam = '$user[user]'";
$res = mysql_query($sql);
$row = mysql_fetch_array($res);
$replys=$row[0];
$sql = "SELECT count(*) FROM pm WHERE aan = '$user[membercode]' AND readed = '1'";
$res = mysql_query($sql);
$row = mysql_fetch_array($res);
$new_pm=$row[0];
$sql = "SELECT count(*) FROM pm WHERE aan = '$user[membercode]'";
$res = mysql_query($sql);
$row = mysql_fetch_array($res);
$pm=$row[0];
$lastonline=date("H:i \- d.m.Y",$user[lastonline]);
echo "<br><br><table width=\"40%\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\">\n";
echo "<tr><td class=\"menu_title\" align=\"center\"><b>$user[user] Statics</b></td></tr>\n";
echo "<tr><td class=\"menu\">\n";
echo "» Topics: <b>$topics</b><br>\n";
echo "» Replys: <b>$replys</b><br>\n";
echo "» New pm: <b>$new_pm</b><br>\n";
echo "» Pm: <b>$pm</b><br>\n";
echo "» Profile views: <b>$user[profileviews]</b><br>\n";
echo "» Site views: <b>$user[pageviews]</b><br>\n";
echo "» Last online: <b>$lastonline</b><br>\n";
echo "</td></tr>";
echo "</table><br><br>";
}
else{
header("Location: http://www.che-lives-clan.com/starcraft");
}
?>
Ligt dit aan het rare teken in zijn naam ??
Gewijzigd op 22/06/2004 11:06:00 door Bram Z
UNIQUE ('kollom') te gebruiken
ALTER TABLE `members` ADD UNIQUE (
`user`)
dan zijn er geen dubbele invoer meer mogelijk
$sql = "SELECT count(*) FROM replys WHERE naam = '$user[user]'";
maak er dit van:
$sql = "SELECT count(*) FROM replys WHERE naam = '".$user['user']."'";
Kijk even of dit wel goed gaat