"marking" DB entries...

From: Date: Fri, 22 Mar 2002 17:07:06 +0000
Subject: "marking" DB entries...
Groups: php.db 
Request: Send a blank email to php-db+get-17840@lists.php.net to get a copy of this message
Im making an adressbook using PHP and mySQL. I want each user to have access only to his/hers adressinputs. Now Im wondering how I gonna solve this, ofcourse its very easy just to create a table for each user but then the hole idea of "database" loose its purpose =). How can I "mark" each input so that only the specific user who entered the information can access it? If two users enters the exact same information I want them both to have access to it... I was thinking about a table looking like this: name CHAR(30), adress CHAR(30), email CHAR(30), phonenumber INT(20), authority ENUM() //--------here is my thought---------- I was thinking I could save the users name in "authority" and thereby marking that this entry was made bye the specific person. Is it possible to use this? Please give me a few pointers or better, give me a website where I can read about it... thanks! /Ljungan

« previous php.db (#17840) next »