login password verification
Posted on 2004-08-25
I am fairly new to php. I created a db table with passwords that I am trying to verify by means of a login box. The password will load page with administrative options (add, modify, and delete menu). The login box code contains:
echo("<form method='post' action='petsnamelist2.php3'>");
echo("<input type='password' name='pwauth' value='Password' size='10'>");
echo("<input type='submit' value='Submit'></p>");
The admin page (petsnamelist.php3) contains code:
$query_update = "SELECT * FROM pwd where passwd = " . $pwauth;
$query_result = mysql_query ($query_update);
echo ("<p>There was an error performing this SELECT query from the PETS table. " .
mysql_error() . "</p>");
I get the following error message: "There was an error performing this SELECT query from the password table. Unknown column '735step9' in 'where clause'"
I can't figure out why password value (735step9) is read as a column (column name is passwd) and not as a value? I am just trying to verify value in db table. Any ideas? Thanks very much.