Re: syntax error help
| From: | Richard Lynch | Date: | Mon, 21 Aug 2006 16:53:50 +0000 |
| Subject: | Re: syntax error help | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-240957@lists.php.net to get a copy of this message | ||
Older version of MySQL does not support subselects.
On Sun, August 20, 2006 5:18 am, Bigmark wrote:
> Can anyone tell me why this works on my localhost but gets an error on
> my
> server:
>
> <?php
> $sql = "SELECT COUNT(*) FROM leaderboard WHERE points >=( SELECT
> points FROM
> leaderboard WHERE username= '$username' )";
> $result = mysql_query( $sql ) or die ( mysql_error() );
> $rank = mysql_result( $result, 0 );
> echo $rank;
> ?>
>
>
> this is the error message but i cant figure it out:
>
> Your Position 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
> 'SELECT points FROM leaderboard WHERE username= 'ainslie' )' at
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
Like Music?
http://l-i-e.com/artists.htm