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.
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
Hi All,
Is this syntax is correct??
SELECT username FROM data, password FROM registration WHERE username=%s AND
password=%s"
Best,
Guru.
PS: Want to check the username from a table and the password from another
table.
Is it possible ??
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:
> 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