WampServer

Session start in Index.php. This is part of php.inc. Cannot figure out why I get the error on the query. I would appreciate any help.


<?php

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

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

$query = "SELECT users WHERE userid = '$userid' AND password = '$password' ";
$result = mysql_query($query) or die("Unable to verify user because:" . mysql_error());

if (mysql_num_rows($result) > 0)
{
$_SESSION['valid_user'] = $userid;
echo "Your user account has been validated\n";
echo "<a href=\"index.php\">Home</a>\n";
}
?>

You need to start session, refer to this thread

[forum.wampserver.com]

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

Added Session start to this page. I believe, this was your point of reference.

New error: Parse error: syntax error, unexpected T_VARIABLE in line 4.

This is the $con line. Does not seem right.

Do you forget the ; in the line before that line?

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

You are correct. New error however.

Unable to verify user because:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE userid = 'user' AND password = ...very long password encypted string.

$con = mysql_connect("localhost", "user", "password"

Did you put in the correct user and password here? In other word, did you create the db account for your script yet? If not, check Setup Database guide on my personal website

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides