Hello Jeremy,
Two things:
FROM users LEFT OUTER JOIN picks using(id)
> Where users.uid <> picks.user_id
1- when you do OUTER join, you do NOT have to use the <>.
That's what outher join means.
2- what is id? Is it a column? shouldn't it be uid?
Maybe that's your problem.
--- Jeremy Morano <[EMAIL PROTECTED]> wrote:
> 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]
>
=====
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]
