Hello Jeremy,
you are using two tables, but you are not joining them.
What's you goal?
--- Jeremy Morano <[EMAIL PROTECTED]> wrote:
> Hi,
>
> 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
> database.");
>
> $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]
>
=====
Mehmet Erisen
http://www.erisen.com
__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
--
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]