[Mike9182]

I'm new to php, especially databases, so this code probably contains a lot of errors. I amt trying to check the username and password from a form on the previous page. When this code runs nothing comes up, and everything that is written after the php code does not appear in the source.

PHP Code:

<?php
//Connect To Database
$hostname='removed for security reasons';
$username='removed for security reasons';
$password='removed for security reasons';
$dbname='Main9182';
$usertable='user';
$user = $_POST["user"] ;
$pass = $_POST["pass"] ;

mysql_connect($hostname,$username, $password) OR DIE ('Unable to connect to database! Please try again later.');
mysql_select_db($dbname);

//Check Username
$query = 'SELECT Username FROM $usertable';
$result = mysql_query($query);
while($result = $user) ;
    {
    $queryp = 'SELECT Password FROM $usertable' ;
    $presult = mysql_query($queryp) ;
    
    //Check Password
    while($presult = $pass) ;
        {
        setcookie("access", "Yes", time()+3600);
        echo "Login successful, click" ;
        echo "<a href='news-edit.php'>here</a>" ;
        echo "to continue" ;
        echo "<SCRIPT LANGUAGE='JavaScript'>" ;
        echo "<!--" ;
        echo "windows.location='news-edit.php ;" ;
        echo "// -->" ;
        echo "</script>" ;
        }
    
    while($presult !=  $pass) ;
        {
        echo "incorrect username or password, please" ;
        echo "<a href='login.php'>retry</a>" ;
        }
    }
while($result != $user) ;
    {
    echo "incorrect username or password, please" ;
    echo "<a href='login.php'>retry</a>" ;
    }
?>

[Mike9182]

I figured out what I did wrong myself, I used "while" as an "if..else" statement.