:11 PM
To: [EMAIL PROTECTED]; Cecily Walker Kidd
Subject: [PHP-DB] Re: NEWBIE - Needs Assistance with Joins
Cecily,
I'm sure you probably heard from others about your parse error. I know
it looks weird, but you need to have two semicolons, so instead of:
> $CDList =mysql_query(
&
You said you get a parse error - so I'm assuming that is a PHP parse error,
not an SQL error. Can you attach the entire problem file to an e-mail and
send it to me, along with the exact error message? I have a feeling that it
is something to do with the way you are retrieving the results in your P
al Message -
From: "Vera Algoet" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; "Cecily Walker Kidd" <[EMAIL PROTECTED]>
Sent: Monday, September 17, 2001 12:10 PM
Subject: [PHP-DB] Re: NEWBIE - Needs Assistance with Joins
> Cecily,
> I'm sure you pro
You should not need the extra semicolon in there to complete the SQL
statement. All you need is the one at the end.
Vera Algoet <[EMAIL PROTECTED]> said:
> Cecily,
> I'm sure you probably heard from others about your parse error. I know
> it looks weird, but you need to have two semicolons
Cecily,
I'm sure you probably heard from others about your parse error. I know
it looks weird, but you need to have two semicolons, so instead of:
> $CDList =mysql_query(
> "SELECT artist_name, album_title ".
> "FROM artists, album_titles WHERE artist_id = aid");
you would have
$CDList =mysql_q
SELECT artist_name, album_title FROM album_titles LEFT JOIN artist
USING(aid) WHERE artist_id = aid
-Original Message-
From: Michael Egan [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 17, 2001 8:22 AM
To: [EMAIL PROTECTED]; Cecily Walker Kidd
Subject: [PHP-DB] Re: NEWBIE - Needs
Cecily,
I think yuo need to specify the fields within the tables when you write
out a select query from multiple tables like this.
For example:
"SELECT artist_name.*, album_title.* ".
"FROM artists, album_titles WHERE artist_name.artist_id = aid");
Hope this works,
Michael
Cecily Walker