RE: [PHP-GENERAL] SQL-HELL! How select-query with query for UID / PWD
| From: | Liz Kimber | Date: | Wed, 24 May 2000 10:50:40 +0000 |
| Subject: | RE: [PHP-GENERAL] SQL-HELL! How select-query with query for UID / PWD | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-425@lists.php.net to get a copy of this message | ||
> $result = mysqlquery("quarti","SELECT * FROM product WHERE
> username.users=$uname, password.users=$pword)
>
> What is wrong with the above sql (or what isn´t)?
First problem is you are trying to select details not from the given table,
you have said from table product, not from table users.
Try using select * from users where username=$uname and password=$pword
Liz