php.mysql login..

[ziprock]

i want to be able to login to my site. i have set up my regitration form.. that part was easy. now i have somthing you could call an account, with an sql table that includes my username, password, rank, and email. but um.. how do i login?

im guessing a simple forum will do? using this query

PHP Code:

$query = ("SELECT * FROM `users` WHERE username='".$username."' AND password='".$password."'") or die("MySQL Login Error: ".mysql_error()); 


my biggest question is after im logged in.. Ziprock being set as my $username variable and my password set to $password how will i get my code to remember the information i put in on login.php so when i go to pages it will remember me

[Scott]

check this out: http://www.phphq.net/scripts.php?p=code-bits&id=5

pretty basic but it's a start

[ziprock]

id check the code on that and run it somwhere.

for some reason i cant figure this out, ive downloaded login scripts and edited them in places so that they should work for me but same thing always happens