Login and join up page

[JShor]

There are simpler ways to make a login/register form using $_SESSION ...

[rm_dynamicdrive]

can you try to separate this?

here: if (( $num = mysql_num_rows($result) ) and ($passwort != ""))

allow $num to hold the arguments.
then apply this to an if condition

$num = mysql_num_rows($result);
if ( ( $num ) and ($passwort != "") )

[j123]

I think i got something to do with Database

I get the error Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/jarodco/public_html/login/login.php on line 30 when logging in.

I think what's happening is that you have an incorrect sql query syntax, causing mysql_num_rows(x); to have a null value.

You;re using $_SESSION to get a result, but if there's no session [via the conversion from GET to SESSION, it will have a null result of course.

Try replacing that area of code w/this:

    // convert username and password from _GET to _SESSION 
    if($_POST){ 
      $_SESSION['username']=$_POST["username"]; 
      $_SESSION['passwort']=$_POST["passwort"];   
    } 

Replace all GET with POST, that's basically it.

HTH

[j123]

I try that but i make it a bit more made

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/jarodco/public_html/login/login.php on line 2

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/jarodco/public_html/login/join.php on line 3
Username: Password:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/jarodco/public_html/login/login.php on line 33
Login Failed.

Username:

Password:

can you try to separate this?

here: if (( $num = mysql_num_rows($result) ) and ($passwort != ""))

allow $num to hold the arguments.
then apply this to an if condition

$num = mysql_num_rows($result);
if ( ( $num ) and ($passwort != "") )

[rm_dynamicdrive]

try this:

after this line you add:
$result=mysql_query($sql);
$num=mysql_num_rows($result);

if($num=0) {

} else { et.......


or check your query.

$sql = "SELECT * FROM sys_user WHERE username = '$username' AND passwort = '".md5($passwort)."' OR passwort = PASSWORD($passwort))";

how?

1. after that command put die($sql); okay.
2. when php reach the die command the query string appear on your screen.
3. use your mysql command line or any mysql software copy/paste the result and you will see what will happen.