There should -not- be a semicolon at the end of the SQL query when using
mysql_query() through PHP...
http://www.php.net/manual/en/function.mysql-query.php
The problem lies elsewhere.
-----Original Message-----
From: Vera Algoet [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 17, 2001 1:11 PM
To: [EMAIL PROTECTED]; Cecily Walker Kidd
Subject: [PHP-DB] Re: NEWBIE - Needs Assistance with Joins
Cecily,
I'm sure you probably heard from others about your parse error. I know
it looks weird, but you need to have two semicolons, so instead of:
> $CDList =mysql_query(
> "SELECT artist_name, album_title ".
> "FROM artists, album_titles WHERE artist_id = aid");
you would have
$CDList =mysql_query(
"SELECT artist_name, album_title ".
"FROM artists, album_titles WHERE artist_id = aid;");
(Note the semicolon after "aid"). This is because the first one is to
complete the SQL statement, while the one after the parenthisis is to
complete the PHP statement.
Vera
-------------------------------------------------------------------
Madness takes its toll. Please have exact change.
Vera Algoet, Web Developer
Monterey County Office of Education
831-784-4169
--
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]