Can somebody help me out?
My where clause is completely being ignored.
More specifically the <>. I tried to use != and that didn't work either.
However, when I substitute it with an = , It fuctions correctly.

Right now, the output is all the users.uid and all the users.username from
the table users.
H E L P !

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

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

$sql = "SELECT distinct users.uid , users.username
        FROM users, picks
        WHERE picks.users_uid <> users.uid

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

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

        $option_block .= "<option value=\"$uid\">$username</option>";

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]

Reply via email to