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 artist_name, album_title ". "FROM artists, album_titles WHERE artist_id = aid");

you would have $CDList =mysql_query( "SELECT artist_name, album_title ". "FROM artists, album_titles WHERE artist_id = aid;"); (Note the semicolon after "aid"). This is because the first one is to complete the SQL statement, while the one after the parenthisis is to complete the PHP statement. Vera ------------------------------------------------------------------- Madness takes its toll. Please have exact change. Vera Algoet, Web Developer Monterey County Office of Education 831-784-4169