SELECT * FROM users WHERE (name AND pass) = ('User' AND 'memer')
SELECT * FROM users WHERE name = 'User' AND pass = 'memer'
(чтобы скобки оставались)SELECT * FROM `users` WHERE `name` = 'User' AND `pass` = 'memer'");
<?php
$us = mysql_fetch_array(mysql_query("SELECT * FROM `users` WHERE `name` = 'имя' && `pass` = 'пас'"));
echo 'Логин: '.$us['name'].' <br> Палоль: '.$us['pass'].';