why, i can tget this query to work?

j4ymff

hi all

this is my site, and this is what i would like to do......

ive got it working on the goalkeepers, but i cant do it on the defenders..
i need to be to display the top 5 scoring.
this is the query i used for the goalkeepers,

$sql = 'SELECT ID,NAME,TEAM,PRICE,POINTS,UPDATE_FLAG FROM dreamteam WHERE 1 AND ID < 43 ORDER BY POINTS DESC LIMIT 5';

http://www.dreamteam.greater-peterborough.com/goalkeepers.php

how do i brake this query to the top 5 scoring?
this query works to what i need, but i need to add another limit but i get an error!!!!!!!

so my defenders are between ID 42 - > 128

$sql = 'SELECT * FROM dreamteam ORDER BY POINTS DESC LIMIT 42,128';

ive tried

$sql = 'SELECT * FROM dreamteam WHERE ID 42,128 ORDER BY POINTS DESC LIMIT 5';

still no joy
please help thanks

jason

Feel free to contact me with any questions
http://www.manninglevels.co.uk/modules.php?name=Feedback

eoghain

Ok first off LIMIT is a command that tells mysql to only send back a specified number of records. So if your query returned 100 results and you added a LIMIT of 5 you'd only get the first 5.

Now to add more, or change the restrictions on your query you need to adjust your WHERE clause.

SELECT * 
  FROM dreamteam
 WHERE ID BETWEEN 42 AND 128
 ORDER BY `POINTS` DESC LIMIT 5;

SELECT * 
  FROM dreamteam
 WHERE ID > 42 
   AND ID < 128
 ORDER BY `POINTS` DESC LIMIT 5;

Also you shouldn't use SELECT * you should always list out all of the columns that you will be using.

j4ymff

thankyou eoghain that worked well