password protection using mysql and php

[cs30841]

I want to set up a script that will use password protection to protect a roster that will be displayed in a table and stored in a mysql table. based on the username and password that enter will be stored in a mysql database with a user group. i want it to only show certin information based on the user group. such as if the group is "nc" it will filter the list to people with "state" of NC. where can i go to find out how to do this? of can somebody help me out and tell me what i need to do. im kinda new to php and sql. thanks in advance.

chuck

[nashirak]

Well... that is pretty broad... but... I would start by determining what information you want in your database. For instance you will want a UserName and Password Field. Then you are going to want some type of Group Field and then any other information you want. You might even want to setup seperate tables for each group or something. Once the user "logs in" you are going to want to start sometype of session managment

read:

http://www.php.net/manual/en/ref.session.php

for information on those. You are going to keep the users session throught the time he is logged on. Um... to just "filter" information by group I would do that using MYSQL like mabye:

// Login
$result = MYSQL_QUERY("SELECT*FROM Table WHERE UserName = '$USER' && Pass = '$Pass');

then once you have the user you can look up his group:

$table = MYSQL_RESULT($result,0,"Group");

$results = MYSQL_QUERY("SELECT*FROM $table");

$i = 0;
while ($i < MYSQL_NUM_ROWS($results)) {
$info = MYSQL_RESULT($results,$i

echo $info;
}// end while

something like that should filter the groups. As for more help on this, try looking at some of the sample Code on this site. And mabye even some of the Articles. There are many other PHP site that can help you as well... I have found DEV SHED
www.devshed.com can be a good site ever now and again. Otherwise good luck and come back with any specific questions here when you have trouble.