(assuming you're using PHP...) The best idea would probably be to create a column in your users table which indicates which company each user belongs to. Then, using "select company_name from users where username EQ ".$username; If you're not using PHP, the idea is still the same. Use a MySQL query to bring up the name of the company in a record with a username specified in a variable. Easy as pie. Benji Smith [EMAIL PROTECTED] Technical Director Osenta, Inc. www.osenta.com ----- Original Message ----- From: "Taline Makssabo" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, June 18, 2001 9:18 AM Subject: help! > Hi, > Fairly new at this so i need all the help i could get. I created a admin > page where admin can add/mod/del/view from this page. But now I need to give > access to other admins but from diffrent companies where I need to grant > diffrent username and passwords to the original admin page. Each company > have to be redircted to there personal admin page. How do i go around this? > I'm using PHP AND mysql. Do i make a table where these diffrent usernames > and passwords are inserted to and then do a sort statement by company???? > > Lost > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php