Re: Re: NEWBIE - Needs Assistance with Joins
| From: | biorn at ebmstpa dot com | Date: | Mon, 17 Sep 2001 18:40:22 +0000 |
| Subject: | Re: Re: NEWBIE - Needs Assistance with Joins | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-12509@lists.php.net to get a copy of this message | ||
You should not need the extra semicolon in there to complete the SQL
statement. All you need is the one at the end.
Vera Algoet <valgoet@monterey.k12.ca.us> said:
> 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
>
--