pouncer Posted November 7, 2006 Share Posted November 7, 2006 [code=php:0] $Password = md5($Password); mysql_query("SELECT * FROM users WHERE username='$Username' AND password='$Password'"); $login_check = mysql_num_rows($sql); if ($login_check > 0) { //check if activated. }[/code]i need to check if the 'Activated' field of the user is 1. i.e, if the user who is logging in has actually activated their memberhsip. how do i do this? Quote Link to comment Share on other sites More sharing options...
roopurt18 Posted November 7, 2006 Share Posted November 7, 2006 [code]<?php$sql = "SELECT * FROM users WHERE username='$Username' AND password='$Password'"$q = mysql_query($sql);if($q){ while($row = mysql_fetch_assoc($q)){ if($row['Activated'] == 1){ // It is activated } break; }}?>[/code] Quote Link to comment Share on other sites More sharing options...
pouncer Posted November 7, 2006 Author Share Posted November 7, 2006 Thanks. but what if that username or password do not exist in the database? Quote Link to comment Share on other sites More sharing options...
roopurt18 Posted November 7, 2006 Share Posted November 7, 2006 Then it's obviously not activated.[code]<?php$sql = "SELECT * FROM users WHERE username='$Username' AND password='$Password'"$q = mysql_query($sql);if($q){ while($row = mysql_fetch_assoc($q)){ if($row['Activated'] == 1){ // It is activated } break; }}else{ // No record found echo 'You need to register!';}?>[/code] Quote Link to comment Share on other sites More sharing options...
pouncer Posted November 7, 2006 Author Share Posted November 7, 2006 oh yeah. sorry.Thanks, perfect. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.