PHP and SQL trouble

[Luban22]

Hi there,

Im currently creating a login system using php and sql. At the moment i have it that when the user registers their information (i.e username,password) it gets stored in the database. The part that i am having an issue with is that when the user logs in, I want to retrive the relavant data from the database and compare it to what they have entered into the login section. I persume i have to use an sql query something like (SELECT username, password FROM Users) but not sure how to compare it to what the user has entered.

Any help you be greatly appreciated.

Thanks,

Barrie

[Günter_Schenk]

Hi,

does it mean that you´re not using Dreamweaver, which comes with a Login User server behavior which would do all the heavy lifting and generate a correct query ? Just asking, because you posted in the Dreamweaver Application Development forum

[Luban22]

Im using Dreamwaver to write all the code and phpMyAdmin for my database. At the momemt im running the php code on MAMP. I have not uplaoded it to a server yet. I dont no anything about a Login User server.

[Günter_Schenk]

I just stumbled across a tutorial which was written for Dreamweaver MX, but nonetheless explains the workflow in a quite comprehensible manner: http://www.adesdesign.net/php/tutorials/dreamweaver/secure_login.php