I think yuo need to specify the fields within the tables when you write
out a select query from multiple tables like this.
"SELECT artist_name.*, album_title.* ".
"FROM artists, album_titles WHERE artist_name.artist_id = aid");
Hope this works,
Cecily Walker Kidd wrote:
> 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.
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]