[PHP] fix my query please

[Jeremy Morano]

an somebody please fix up my query.




$connection = @mysql_connect("l", "c", "c") or die("Couldn't connect.");

$db = @mysql_select_db($db_name, $connection) or die("Couldn't select
database.");



$sql = "SELECT distinct users.uid , users.username
        FROM users LEFT OUTER JOIN picks using(id)
        Where  users.uid <> picks.user_id
        ";



$result = @mysql_query($sql,$connection) or die("Couldn't execute query.");


while ($row = mysql_fetch_array($result)) {
        $usersleft = $row['username'];
        $uid = $row['uid'];

        $my_string="$usersleft<br>";

        echo $my_string;
}


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]