jagularen

Thanks guys! I forgot the brackets at the end... $sql_quest = 'SELECT id, username FROM user ORDER BY id ASC LIMIT' . $my_int_value . ',' . ($my_int_value + 30); I'm new here and when I solved this yesterday I was trying to reply to my own last reply to say that I solved it or mark the post as solved. How can I do this?

When I use: $sql = $this->db->prepare($sql_quest); $sql->execute(); I get: Fatal error: Call to a member function execute() on a non-object

Wow! That was quick! Thanks but this results in a syntax error...

Hi, This line of code works just fine for me: $sql_quest = 'SELECT id, username FROM user ORDER BY id ASC LIMIT 0, 30'; I want to be able to set the integer values dynamically and I thought something like this would work: $sql_quest = 'SELECT id, username FROM user ORDER BY id ASC LIMIT' . $my_int_value . ',' . $my_int_value + 30; But it doesn't... Any ideas?