Jump to content

Not displaying any results from the database

Go to solution Solved by gizmola,

Recommended Posts

I don't know if I've got the MySQL statement right, when I don't have the LIMIT and OFFSET, it displays all the results, but need the LIMIT for pagination

  name VARCHAR(255),
  date_taken DATE,
  caption VARCHAR(255),
  type VARCHAR(255)

This is in my MySQL statement 

SELECT * FROM photos WHERE LIMIT :limit_page OFFSET :offset

Is the reason for lack of results due to the lack of column names? If so, is there anyway I can display the lot, but only limited to the LIMIT statement?

This is the MySQL version

mysqlnd 8.0.30

Edited by CSS-Regex
Link to comment
Share on other sites

  • Solution
On 2/11/2024 at 4:18 PM, CSS-Regex said:

Don't worry, I found the problem, and it wasn't the MySQL statement

The SQL statement you had was definitely wrong.  LIMIT constrains a result set, and is not a valid part of a WHERE clause.  Whatever you might have fixed, you also must have fixed that issue.

Link to comment
Share on other sites

Aside from the empty WHERE clause mentioned by @gizmola above, you may also have a problem with passing your limit and offset parameters.

You don't show us the relevant connection and execution code, but If your PDO connection code does not set ATTR_EMULATE_PREPARES to false (the default is true) then you cannot pass the limit and offset as parameters in an array when executing. You can, however, pass them using bindParam()

You should always set this attribute to false

  • Like 1
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.