Re: Again, and Again, and AGAIN!

Dr. Shim wrote:

I've tried repediately to have a PHP script validate a form when the form is submitted. I'm quite new to PHP, and I'd really appreciate the help anybody could give me. I've been stuck on this problem far to long. I have a form (here's the code): <form method="post" action="<?php $PHP_SELF; ?>"> Username: <input type="text" name="username" maxlength="255" value="<? $HTTP_POST_VARS['username']; ?>"> The shortcut is <?php =$blah?>, not <?php $blah?>

<br> Password: <input type="text" name="password" maxlength="8" value="<? $HTTP_POST_VARS['password']; ?>"> <br> <input type="submit" name="login" value="Log In" onclick="document.refresh()"> document.submit() should do it, refresh() will just reload the page.

<br> <br> </form> And right underneath the form code, I have my PHP script: <?php if (isset($login)) { insert(); } function insert() { $db = odbc_connect('mydatabase', 'myusername', 'mypassword'); if(!$db) { echo "An error has occured. Please <a href=\"mailto:drshim@alienmelon.com\">e-mail</a> the text below to me.<br><br>~~~~~~~<br>$PHP_ERROR<br>$db<br>~~~~~~~"; } $SQLQuery = "SELECT fldID FROM tblUsers WHERE fldUsername = '$username' AND fldPassword = '$password'"; $cursor = odbc_exec($db, $SQLQuery); if (!$cursor) { echo "An error has occured. Please <a href=\"mailto:drshim@alienmelon.com\">e-mail</a> the text below to me.<br><br>~~~~~~~~<br>" . odbc_errormsg($db) . "<br>~~~~~~~"; } } ?> What I'm trying to achieve here is that when the user fills out the form, presses the "Log In" button, the script underneath validates and inserts the data into a database. Now, I click on the "Log In" button, nothing happens. Could anybody please help me with this? I would really, really appreciat any help.