Bei diesem Script:
PHP-Code:
<?php
session_start ();
include("db.php");
$sql = "SELECT ".
"nickname, rang, vorname, nachname, geburtstag, homepage, email, icq".
"FROM ".
"benutzerdaten ".
"WHERE ".
"(Nickname like '".$_REQUEST["name"]."') AND ".
"(Kennwort = '".$_REQUEST["pwd"]."')";
$result = mysql_query ($sql);
if (mysql_num_rows ($result) > 0)
{
$data = mysql_fetch_array ($result);
$_SESSION["user_rang"] = $data["rang"];
$_SESSION["user_nickname"] = $data["Nickname"];
$_SESSION["user_nachname"] = $data["Nachname"];
$_SESSION["user_vorname"] = $data["Vorname"];
$_SESSION["user_geburtstag"] = $data["geburtstag"];
$_SESSION["user_email"] = $data["email"];
$_SESSION["user_homepage"] = $data["homepage"];
$_SESSION["user_icq"] = $data["icq"];
header ("Location: intern.php");
}
else
{
header ("Location: formular.php");
}
?>
erhalte ich diese Fehlermeldung:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/www/web293/html/tutorial-scripte/newsscript/login.php on line 14
Warning: Cannot modify header information - headers already sent by (output started at /home/www/web293/html/tutorial-scripte/newsscript/login.php:14) in /home/www/web293/html/tutorial-scripte/newsscript/login.php on line 30
Woran liegt das? Was habe ich falsch gemacht?