Why won't this php database call work?

Question

I am building a little practice project and I am trying to incorporate pagination of a set of items, so I have limit and offset values that are passed to a function, and those values are set dynamically. I have already checked several times and the values I am trying to pass to the function are correct, but still the function doesn't work. It is hitting the exception block and exiting. Here is the function:

function retrieve_saved_notes_list($userid, $limit, $offset) {
  include("inc/database_connection.php");
  try {
    $sql = "SELECT * FROM notes
            WHERE user_id = ?
            LIMIT = ?
            OFFSET = ?";
    $results = $db->prepare($sql);
    $results->bindParam(1, $userid, PDO::PARAM_INT);
    $results->bindParam(2, $limit, PDO::PARAM_INT);
    $results->bindParam(3, $offset, PDO::PARAM_INT);
    $results->execute();
  } catch (Exception $e) {
    $e->getMessage();
    exit;
  }
  $results = $results->fetchAll();
  return $results;
}

Is there something wrong with this function that I am not seeing?

Answer 1 · 2019-04-08T21:22:25Z

April 8, 2019 9:22pm

Try without the equals sign for limit and offset. "SELECT * FROM notes WHERE user_id = ? LIMIT = 10 OFFSET = 0" isn't valid SQL syntax whereas "SELECT * FROM notes WHERE user_id = ? LIMIT 10 OFFSET 0" is valid.

Welcome to the Treehouse Community

Looking to learn something new?

Michael Cook

Michael Cook

Why won't this php database call work?

Michael Cook

Michael Cook

1 Answer

KRIS NIKOLAISEN

KRIS NIKOLAISEN

Michael Cook

Michael Cook