Re: NEWBIE - Needs Assistance with Joins

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 Kidd wrote: > > 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.