Thompson [EMAIL PROTECTED]
To: George Pitcher [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Wednesday, March 13, 2002 5:59 PM
Subject: Re: Conflicting results using PHP/Mysql
I would guess it's because only three records match the ANDed tests in the
WHERE clause (last 3 lines
Subject: Re: Conflicting results using PHP/Mysql
I would guess it's because only three records match the ANDed tests in the
WHERE clause (last 3 lines).
Isn't that what you intended?
Doug
On Wed, 13 Mar 2002 16:08:43 -, George Pitcher wrote:
Hi all,
Posted this yesterday and got
, March 18, 2002 9:20 PM
Subject: Re: Conflicting results using PHP/Mysql
Your base table is transactions. I assume you want to do a LEFT JOIN.
I think you might see an improvement if transactions were consistently
named on the left side of the equalities as:
$Itemlistquery
Hi all,
Posted this yesterday and got no response. Trying again today.
I'm having a small problem with a biggish query.
The query:
$Itemlistquery= select [a whole load of fields from 3 tables] ending with
;
$Itemlistquery.= transactions.Pdownload ;
$Itemlistquery.= from
I would guess it's because only three records match the ANDed tests in the WHERE
clause (last 3 lines).
Isn't that what you intended?
Doug
On Wed, 13 Mar 2002 16:08:43 -, George Pitcher wrote:
Hi all,
Posted this yesterday and got no response. Trying again today.
I'm having a small