Re: Is this syntax is correct?
| From: | Niel Archer | Date: | Sun, 05 Sep 2010 15:35:03 +0000 |
| Subject: | Re: Is this syntax is correct? | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-30322@lists.php.net to get a copy of this message | ||
> 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.e. php-db@lists.php.net for database related PHP matters, or an
SQL list/forum for SQL problems.
http://dev.mysql.com/doc/refman/5.1/en/select.html
You seem to be trying to do a JOIN
> Best,
> Guru.
--
Niel Archer