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:
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 -
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 <[EMAIL PROTECTED]> 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
SELECT artist_name, album_title FROM album_titles LEFT JOIN artist
USING(aid) WHERE artist_id = aid
-Original Message-
From: Michael Egan [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 17, 2001 8:22 AM
To: [EMAIL PROTECTED]; Cecily Walker Kidd
Subject: [PHP-DB] Re: NEWBIE - Needs Assi