Matching up password?

[darklight]

How would I match up the password and id to the pass and id in mysql?  Example:

 

Site id = some id here

Pass= Some pass here

[cooldude832]

query for it, then check if the num_rows >0 if so its a match else its not

[darklight]

I did...it failed to work..

[cooldude832]

Then show what you did.

[darklight]

$getpass = mysql_query("SELECT * FROM site where siteid='$rm' AND sitepassword='$sitepass'");
$row = mysql_fetch_row($getpass);
$num = mysql_num_rows($getpass);

if($num['sitepassword'] > 0)
{
header("Location:s/$rm.php");
}

 

[freakstyle]

 

looks like you are checking the wrong data type.

 

$num  should not be an array.

 

ex:

if( $num > 0)
{
header("Location:s/$rm.php");
}

 

 

side note: you should refrain from pulling the record with a password, if you need to you can always escape it. it leaves you open to injection attack.

 

ref: http://us2.php.net/mysql_escape_string

 

Good luck

 

 

 

[darklight]

It still won't work.  I have no clue what I'm doing...I just started mySQL.