)
- Original Message -
From: ERISEN, Mehmet Kamil <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 28, 2001 10:46 PM
Subject: Re: [PHP] fix my query please
> Hello Jeremy,
> Two things:
> FROM users LEFT OUTER JOIN picks using(id)
> > Where use
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
, August 28, 2001 4:35 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject:Re: [PHP] fix my query please
On Mar 28 Ago 2001 17:29, Jeremy Morano wrote:
> an somebody please fix up my query.
>
>
>
>
> $connection = @mysql_connect("l", "c", &qu
On Mar 28 Ago 2001 17:29, Jeremy Morano 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
4 matches
Mail list logo
