[PHP-DB] Select the specific user data from the database

2010-09-05 Thread nagendra prasad
Hi Experts,

I have a mysql database. What I want is that when a user login he can able
to see his entries only, so that he can delete, add or edit his entries
only. I have 2 different tables one for user details and another for actual
entries. Please help me.

Best,
Guru.


Re: [PHP-DB] Select the specific user data from the database

2010-09-05 Thread Phpster
Then each record needs to have a user filed where their is stored. Then your 
access query just adds an additional filter to check this value

Select * from data_table where user = $user

Bastien

Sent from my iPod

On Sep 5, 2010, at 7:21, nagendra prasad nagendra802...@gmail.com wrote:

 Hi Experts,
 
 I have a mysql database. What I want is that when a user login he can able
 to see his entries only, so that he can delete, add or edit his entries
 only. I have 2 different tables one for user details and another for actual
 entries. Please help me.
 
 Best,
 Guru.

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP-DB] Select the specific user data from the database

2010-09-05 Thread nagendra prasad
PS: Want to check the username from a table and the password from another
table.

Is it possible ??


Re: [PHP-DB] Select the specific user data from the database

2010-09-05 Thread Phpster
I would suggest that you keep authorization separate from data access

Bastien

Sent from my iPod

On Sep 5, 2010, at 9:19, nagendra prasad nagendra802...@gmail.com wrote:

 PS: Want to check the username from a table and the password from another 
 table.
 
 Is it possible ??
 
 

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php