SQL if result ='s

[Username:]

I'm writing an admin panel for my site (to manage users, etc)

 

 

I selected the user-rights from the DB, but how can I check it the user-rights is equal to 3, and if it is allow access?

[Maq]

WHERE user_rights = 3

 

If no results are returned, then they don't have those rights.

[Rifts]

$sql = mysql_query(" select * from users where name='$name' and pass='$pass' ") or however ur selecting them

while($row = mysql_fetch_assoc($sql))

{ 

  $rights = $row['user_rights'];

}

 

if ($rights == 3)

{

do this

}

else

{

do this

}

 

 

[Username:]

Thanks, solved it before I read the thread though 

$lol = mysql_query("SELECT * FROM user WHERE password='$cookie'");

while ($row = mysql_fetch_array($lol)) {
if($row['type']==="3"){
		} else {
die("no u");
}
}

 

[Maq]

I see, that way makes more sense for what you're trying to do anyway.