gelobelmonte

this is from the login form of our website. www.mcssonline.org. the registration seem to work fine..

Wow, I think I'm a bit closer.. I need to make a field on the table named as 'active' then? What would be the suggested parameters? Thank you!

Additional info: i tried adding this: $result = mysql_query($sql, $db) or trigger_error ( mysql_error ( ) ); but a notice prompted at the error message as follows: Unknown column 'active' in 'field list' in /home/mcssonli/public_html/login.php on line 18

I am not sure on how to use it.. but i tried it this way.. this is where the error occurs $db = mysql_connect($mysql_server, $mysql_username, $mysql_password); mysql_select_db($mysql_database, $db); $sql = "SELECT password, fullname, active FROM ".$mysql_table." WHERE username = '".$_POST['username']."'"; $result = mysql_query($sql, $db); if ($data = mysql_fetch_array($result)) { if ($crypt_pass == $data['password'] && $data['active'] != 0) { $found = true; $fullname = $data['fullname']; } else die(mysql_error()); } mysql_close($db); if($found == false) { header('Location: '.$error_page); exit; }

Yes, I have read it.. But I really don't know how to use it.

can you explain it to me simpler then? I really don't understand that much..

Thanks for your fast response sir.. But what is supposed to be my right code? I'm just a newbie on this that's why I don't have any idea.. Thank you sir!

Good day phpfreaks people! i'm a newbie in web programming and I encountered this problem.. I don't know how to fix it.. please help me.. this error prompts everytime i try logging in.. The registration for works but the login doesn't.. please help me.. this is my code where the error is.. $db = mysql_connect($mysql_server, $mysql_username, $mysql_password); mysql_select_db($mysql_database, $db); $sql = "SELECT password, fullname, active FROM ".$mysql_table." WHERE username = '".$_POST['username']."'"; $result = mysql_query($sql, $db); if ($data = mysql_fetch_array($result)) { if ($crypt_pass == $data['password'] && $data['active'] != 0) { $found = true; $fullname = $data['fullname']; } } mysql_close($db); if($found == false) { header('Location: '.$error_page); exit; } else { session_start(); $_SESSION['username'] = $_POST['username']; $_SESSION['fullname'] = $fullname; $rememberme = isset($_POST['rememberme']) ? true : false; if ($rememberme) { setcookie('username', $_POST['username'], time() + 3600*24*30); setcookie('password', $_POST['password'], time() + 3600*24*30); } header('Location: '.$success_page); exit; } } Thanks in advance for your help.. Gelo