Total fuck up. Please help. Its for a promotion at work a 5k promotion.

[Preston4321]

The whole thing is not working please i have till tom. to fix it please help heres the link at were its at. www.clancs.us/dh/login.php

<?php

//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);
{
$error = “BadLogin”;
include "includes/login.html";
}

else
{
//$SESSION['username'] = true;
$SESSION['username'] = $username;
include "mainpage.html";
}
?>

[Preston4321]

Please Help!!!!

[Drakla]

if (!mysql_num_rows($result))
{
    $error = “BadLogin”;
    include "includes/login.html";
}
else
{
    $_SESSION['username'] = $username;
    include "mainpage.html";
}

[Preston4321]

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /usr/home/clancs/public_html/dh/login.php on line 24

[kburger]

To see your query problem:

$result = mysql_query($query) or die("Query problem: " . mysql_error()); 

[Drakla]

And remember variables are case sensitive - $Result and $result aren't the same, hence my changes - and change the quotes around that 'bad login' as they're weird.

[LoganK]

Is it just me, or does any other mod (senior) member here feel that "fuck" isn't appropriate in a title?