mysql_num_rows():

Ik krijg best vaak deze warning: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in

Maar ik heb geen idee wat ik daar fout doe ik gebruik deze code:

[COLOR= #0000BB]<?php
      $query[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT status FROM ledensysteem WHERE username = $username and password = $pass1"[/COLOR][COLOR= #007700]);[/COLOR]
      [COLOR= #0000BB]$rows[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_num_rows"]mysql_num_rows[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$query[/COLOR][COLOR= #007700]);[/COLOR]         
      [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$rows[/COLOR] [COLOR= #007700]>[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700]){[/COLOR]         
         [URL="http://www.php.net/print"]print[/URL] [COLOR= #DD0000]"<font size=1 face=verdana>Je bent succesvol ingelogt  als "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$username[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #DD0000]",<br>"[/COLOR][COLOR= #007700];[/COLOR] ?>

Zouden jullie ook kunnen uitleggen wat ik fout doe.

Hoi,

je query geeft geen geldig resultaat

gebruik eens:

$query = mysql_query("SELECT status FROM ledensysteem WHERE username = $username and password = $pass1") or die (mysql_error());

hierdoor worden fouten in de query weergegeven.

Groetjes,
Marijn

Dankje krijg nu dit: Unknown column status in field list

Rij "status" bestaat dus niet in tabel "ledensysteem"

Sorry snap er niet veel van want ik kan dat status wel weg halen maar dan krijg ik nogal een rare error ik weet dus niet wat ik fout deed

Die kollom bestaat dan niet moet je ff aanmaken

Ik gebruik dat heletabel niet ik wil dus dat alles wat met status temaken heeft weg gaat maar daar snap ik niet veel van me code:

[COLOR= #0000BB]<?[/COLOR] 
[URL="http://www.php.net/session_start"]session_start[/URL][COLOR= #007700]()[/COLOR]
?>
[COLOR= #0000BB]<?[/COLOR] 
[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_SERVER[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]"login"[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #DD0000]"true"[/COLOR][COLOR= #007700]) {[/COLOR]
   [URL="http://www.php.net/print"]print[/URL] [COLOR= #DD0000]"<font size=1 face=verdana>Je bent al ingelogt"[/COLOR][COLOR= #007700];
}[/COLOR]
[URL="http://www.php.net/else"]else[/URL] [COLOR= #007700]{[/COLOR]
   ?>
   <font size=1 face=verdana>
   <FORM action="inloggen1.php" method="post">         
   Gebruikersnaam:<br>         
   <INPUT type="text" name="username">    status     
   <BR>         
   Wachtwoord:<br>         
   <INPUT type="password" name="pass"><br>         
   <input type="submit" value="Inloggen" name="submit">         
   </form>       
   <p>
  [COLOR= #0000BB]<?[/COLOR] 
[COLOR= #007700]}[/COLOR]
[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/isset"]isset[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]submit[/COLOR][COLOR= #007700]])) {[/COLOR]
   [COLOR= #0000BB]$username[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/trim"]trim[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/strtolower"]strtolower[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]username[/COLOR][COLOR= #007700]]));[/COLOR]
   [COLOR= #0000BB]$pass1[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]pass[/COLOR][COLOR= #007700]];[/COLOR]
   [COLOR= #0000BB]$dead[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"false"[/COLOR][COLOR= #007700];[/COLOR]
   [COLOR= #0000BB]$message[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"<font size=1 face=verdana>Vul alles goed in"[/COLOR][COLOR= #007700];[/COLOR]
   [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/strlen"]strlen[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$username[/COLOR][COLOR= #007700]) <=[/COLOR] [COLOR= #0000BB]1[/COLOR] or [URL="http://www.php.net/strlen"]strlen[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$username[/COLOR][COLOR= #007700]) >=[/COLOR][COLOR= #0000BB]15[/COLOR][COLOR= #007700]){[/COLOR]
      [COLOR= #0000BB]$dead[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"true"[/COLOR][COLOR= #007700];[/COLOR]
      [COLOR= #0000BB]$message[/COLOR] [COLOR= #007700].=[/COLOR] [COLOR= #DD0000]"Gebruikersnaam klopt niet<br>"[/COLOR][COLOR= #007700];
   }[/COLOR]
   [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/strlen"]strlen[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$pass1[/COLOR][COLOR= #007700]) <[/COLOR] [COLOR= #0000BB]1[/COLOR] or [URL="http://www.php.net/strlen"]strlen[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$pass1[/COLOR][COLOR= #007700]) >[/COLOR] [COLOR= #0000BB]100[/COLOR][COLOR= #007700]) {[/COLOR]
      [COLOR= #0000BB]$dead[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"true"[/COLOR][COLOR= #007700];[/COLOR]
      [COLOR= #0000BB]$message[/COLOR] [COLOR= #007700].=[/COLOR] [COLOR= #DD0000]"Wachtwoord klopt niet<br>"[/COLOR][COLOR= #007700];
   }[/COLOR]
   [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$dead[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"false"[/COLOR][COLOR= #007700]){[/COLOR]
      [URL="http://www.php.net/include"]include[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]config.php[/COLOR][COLOR= #007700]);[/COLOR]
      [COLOR= #0000BB]$pass1[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/md5"]md5[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$pass1[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$query[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT FROM ledensysteem WHERE username = $username and password = $pass1"[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL] [COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR]
      [COLOR= #0000BB]$rows[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_num_rows"]mysql_num_rows[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$query[/COLOR][COLOR= #007700]);[/COLOR]         
      [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$rows[/COLOR] [COLOR= #007700]>[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700]){[/COLOR]         
         [URL="http://www.php.net/print"]print[/URL] [COLOR= #DD0000]"<font size=1 face=verdana>Je bent succesvol ingelogt  als "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$username[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #DD0000]",<br>"[/COLOR][COLOR= #007700];[/COLOR]         
             [COLOR= #0000BB]$row[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$query[/COLOR][COLOR= #007700]);[/COLOR]
         [COLOR= #0000BB]$username[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$username[/COLOR][COLOR= #007700]);[/COLOR]
         [COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]login[/COLOR][COLOR= #007700]]=[/COLOR]true[COLOR= #007700];[/COLOR]           
         [COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]"username"[/COLOR][COLOR= #007700]]=[/COLOR][COLOR= #0000BB]$username[/COLOR][COLOR= #007700];
      }[/COLOR]
      [URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
         [URL="http://www.php.net/print"]print[/URL] [COLOR= #DD0000]"<font size=1 face=verdana>Je hebt een foute gebruikersnaam of wachtwoord ingevuld"[/COLOR][COLOR= #007700];
      }         
      
   }[/COLOR]
   [URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
      [URL="http://www.php.net/print"]print[/URL] [COLOR= #0000BB]$message[/COLOR][COLOR= #007700];
   }
}[/COLOR]
      
?>

Niemand?