----- Original Message -----
From: Cecily Walker Kidd <[EMAIL PROTECTED]>
To: <[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.
Try:
--------------------------------------------------------
$CDList = mysql_query("SELECT artist_name, album_title
FROM artists, album_titles
WHERE artist_id = 'aid'"
);
--------------------------------------------------------
hth
--
Jason Wong
Gremlins Associates
www.gremlins.com.hk
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]
