WampServer

<?php

$con = mysql_connect("localhost", "user","password" or die('Could not connect to server') ;
mysql_select_db("database",$con) or die('Could not connect to database');

$userid = $_POST['userid'];
$password = $_POST['password'];

$query = "SELECT userid FROM users WHERE userid = '$userid' and password = PASSWORD('$password')";
$result = mysql_query($query);

if (mysql_num_rows($result) == 0)
{
echo "Sorry, your user account was not validated.\n";
echo "<a href =\"index.php?content=login\">Try again</a><br>\n";
echo "<a href =\"index.php\">Return to Home</a>\n";
}
else{
$_SESSION['valid_user'] = $userid;
echo "Your user account has been validated.<br>\n";
echo "<a href =\"index.php\">Return to Home</a>\n";
}
?>

whats the errror ur getting?

$query = "SELECT userid FROM users WHERE userid = '$userid' and password = PASSWORD('$password')";


should it not be

$query = "SELECT userid FROM users WHERE userid = '$userid' and password = '$password'";

Parse error: syntax error, unexpected T_ELSE

Try this mate.

<?php

$con = mysql_connect("localhost", "user","password" or die('Could not connect to server') ;
mysql_select_db("database",$con) or die('Could not connect to database');

$userid = $_POST['userid'];
$password = PASSWORD($_POST['password']);

$query = "SELECT userid, password FROM users WHERE userid = '$userid' and password = '$password'";
$result = mysql_query($query);

if (mysql_num_rows($result) == 0)
{
echo "Sorry, your user account was not validated.\n";
echo "<a href =\"index.php?content=login\">Try again</a><br>\n";
echo "<a href =\"index.php\">Return to Home</a>\n";
}
else{
$_SESSION['valid_user'] = $userid;
echo "Your user account has been validated.<br>\n";
echo "<a href =\"index.php\">Return to Home</a>\n";
}
?>

also, im pressuming that PASSWORD is a function you created?



Edited 1 time(s). Last edit at 04/16/2008 11:46PM by miiikkeyyyy.

Thank you !!



Parse error: syntax error, unexpected T_ELSE


Got past one error. However for some reason it does not like the else part of the ....if else.

What line does it say the error is on?
I've run your code, and the only errors I get are the face there is no PASSWORD function and that there is no results...

Thats because I dont have the database.
Other than that, your script worked absolutly fine mate.

else { line is the beginning of the next error message. Thinking this could have something to do with the SESSION portion under the statement ?

dunno lol. Try look up $ cookie ..