On 11-Jun-01 Dawn H wrote:
>>Ahh. 'it doesn't work.'
>>As in: it returns a error ? or doesn't display you what you want ?
>
> Both. I've fiddled with it doing this and that and haven't been able to get
> it to display correctly.
>
do the cut-n-paste thingy & get your query correct first; sweat
>Ahh. 'it doesn't work.'
>As in: it returns a error ? or doesn't display you what you want ?
Both. I've fiddled with it doing this and that and haven't been able to get
it to display correctly.
>> BEGIN QUOTE-
>> $sth=$dbh->prepare ("SELECT listing.id, pictures.thumb_1,
description
On 10-Jun-01 Dawn H wrote:
> Here's what I currently have that doesn't work:
>
Ahh. 'it doesn't work.'
As in: it returns a error ? or doesn't display you what you want ?
> BEGIN QUOTE-
> $sth=$dbh->prepare ("SELECT listing.id, pictures.thumb_1,
description.mls,
> listing.p_city,
enough. I'm a beginner
at MySQL (and related stuff) so your suggestion of ODBC went totally over my
head ;-) Thanks!
=Dawn
-Original Message-
From: Ed Carp [mailto:[EMAIL PROTECTED]]
Sent: Sunday, June 10, 2001 5:32 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Using more t
Dawn H ([EMAIL PROTECTED]) writes:
> I have four tables, and I want to use bits of each one to display a list on
> one page. I tried listing what I wanted out of each, but it seems that if
> any one of the fields chosen is null, the whole row with that ID# is left
> out. I thought perhaps a LEFT
I have four tables, and I want to use bits of each one to display a list on
one page. I tried listing what I wanted out of each, but it seems that if
any one of the fields chosen is null, the whole row with that ID# is left
out. I thought perhaps a LEFT JOIN but don't know how to make that work o
