ok...here's the deal.
I have successfully developed a script to verify user authenticity. however,
i need to verify what the "User Type" is for purposes of redirection to a
certian page.
+----+---------------------+-----------+----------+
| ID | BearID | SSN | UserType |
+----+---------------------+-----------+----------+
| 1 | Kristin_L_Barber | 111111112 | Student |
| 2 | Christina_Barbosa | 111111113 | Student |
| 3 | David_Beran | 111111114 | Student |
| 4 | Sam_Bernal | 111111115 | Student |
| 5 | Christie_Biggs | 111111116 | Student |
| 6 | Teresa_Bland | 111111117 | Student |
| 7 | Tiffany_Boshers | 111111118 | Student |
| 8 | Kathy_Bowen | 111111119 | Student |
| 9 | Aaron_Boyk | 111111120 | Student |
| 10 | Emily_Calvert | 111111121 | Student |
This is a sample of my table.
how would i go about checking the user type after I have verified that the
user exists in the table? I tried this query:
// Determine User Type For Redirection
$redirect = "SELECT UserType FROM User WHERE
BearID = '$PHP_AUTH_USER' AND
SSN = '$PHP_AUTH_PW'";
// Execute query to set User Type variable
$type = mysql_query( $redirect )
or die ( 'Unable to execute query.' );
what do I need to do from here?
Any suggestions?
Thanx,
Kit
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
---------------------------------------------------------------------
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
