MySQL and PHP - how to display only the first five rows?

Question

I have a database that I am successfully querying to display all rows where the value of one field equals x. What I need to do now is ONLY display the first 5 records that meet that criteria.

Here is my sql query so far:

$result = mysql_query("SELECT Player, Team, Pass_Yds, Pass_TDs, Int_Thrown, Rush_Yds, Rush_TDs, Overall_Pts, Total_Fantasy_Pts FROM ff_projections WHERE Position = 'QB' ORDER BY Pass_Yds DESC;");

I tried adding LIMIT 0,5 to the query (after DESC but before the ';') but then it wouldn't display anything at all.

Seems like adding limit should work. What happens if you add limit and run the query directly against the server? — Eric Petroelje
– Eric Petroelje, Commented May 30, 2012 at 13:23
This should work SELECT Player, Team, Pass_Yds, Pass_TDs, Int_Thrown, Rush_Yds, Rush_TDs, Overall_Pts, Total_Fantasy_Pts FROM ff_projections WHERE Position = 'QB' ORDER BY Pass_Yds DESC LIMIT 5;, run this query in phpadmin and check results — rs.
– rs., Commented May 30, 2012 at 13:24

Marcus Adams · Accepted Answer · 2012-05-30 16:07:21Z

3

Most likely, you accidentally put in a period:

LIMIT 0.5

which amounts to:

LIMIT 0,0

or

LIMIT 0

Try putting in a comma instead like

LIMIT 0,5

or simply

LIMIT 5

edited May 30, 2012 at 16:07

answered May 30, 2012 at 14:40

Marcus Adams

54k9 gold badges98 silver badges146 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Pramod Kumar Sharma · Accepted Answer · 2012-05-30 14:55:07Z

0

You can use this $result = mysql_query("SELECT Player, Team, Pass_Yds, Pass_TDs, Int_Thrown, Rush_Yds, Rush_TDs, Overall_Pts, Total_Fantasy_Pts FROM ff_projections WHERE Position = 'QB' ORDER BY Pass_Yds DESC LIMIT 0,5");

answered May 30, 2012 at 14:55

Pramod Kumar Sharma

8,0325 gold badges30 silver badges53 bronze badges

Collectives™ on Stack Overflow

MySQL and PHP - how to display only the first five rows?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related