Hvorfor virker det her ikke ? :o)
<?phpif(!$user) {
if($nickname !="" && $password !="" && $password == $passwordcheck && $name !="" && $email !="") {
include("includes/mysqlconnect.php");
$check = "SELECT nickname FROM profiles WHERE nickname == '$nickname'";
$res = mysql_query($check);
if($res == "") {
$add = "INSERT INTO profiles (nickname,password,name,email,homepage,about,comment) VALUES ('$nickname','$password','$name','$email','$homepage','$about','$comment')";
mysql_query($add)
?>
<br>
your profile has been created!
<br><br>
Here is a display of your profile information:<br>
<br>
<table cellspacing="3" cellpadding="0" border="0">
<tr><td width="50%" align="right">
nick / username :
</td><td>
<? echo $nickname;?>
</td></tr>
<tr><td align="right">
password :
</td><td>
<? echo $password; ?>
</td></tr>
<tr><td align="right">
name :
</td><td>
<? echo $name; ?>
</td></tr>
<tr><td align="right">
email :
</td><td>
<? echo $email; ?>
</td></tr>
<tr><td align="right" valign="top">
<? if($homepage !="") { echo "homepage :"; } ?>
</td><td>
<? echo $homepage; ?>
</td></tr>
<tr><td align="right" valign="top">
<? if($about !="") { echo "About yourself :"; } ?>
</td><td>
<? echo $about; ?>
</td></tr>
<tr><td align="right" valign="top">
<? if($comment !="") { echo "Comment :"; } ?>
</td><td>
<? echo $comment; ?>
</td></tr>
</table>
<?
} else {
echo "user / nickname already taken by: <font color=\"#ff0000\">$name</font>"; }
} else {
?>
<form action="addprofile.php" method="post">
<table width="100%" cellspacing="1" cellpadding="0" border="0">
<tr><td colspan="2" align="left">
information that is required is marked with an asterix. ( <font color="#ff0000">*</font> )
<br><br>
</td></tr>
<tr><td align="right" width="50%">
enter your nick / username:
</td><td>
<input type="text" name="nickname" style="border: 1px solid #555555; font-family: Arial; font-size: 11px; color: #333333; padding-left:2; padding-right:2; padding-top: 1; padding-bottom: 0; background-color : #FFFFFF;"> <font color="#ff0000">*</font>
</td></tr>
<tr><td align="right">
enter your password:
</td><td>
<input type="password" name="password" style="border: 1px solid #555555; font-family: Arial; font-size: 11px; color: #333333; padding-left:2; padding-right:2; padding-top: 1; padding-bottom: 0; background-color : #FFFFFF;"> <font color="#ff0000">*</font>
</td></tr>
<tr><td align="right">
enter your password again:
</td><td>
<input type="password" name="passwordcheck" style="border: 1px solid #555555; font-family: Arial; font-size: 11px; color: #333333; padding-left:2; padding-right:2; padding-top: 1; padding-bottom: 0; background-color : #FFFFFF;"> <font color="#ff0000">*</font>
</td></tr>
<tr><td align="right">
enter your name:
</td><td>
<input type="text" name="name" style="border: 1px solid #555555; font-family: Arial; font-size: 11px; color: #333333; padding-left:2; padding-right:2; padding-top: 1; padding-bottom: 0; background-color : #FFFFFF;"> <font color="#ff0000">*</font>
</td></tr>
<tr><td align="right">
enter your email-address:
</td><td>
<input type="text" name="email" style="border: 1px solid #555555; font-family: Arial; font-size: 11px; color: #333333; padding-left:2; padding-right:2; padding-top: 1; padding-bottom: 0; background-color : #FFFFFF;"> <font color="#ff0000">*</font>
</td></tr>
<tr><td align="right">
enter the url to your homepage:
</td><td>
<input type="text" name="homepage" style="border: 1px solid #555555; font-family: Arial; font-size: 11px; color: #333333; padding-left:2; padding-right:2; padding-top: 1; padding-bottom: 0; background-color : #FFFFFF;">
</td></tr>
<tr><td colspan="2" align="center">
tell alittle about yourself:
</td></tr>
<tr><td colspan="2" align="center">
<textarea name="about" cols="48" rows="8" style="border: 1px solid #555555; font-family: Arial; font-size: 11px; color: #333333; padding-left:2; padding-right:2; padding-top: 1; padding-bottom: 0; background-color : #FFFFFF;"<table width="440" height="400" cellspacing="2" cellpadding="2" border="1"></textarea>
</td></tr>
<tr><td colspan="2" align="center">
have a comment on something?:
</td></tr>
<tr><td colspan="2" align="center">
<textarea name="comment" cols="48" rows="8" style="border: 1px solid #555555; font-family: Arial; font-size: 11px; color: #333333; padding-left:2; padding-right:2; padding-top: 1; padding-bottom: 0; background-color : #FFFFFF;"<table width="440" height="400" cellspacing="2" cellpadding="2" border="1"></textarea>
</td></tr>
<tr><td align="right">
when done:
</td><td>
<input type="submit" name="add" value="add" style="border: 1px solid #555555; font-family: Arial; font-size: 11px; font-variant : small-caps; color: #333333; padding-left:10; padding-right:10; padding-top: 2; padding-bottom: 0; background-color : #FFFFFF;">
</td></tr>
</table>
</form>
<? } } else {
echo "Can't create a profile, when already logged in as: <font color=\"ff0000\">$user</font>";
} ?>
- cut 'n' pasted...
- Problemet tror jeg nok ligger omkring den if-statement ved $res at det går galt.
- Problemet er at ENTEN så kan man 2 brugere med ens brugernavn (nickname) eller også kan man slet ikke oprette en bruger ( sætter et ! ved if($res ....)
Jeg har haft det til at virke, men så efter et stykke tid hvor jeg "rodede" i koden, så virkede det ikke ... *S*
