Re: Is this syntax is correct?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



SELECT d.username,  r.password FROM data join  registration r on r.username
= d.username WHERE r.username  like '%s' AND
r.password like '%s'"

Presuming the password stored as clear text and username is common field

SELECT d.username,  r.password FROM data join  registration r on r.username
= d.username WHERE r.username  like '%s' AND
r.password like '%s'"

or

SELECT d.username FROM data as d, registration as r WHERE r.username  like
'%s' AND
and r.password like '%s'"
and r.username = d.username
============
regds
amit

"The difference between fiction and reality? Fiction has to make sense."


On Sun, Sep 5, 2010 at 6:48 PM, nagendra prasad <nagendra802000@xxxxxxxxx>wrote:

> Hi All,
>
> Is this syntax is correct??
>
> SELECT username FROM data, password FROM registration WHERE username=%s AND
> password=%s"
>
>
> Best,
> Guru.
>

[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux