Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

PHP Using PHP with MySQL Limiting Records in SQL Queries Using LIMIT with Offset

Posted by Zack Yovel
Zack Yovel
8,966 Points

Unclear question

"I have the following statement prepared SELECT * FROM users LIMIT ? . Fill in what I should put in to the last parameter of the bindParam call"

How am I supposed to know what I should put there, I am not even told how many rows are required here.

Nick Davies
Nick Davies
7,972 Points
Nick Davies
Nick Davies
7,972 Points

I agree, this could be worded better.

2 Answers

andrewvernon
PLUS
andrewvernon
Courses Plus Student 9,364 Points
andrewvernon
andrewvernon
Courses Plus Student 9,364 Points

Hi Zack,

Check the last parameter of the bindParam call in the code. It's on both lines this is called around line 86.

Mazen Itani
Mazen Itani
9,134 Points
Mazen Itani
Mazen Itani
9,134 Points

PDO::PARAM_INT