eastcoastdubs

I have a userid and email field and I have a function checking if both are in the database first and to give the correct error message if they are not. BUT hypothetically speaking. Say someone putd a username and email address that are both in the database BUT they are not in the same record. I tried doing this and I got a blank screen. The query goes thru correctly since the error messages I have just check to see if they are in the database. BUT there is no error stoping saying they are not in the same record since the email and userid do not match. Should I use a third function checking both field and saying that the combination email and userid do not match? I use this to get the fields for my mail() function $sql = \"SELECT userid, userpassword, username, useremail FROM $user_tablename WHERE userid = \'$userid\' AND useremail = \'$email\'\";

one more question. the database I\'m making is just for users having a profile of there cars. Do you really think it is necessary to even encrypt the passwords?

I have finally made a perfectly functioning forgot password email script. Emails perfectly, subject, to, from, body. except. the this The password field name in the database is userpassword. I AM using mysql\'s encryption method password(\'userpassword\') but how do I send it to the email? I have the select query doing thing. $sql = \"SELECT userpassword, username, useremail FROM $user_tablename WHERE useremail = \'$email\'\"; it works fine. BUT the userpassword is not passed thru to the email with $userpassword. anyhelp? thanks all, btw I have only been working with mysql for a week now so bear with me if this is a major brain fart. Also, is there a better/easier encryption method? that will do what I am looking to do?

I am in the process of automating users profiles so they can log in and change their CAR information. Since I am in the test phase I put random info in and everything works fine. My problem is that when I delete a record ( up to 17 so far from testing ) The autoincremented number keeps going from 17 to 18 and so on. How do I reset the indexes so it starts at 1 again? Thanks