Posted by Johannes on 05/20/07 14:03

Hey guys,

I'm building a login script using an active or inactive state, but
when i check for this state it just simply skips to the incorrect
login. It looks like the If ... AND ... part isn't working. Can
anybody give me a hand with this problem?

here's the code I use:

<?php
include("connect.php");
session_start();

if (!empty($_POST)){
$query = "SELECT * FROM KLANT
WHERE Email='".$_POST["Email"]."'
AND Wachtwoord='".$_POST["Wachtwoord"]." ' ";
$result=mysql_query($query) or die("FOUT : " . MySQL_error());

if ((Status=="actief") AND (MySQL_num_rows($result) >0)){
$username=$_POST["Email"];
$wachtwoord=$_POST["Wachtwoord"];
session_register("username");
session_register("wachtwoord");
mysql_fetch_row($result);
header("Location: winkel.php");
exit();
}
elseif ((Status=="inactief") AND (MySQL_num_rows($result) >0)){
$tekst="Uw account staat momenteel op niet-actief<br>
Neem a.u.b. contact op met de winkel";
die($tekst);
}else{
$tekst="U hebt geen geldige combinatie van e-mailadres en
wachtwoord opgegeven. Maak een keuze: <br>
<a href=\ 'inloggen.php\'>Opnieuw inloggen</a><br>
<a href=\ 'aanmelden.php\'>Hier registreren</a><br>";
die($tekst);
}}
?>

• Next in forum: Re: safe to delete elements of array in foreach
• Prev in forum: Get values from textfield
• Thread view: if AND

[Reply to this message]