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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
