MAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Monday, 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
nam
rom: "Doug 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 wo
rom: "Doug 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
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 smal
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 bib_extract,scanra
