Hello,

I am trying to set up a profile in an intranet where access is granted over several columns rather than one entry on one column.

This is what I have assumed so far.


if (isset($_POST['username'])) {
$loginUsername=$_POST['username'];
$password=$_POST['password'];
$MM_fldUserAuthorization = "staff1, staff2, projects1, projects2, clients, revisions1, revisions2, consultants";
$MM_redirectLoginSuccess = "home.php";
$MM_redirectLoginFailed = "fail.php";
$MM_redirecttoReferrer = false;
mysql_select_db($database_neilly_davies, $neilly_davies);

$LoginRS__query=sprintf("SELECT staff_id, username, staff1, staff2, projects1, projects2, clients, revisions1, revisions2, consultants FROM ND_staff WHERE staff_id='%s' AND username='%s'",
get_magic_quotes_gpc() ? $loginUsername : addslashes($loginUsername), get_magic_quotes_gpc() ? $password : addslashes($password));

$LoginRS = mysql_query($LoginRS__query, $neilly_davies) or die(mysql_error());
$loginFoundUser = mysql_num_rows($LoginRS);
if ($loginFoundUser) {

$loginStrGroup = mysql_result($LoginRS,0,'staff1', 'projects1', 'projects2'. 'clients', 'revisions1', 'revisions2', 'consultants');


//I am no longer using a join!


mysql> describe ND_staff;
+-------------+-------------------------------+------+-----+---------+---------- ------+
| Field | Type | Null | Key | Default | Extra |
+-------------+-------------------------------+------+-----+---------+---------- ------+
| staff_id | smallint(5) unsigned | NO | PRI | NULL | auto_increment |
| f_name | varchar(30) | NO | | NULL | |
| l_name | varchar(30) | NO | | NULL | |
| email | varchar(80) | NO | | NULL | |
| mobile | char(12) | NO | | NULL | |
| extension | char(3) | NO | | NULL | |
| username | varchar(20) | NO | UNI | NULL | |
| password | char(16) | NO | | NULL | |
| rate | int(3) unsigned zerofill | NO | | NULL | |
| staff1 | char(1) | YES | | NULL | |
| staff2 | char(1) | YES | | NULL | |
| projects1 | char(1) | YES | | NULL | |
| projects2 | char(1) | YES | | NULL | |
| clients | char(1) | YES | | NULL | |
| revisions1 | char(1) | YES | | NULL | |
| revisions2 | char(1) | YES | | NULL | |
| consultants | char(1) | YES | | NULL | |
+-------------+-------------------------------+------+-----+---------+---------- ------+
17 rows in set (0.17 sec)


Thanks for any suggestions

Steve