Surpass Web Hosting Forums - View Single Post

**cass_is_awesome** · March 12th, 2008, 4:25 PM

Roxy: Thanks for the advice.

I fixed it.

I don't know what was wrong, but as opposed to running a query to check both the password and user name in the DB separately, I just had one query line check both of them in one, like so:

Code:

            $userName = $_POST['userName'];
            $userPass = $_POST['userPass'];
            DBConnect("contraba_users");
            $sqlCheckUser = mysql_query("SELECT userName,userPass FROM `users` WHERE `userName` = '$userName' AND `userPass` = '" . md5($userPass) . "' LIMIT 1");

I hate this stuff sometimes.

March 12th, 2008, 4:25 PM	#3 (permalink)
cass_is_awesome I killed the bus driver. On a golden path... Joined in Mar 2008 Lives in Michigan Hosted on SH138 326 posts Gave thanks: 6 Thanked 8 times	Roxy: Thanks for the advice. I fixed it. I don't know what was wrong, but as opposed to running a query to check both the password and user name in the DB separately, I just had one query line check both of them in one, like so: Code: $userName = $_POST['userName']; $userPass = $_POST['userPass']; DBConnect("contraba_users"); $sqlCheckUser = mysql_query("SELECT userName,userPass FROM `users` WHERE `userName` = '$userName' AND `userPass` = '" . md5($userPass) . "' LIMIT 1"); I hate this stuff sometimes. __________________ I tend to turn every thread I post in into the Post A Random Photo Thread Last edited by cass_is_awesome; March 12th, 2008 at 4:26 PM.