PHP/SQL

[noob007]

Does it output anything?

[Dignity]

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/roperson/public_html/Account/cookie.php on line 11
[This part is made by the sError() function]
Error
Incorrect username/password

---

I'm going do a mysql_error() to check it.

---

OMG!

I failded so epicly.

It's because I forgot to select the database!

[noob007]

Lol,

well I'm glad you fixed it.

[Dignity]

It's not fixed throu.

I'm pretty sure I'm doing everything right, I' create a test.

---

Yep, I created an account "t" with the pass of "t" and it says "Incorrect"

[noob007]

Can I see the registration code?

[Dignity]

Code:

$ip=$_REQUEST['ip'];
$psw=$_REQUEST['psw'];
$user=$_REQUEST['user'];

echo "Creating account...<br>";
echo "
<b>Log:</b>
<br>IP: $ip<br>Password: $psw<br>Username: $user<br>Rank: User<br>
<hr>
";


$con = mysql_connect("*","*","*");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
  
  echo "Connected to database<br>Inserting data...<br>";
  
  
  mysql_select_db("roperson_data", $con);

$sql="INSERT INTO User (Username, Password, Rank, IP)
VALUES
('$user', '$psw', 'User', '$ip')";

if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }
echo "Account created.<br>";

mysql_close($con)

[noob007]

You have to hash the password the same way it is hashed in the login script.

[Dignity]

I never got into hashing...

[noob007]

Well,

then don't hash the password in the login script.

[Dignity]

I think I can, based on your hashing.

*Testing*

---

IT WORKS!

thanks.