Keeping authentication

Hello, I am attempting to build a series of pages that are only visible to people logged in through the auth script I wrote using a MySQL db to hold the auth users. login.php--Login script that takes username and password from user. myhome.php--If username and password check out myhome.php displays information that is authed by thier account. other.php-- *concept* if username and password still check out then this page will display blah blah and blah3. I can login just fine and myhome.php displays correctly. But when I go to look at other.php it kicks me back to the login.php screen asking for my username and password again. In the other.php page what and how do I ask the database if someone is still logged in or not logged in so that the authorized information will show? Any help would be appreciated Thanks Kat