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

[Niel Archer <not@xxxxxxxxxx>]

> 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@xxxxxxxxxxxxx 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



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