Getting using a LIMIT...

[Jim R]

This code works fine without the LIMIT 5, but it lists all the results.  With the LIMIT

 

$query = 'SELECT * FROM wp_playerRank WHERE year="2011" LIMIT 5 ORDER BY rankClass ASC';
$results = mysql_query($query);
while($line = mysql_fetch_assoc($results)) {

 

 

Here is the error I'm getting:

 

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/jwrbloom/public_html/resources/players/rank2011_top5.php on line 26

 

 

[BlueSkyIS]

LIMIT 5 should be the last part of the SQL

[PFMaBiSmAd]

^^^ And here's the syntax definition that shows that -

SELECT

    [ALL | DISTINCT | DISTINCTROW ]

      [HIGH_PRIORITY]

      [sTRAIGHT_JOIN]

      [sql_SMALL_RESULT] [sql_BIG_RESULT] [sql_BUFFER_RESULT]

      [sql_CACHE | SQL_NO_CACHE] [sql_CALC_FOUND_ROWS]

    select_expr [, select_expr ...]

    [FROM table_references

    [WHERE where_condition]

    [GROUP BY {col_name | expr | position}

      [ASC | DESC], ... [WITH ROLLUP]]

    [HAVING where_condition]

    [ORDER BY {col_name | expr | position}

      [ASC | DESC], ...]

    [LIMIT {[offset,] row_count | row_count OFFSET offset}]

    [PROCEDURE procedure_name(argument_list)]

    [iNTO OUTFILE 'file_name'

        [CHARACTER SET charset_name]

        export_options

      | INTO DUMPFILE 'file_name'

      | INTO var_name [, var_name]]

    [FOR UPDATE | LOCK IN SHARE MODE]]

 

 

[kcmakwana]

$query = 'SELECT * FROM wp_playerRank WHERE year="2011"  ORDER BY rankClass ASC LIMIT 5';

$results = mysql_query($query);

while($line = mysql_fetch_assoc($results)) {

[Jim R]

OK...I put it at the end, and while it eliminated the error, I'm not getting any results now.

 

$query = 'SELECT * FROM wp_playerRank WHERE year="2011" ORDER BY rankClass ASC LIMIT 5';

[BlueSkyIS]

make sure the query runs:

 

$results = mysql_query($query) or die(mysql_error());

 

echo the query and copy/paste into phpmyadmin or other method to test it. remove the limit and test again. etc.

[Jim R]

I've tried it without the limit, and it works fine.  I use that query elsewhere too without the limit.  I just added the limit because I'm reproducing a smaller list on my homepage.