Re: Why this doesn't work ?
| From: | Phillip Oertel | Date: | Mon, 24 Oct 2005 17:51:45 +0000 |
| Subject: | Re: Why this doesn't work ? | ||
| References: | 1 2 3 4 5 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-224572@lists.php.net to get a copy of this message | ||
ah!
remove the whitespace between the COUNT and () : COUNT(login) instead of
COUNT () ...
> Hi,
>
>> Make this line instead
>> $result = mysql_query($query) or die(mysql_error() . " with the query
>> $query";
>> and you'll likely see the error.
>
>
> Here it goes:
>
> "You have an error in your SQL syntax; check the manual that corresponds
> to your MySQL server version for the right syntax to use near '(login)
> FROM formacao WHERE login = 'a'' at line 1"
>
> Regards,
> Mário Gamito