I am currently building a site with mysql 5 and php 5.
I have two tables viz user_master and user_class.
I want to create a page which will input loginid and password from user, validate the availabilty of user and create some kind of hidden paramters consisting userid and classid. Without which other pages will not be able to display any content.
Can anybody help me out in this regard? :mad:
mysql> desc user_master;
+---------+---------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+---------------------+------+-----+---------+-------+
| userid | int(10) unsigned | NO | PRI | | |
| classid | tinyint(3) unsigned | NO | | | |
| fname | varchar(50) | NO | | | |
| mname | varchar(50) | YES | | NULL | |
| lname | varchar(50) | NO | | | |
| loginid | varchar(12) | NO | | | |
| pass | blob | NO | | | |
+---------+---------------------+------+-----+---------+-------+
7 rows in set (0.03 sec)
mysql> desc user_class;
+-----------+---------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+---------------------+------+-----+---------+-------+
| classid | tinyint(3) unsigned | NO | PRI | | |
| classname | varchar(30) | NO | | | |
+-----------+---------------------+------+-----+---------+-------+
