RE: [PHP-DB] Re: NEWBIE - Needs Assistance with Joins

2001-09-17 Thread Rick Emery
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

Re: [PHP-DB] Re: NEWBIE - Needs Assistance with Joins

2001-09-17 Thread biorn
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, so

Re: [PHP-DB] Re: NEWBIE - Needs Assistance with Joins

2001-09-17 Thread Sheridan Saint-Michel
- 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 probably heard from others about your parse error. I know it looks weird

RE: [PHP-DB] Re: NEWBIE - Needs Assistance with Joins

2001-09-17 Thread Matthew Loff
: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( SELECT