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
)
- 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 users.uid picks.user_id
1- when you do
, 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, c) or die(Couldn't connect.);
$db = @mysql_select_db
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 , users.username
4 matches
Mail list logo