Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/....../login.php on line 23

<?php



//Database Information(habe ich angegeben)



$dbhost = "localhost";

$dbname = "?";

$dbuser = "?";

$dbpass = "?";



//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";

}



?>

<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"></font><a href="register.html" target="_self"><font color="white">Jetzt Registrieren</font></a><font color="white"> </font><b><i><font color="white"></font></i></b></td>

    </tr>

</table>

</form>

<?php



//Database Information



$dbhost = "localhost";

$dbname = "ttit...";

$dbuser = "ttit...";

$dbpass = "******";



//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";

}



?>

<form name="login" method="post" action="register.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>Registration</b></span></font></p>

        </td>

    </tr>

    <tr>

        <td width="219">

            <table border="0" width="282" align="center">

                    <tr>

                        <td width="116"><span style="font-size:10pt;">Name:</span></td>

                        <td width="156"><input type="text" name="name" maxlength="100"></td>

                    </tr>

                    <tr>

                        <td width="116"><span style="font-size:10pt;">Email:</span></td>

                        <td width="156"><input type="text" name="email" maxlength="100"></td>

                    </tr>

                <tr>

                    <td width="116"><span style="font-size:10pt;">Username:</span></td>

                    <td width="156"><input type="text" name="username"></td>

                </tr>

                <tr>

                    <td width="116"><span style="font-size:10pt;">Password:</span></td>

                    <td width="156"><input type="password" name="password"></td>

                </tr>

                <tr>

                    <td width="116">&nbsp;</td>

                        <td width="156">

                            <p align="right"><input type="submit" name="submit" value="Submit"></p>

                        </td>

                </tr>

            </table>

        </td>

    </tr>

    <tr>

        <td width="219" bgcolor="#999999">&nbsp;</td>

    </tr>

</table>

</form>

<?PHP



//Database Information



$dbhost = "localhost";

$dbname = "ttit......";

$dbuser = "ttit....";

$dbpass = "*****";



//Connect to database



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

mysql_select_db($dbname) or die(mysql_error());





$name = $_POST['name'];

$email = $_POST['email'];

$username = $_POST['username'];

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



// lets check to see if the username already exists



$checkuser = mysql_query("SELECT username FROM users WHERE username='$username'");



$username_exist = mysql_num_rows($checkuser);



if($username_exist > 1){

echo "I'm sorry but the username you specified has already been taken. Please pick another one.";

unset($username);

include 'registration.htm';

exit();

}



// lf no errors present with the username

// use a query to insert the data into the database.



$query = "INSERT INTO users (name, email, username, password)

VALUES('$name', '$email', '$username', '$password')";

mysql_query($query) or die(mysql_error());

mysql_close();



echo "You have successfully Registered";



// mail user their information



$yoursite = ‘Tit’;

$webmaster = ‘tit’;

$youremail = ‘Tit’;



$subject = "You have successfully registered at $yoursite...";

$message = "Dear $name, you are now registered at our web site.

To login, simply go to our web page and enter in the following details in the login form:

Username: $username

Password: $password



Please print this information out and store it for future reference.



Thanks,

$webmaster";



mail($email, $subject, $message, "From: $yoursite <$youremail>\nX-Mailer:PHP/" . phpversion());



echo "Your information has been mailed to your email address.";



?>

<?



// members page



session_start();



if ( empty( $username ) ) {



    print "Please login below!";



    include 'login.html';



} else {



// you can use regular html coding below the ?>

// and before the <?



?>



<html>

<head>

<title>MEMBERS ONLY</title>

</head>

<body>

Your Members Page....

</body>

</html>



<?

<a href="http://google.ch">Infos</a>

?>

CREATE TABLE users (

  userid int(25) NOT NULL auto_increment,

  name varchar(25) NOT NULL default '',

  email varchar(255) NOT NULL default '',

  username varchar(25) NOT NULL default '',

  password varchar(255) NOT NULL default '',

  PRIMARY KEY  (userid),

  UNIQUE KEY username (username)

) TYPE=MyISAM COMMENT='Members';