Hi
Posted: Sat Sep 26, 2009 10:53 am
Can anyone help me please, i keep getting this problem.
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /www/sites/lcn/www.simplepm.co.uk/web/login.php on line 23
Please find below my php code, have been trying to solve this issue for a while now, but cant seem to solve it, please help
<?php
//Database Information
$dbhost = "database.lcn.com";
$dbname = "simplepm?co?uk?db";
$dbuser = "LCN_9330";
$dbpass = "password";
//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";
}
?>
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /www/sites/lcn/www.simplepm.co.uk/web/login.php on line 23
Please find below my php code, have been trying to solve this issue for a while now, but cant seem to solve it, please help
<?php
//Database Information
$dbhost = "database.lcn.com";
$dbname = "simplepm?co?uk?db";
$dbuser = "LCN_9330";
$dbpass = "password";
//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";
}
?>