title: retrieving data from the same table for different users
body: <p>I am very new to both programming and database.. I have a common table in mysql accessed by different users,I am using php as the front end,a user can insert ,delete and update information.</p>
  
  <p><strong>For Example:</strong> if i have 3 users A,B and C,User 'A' should be able to see,update or delete only his data which he have inserted, same shud be done for B and C,and there shud be also a super user where he can see,update or delete given by all the users...</p>
  
  <p>how can i achieve this? and also is it possible to generate the primary key automatically with a prefix like if user A inserts data it shud be A1,A2 and for B it shud be B1,B2 etc..</p>