----- Original Message -----
From: Cecily Walker Kidd <[EMAIL PROTECTED]>
Sent: Monday, September 17, 2001 5:42 AM
Subject: [PHP-DB] NEWBIE - Needs Assistance with Joins

> 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.


$CDList = mysql_query("SELECT artist_name, album_title
                         FROM artists, album_titles
                        WHERE artist_id = 'aid'"

Jason Wong
Gremlins Associates
Tel: +852-2573-5033
Fax: +852-2573-5851

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]

Reply via email to