I am having a problem with a login script not responding how I would hope
Code: Select all
<?php
session_start();
if (isset($_POST['username']) && isset($_POST['password'])){
$username = $_POST['username'];
$password = $_POST['password'];
include ("../includes/prefs.php");
$db_name = "weekends";
$table_name = "users";
$connection = @mysql_connect("$host", "$root", "$password") or die("Couldn't connect.");
$db = @mysql_select_db($db_name, $connection) or die("Couldn't select database.");
$sql = "SELECT * FROM $table_name
WHERE username = \"$username\" AND password = \"$password\"
";
$result = @mysql_query($sql, $connection) or die("Couldn't execute query.");
if (mysql_num_rows($result) > 0){
//looks for registered users
$_SESSION['valid_user'] = $username;
}
}
?>Right now if I add the information
Code: Select all
$num_rows = mysql_num_rows($result);
echo "$num_rows";Thank you in advance for any help.