Ok, I'm so close... here is my login script:
<form method=post action="<?echo $PHP_SELF?>">
<table cellpadding=2 cellspacing=0 border=0>
<td>Username:</td><td><input type="text" name="lastname" size=10></td><tr>
<td>Password:</td><td><input type="password" name="membernumber" size=10></td><tr>
<td> </td><td><input type="submit" name="login" value="Log In"></td>
</table></form>
<?
if ($login) {
$db = mysql_connect("localhost", "oataorg_ohioata", "atmedical");
mysql_select_db("oataorg_memdb",$db);
$result=mysql_query("select * from membinfo where lastname='$lastname'",$db) or die ("cant do it");
while ($row=mysql_fetch_array($result)) {
if ($row["membernumber"]==$membernumber) {
printf ("Successfully Logged In!<a href=\"newmemupd.php?id=$id\">Click Here</a>");
}
}
}
?>
I know somewhere that i am missing a query to get the ID from the row IF they pass the login criteria... any ideas on doing this? Am i close?
JDW
