Member Avatar for garyjohnson

I have a query in php that has an offset in it. I want the offset value to be a variable but I am not sure how to do so. This is my query but it comes up as an error.

$query = "SELECT * 
FROM comments 
WHERE 
    `commenter_username` IN (" . join(',', $list) . ") OR
    `Number` IN (" . join(',', $list) . ") 
ORDER BY `comment_id` DESC
LIMIT 1 OFFSET $offsetNumber";

What is wrong with this?

  • 2 Contributors
  • 1 Reply
  • 181 Views
  • 19 Minutes Discussion Span
  • Latest Post Latest Post by diafol
Member Avatar for diafol

Also:

LIMIT $offset, 1

If you just want the one record. Records start on record 0 ($offset = 0).

commenter_username IN (" . join(',', $list) . ")

You need ' around each list item:

commenter_username IN ('" . implode("','", $list) . "')

Edited by diafol
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.