Jump to content


Photo

anyone help please


  • Please log in to reply
1 reply to this topic

#1 the apprentice webmaster

the apprentice webmaster
  • Members
  • PipPipPip
  • Advanced Member
  • 65 posts

Posted 03 April 2006 - 06:26 AM

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
password

ok 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

#2 shortj75

shortj75
  • Members
  • PipPipPip
  • Advanced Member
  • 118 posts
  • LocationPort Huron,mi

Posted 03 April 2006 - 08:29 AM

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
$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"
}
}

The Short One

hopfully this helps if it doesn't sorry
i won't write the code for you!!! you don't learn that way




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users