Re: syntax error help
| From: | Paul Scott | Date: | Sun, 20 Aug 2006 10:44:35 +0000 |
| Subject: | Re: syntax error help | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-240916@lists.php.net to get a copy of this message | ||
On Sun, 2006-08-20 at 18:18 +0800, Bigmark wrote:
> Can anyone tell me why this works on my localhost but gets an error on my
> server:
>
Try quote your identifiers.
SELECT COUNT(*) FROM
leaderboard WHERE points >=( SELECT
points
FROM
leaderboard WHERE username = '$username' );
--Paul