Not for 'how-to' coding questions but PHP theory instead, this forum is here for those of us who wish to learn about design aspects of programming with PHP.
Ok you devnet people. I need some help here. I'm designing a contactbook application with php and mysql. I'm here just to try and get my thoughts in the correct order.
The user would log in then they would be sent to a page with options like add contact, search contact, and other stuff. The question I have is how would I go about making it to where the contact is only visible by the user only, like a personal book instead of public. I'm new to php and mysql so any thoughts are greatly appricated in advance and later.
Thanks,
Bryan
Last edited by Gimpy on Wed Jun 29, 2005 5:48 pm, edited 1 time in total.
Its just a case of having another column in your table called something like "UID" where you put the primary key of the user's record from the users table (or in a really really bad desgin.... just put the user id... but that's silly).
Then all you do to get personal contacts is select from the table WHERE UID=$uid_of_user type of thing. And the get the public ones... WHERE UID=NULL