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" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]...
> 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.
--
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]
