Register/ Login system

[batstanggt]

Hey guys, new to the forum and I recently joined and left a certain other php Forum because they were a bunch of d-bags if you know what I mean.
I am very new to this so please bear with me. I have now for almost 6 days almost full days too been trying to get a register/ login system to work. I have tried probably about 8 different video tutorials and about 8 different online texts. Ive copied, pasted, typed myself absolutely everything. I know this probably seems pretty pathetic to some of you but Im probably way to persistent for my own good I cannot quit.
So my question is can someone supply me a reliable script that they know for sure works or point me in the direction of where I can find one?
Im completely stuck and dont know where to go from here. I can post some of the codes or the most recent one that i was using if that would help but at this point i wouldnt be opposed to starting from scratch if someone can direct me to a credible source. I feel like alot of the tutorials online are rushed jobs that end up with typos that bugger everything up. SOMEBODY PLEASE HELP!!!
-SB

[batstanggt]

I find it hard to believe that nobody on here knows what is causing this.

[Derokorian]

We can't find problem(s) with your code, if you don't post any code.

[batstanggt]

understandable lol. ok here it is.
I have it set up over two files. A login.html and a login.php.
The login.html looks like this....

<form name="login" method="post" action="login.php">
<table border="0" width="225" align="center">
    <tr>
        <td width="219" bgcolor="#999999">
            <p align="center"><font color="white"><span style="font-size:12pt;"><b>Login</b></span></font></p>
        </td>
    </tr>
    <tr>
        <td width="219">
            <table border="0" width="220" align="center">
                <tr>
                    <td width="71"><span style="font-size:10pt;">Username:</span></td>
                    <td width="139"><input type="text" name="username"></td>
                </tr>
                <tr>
                    <td width="71"><span style="font-size:10pt;">Password:</span></td>
                    <td width="139"><input type="password" name="password"></td>
                </tr>
                <tr>
                    <td width="71">&nbsp;</td>
                        <td width="139">
                            <p align="right"><input type="submit" name="submit" value="Submit"></p>
                        </td>
                </tr>
            </table>
        </td>
    </tr>
    <tr>
        <td width="219" bgcolor="#999999"><font color="white">Not Registered? </font><a href="register.html" target="_self"><font color="white">Register</font></a><font color="white"> </font><b><i><font color="white">Now!</font></i></b></td>
    </tr>
</table>
</form>

And now for the login.php

<?php

//Database Information

$dbhost = "localhost";
$dbname = "dbname";
$dbuser = "mysqluname";
$dbpass = "mysqlpass";

//Connect to database

mysql_connect ( $dbhost, $dbuser, $dbpass)or die("Could not connect: ".mysql_error());
mysql_select_db($dbname) or die(mysql_error());

session_start();
$username = $_POST['username'];
$password = md5($_POST['password']);

$query = "select * from users where username='$username' and password='$password'";

$result = mysql_query($query);

if (mysql_num_rows($result) != 1) {
$error = "Bad Login";
    include "login.html";

} else {
    $_SESSION['username'] = "$username";
    include "memberspage.php";
}

?>

Any suggestions?

[laserlight]

How does it not work?

[batstanggt]

laserlight im assuming you mean what is it doing?
After i submit the form in the login.html the login.php page loads but it just redisplays the login field again.