SELECT DISTINCT 
a.PRODUCTID 
FROM mytable AS a
INNER JOIN mytable AS b ON a.PRODUCTID=b.PRODUCTID
WHERE a.TAGID=59
AND b.TAGID=61
;


MSSQL Select with "vertical"-where
Im trying to create a login section on my website using PDO.

So far I've the following...

config.php
    

    // Connect to DB
    $username = 'user@site.co.uk';
    $password = 'pass';

    try {
        $conn = new PDO('mysql:host=localhost;dbname=db', $username, $password);    
        $conn-&gt;setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
        } 
    catch(PDOException $e) {
        echo 'ERROR: ' . $e-&gt;getMessage();
        }

?&gt;


header.php 
    

// DB Config
include '/assets/config.php';

// User Session
$login = 'liam';
$pass = 'password';

$sth = $conn-&gt;prepare("SELECT * FROM access_users WHERE login = ? AND pass = ?");
$sth-&gt;bindParam(1, $login);
$sth-&gt;bindParam(2, $pass);
$sth-&gt;execute();

if ($sth-&gt;rowCount() &gt; 0)
{
  // session stuff,
 // refresh page
}  

?&gt;


My browser doesn't display the page however, and when I view my source theres no data contained within, can anybody see where im going wrong? 
