the apprentice webmaster Posted April 3, 2006 Share Posted April 3, 2006 guy i have a members database like that first_name varchar(50) NO last_name varchar(50) NO email_address varchar(50) NO signup_date datetime NO verified enum('0','1') NO 0 last_login datetime NO bio tinytext NO admin_access enum('0','1') NO 0 username varchar(50) NO passwordok guys , now i wanna create the admistrator username and password so that i can sign in as a administrator , how can i insert the username n passwors in the members tab , so can anyone tell me how to do this thx i'll be waiting for your reply thx Quote Link to comment Share on other sites More sharing options...
shortj75 Posted April 3, 2006 Share Posted April 3, 2006 when you register you have to have admin_access set to 1 which you probable do then you have to have your page check to see if the admin is signed in[code]$getadmin=mysql_query("select * from your_table");while($getadmin2=mysql_fetch_array($getadmin)){if($getadmin[admin_access]>0){echo "you admin code"}else{echo "your visitors code"}}[/code] Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.