Re: "marking" DB entries...

well that wasn't very helpful... I have two tables already, users and adressreg.... ??? /ljungan "Rick Emery" <remery@excel.com> skrev i meddelandet news:EAA093B474ABD311A71E00508B5FE08305C2D35E@adntex03.us.excel.com... > store and validate a username and password with each user's info > > -----Original Message----- > From: Ljungan [mailto:jens.ljungcrantz@telia.com] > Sent: Friday, March 22, 2002 11:07 AM > To: php-db@lists.php.net > Subject: [PHP-DB] "marking" DB entries... > > > 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 > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php