Re: NEWBIE - Needs Assistance with Joins

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 PHP code... - Jonathan "Cecily Walker Kidd" <babeephat@hotmail.com> wrote in message news:babeephat-E89BE6.14425016092001@pb1.pair.com... > Hello, > > I have two tables, one that contains an item id, album title name, and > artist ID number. The second table is a list of artists, with an > auto-increment artist ID. > > I want to join the two tables and have them output to a single PHP page. > I was following along with the tutorial at > http://www.webmasterbase.com/article/228/, and tried to modify > it for my > own needs. When I do this, I get a parse error on the line that starts > with SELECT. Here's the code: > > $Link = mysql_connect ($Host, $User, $Password); > > $CDList =mysql_query( > "SELECT artist_name, album_title ". > "FROM artists, album_titles WHERE artist_id = aid"); > > > What am I doing wrong? > > Thanks in advance.