Re: Re: NEWBIE - Needs Assistance with Joins
| From: | Sheridan Saint-Michel | Date: | Mon, 17 Sep 2001 18:44:12 +0000 |
| Subject: | Re: Re: NEWBIE - Needs Assistance with Joins | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-12511@lists.php.net to get a copy of this message | ||
No, the only time you need a semicolon within the query string is if you are
performing
multiple commands.
ie $query="Set @count=0; Select name,@count=@count+1 as count from people";
Sheridan Saint-Michel
Website Administrator
FoxJet, an ITW Company
www.foxjet.com
----- Original Message -----
From: "Vera Algoet" <valgoet@monterey.k12.ca.us>
To: <php-db@lists.php.net>; "Cecily Walker Kidd" <babeephat@hotmail.com>
Sent: Monday, September 17, 2001 12:10 PM
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
>