Log in problem

[Cyaankali]

I have been messing around with Macromedia Dreamweaver MX and it is going quite well. I have been able to make a database with information people give me on the web page. The only problem is that my login doesn't work. I let him compare the password and username the visitor typs with the information in the database but it allways shows the wrong page so it fails! Can anyone help me please???

Thnx

 

[GUJUm0deL]

Are you using SQL to check for the username and password?? I have not failed; I have merely found 100,000 different ways of not succeding...

 

[Cyaankali]

Ive just put a server beharvior and then you have to specifie the database and wich colums he has to compare with the information given. So do I have to use SQL?

 

[Cassien]

When you say it goes to the wrong page do you mean it redirects to the wrong page after putting in user name and password?

if so are you using just user name and password or is there also authentication levels? if there is then check them on the destintation page, it could be you're being redirected twice!

 

[Cyaankali]

after i put in the username and password i'mredirected to the wrong page like i would have given the wrong username or password

 

[GUJUm0deL]

Cyaankali, how are you checking for the username/password to the dB??
For example, in coldfusion if we want to check the username/password from the database, we would use:

SELECT username, password
FROM table1
WHERE username = '#form.username#'
AND password = '#password#'


Now the # signs are just a coldfusion requirement, and not SQL...
What this does is check the database to make sure the username/password is right...
Can you post what you're using to check for the username/password in the dB?? Where on your coding do you have that says that if the username/password is wrong, go to this page?? I have not failed; I have merely found 100,000 different ways of not succeding...

 

[Cyaankali]

THNX for all your help finally it works!!!
I just had to switch to things that were wrong. Very stupid!!!