[PHP-WIN] 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.

[PHP-WIN] 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 wrote: > Hi Experts, > > I have a mysql

[PHP-WIN] Is this syntax is correct?

2010-09-05 Thread nagendra prasad
Hi All, Is this syntax is correct?? SELECT username FROM data, password FROM registration WHERE username=%s AND password=%s" Best, Guru.

[PHP-WIN] 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 ??

[PHP-WIN] 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 wrote: > PS: Want to check the username from a table and the password from another > table. > > Is it possible ?? > > -- PHP Windows Mailing List (http:

[PHP-WIN] Re: [PHP-DB] Is this syntax is correct?

2010-09-05 Thread Niel Archer
> Hi All, > > Is this syntax is correct?? > > SELECT username FROM data, password FROM registration WHERE username=%s AND > password=%s" No, it is not. This list is for Windows based PHP matters. You will find far more knowledgeable people (so more responses) by asking on the appropriate list, i