Query returning no results

Hello! I am having a rather difficult time getting query results returned when using a WHERE condition and the database field is an INT. I’m trying to use a session variable which I have changed to both text and number. I’ve tested displaying the session variable in a text field and is displays OK. This is usually a really basic operation and I have been playing with this for hours. I know the query is OK as it is very basic, and returns rows when I remove the WHERE condition… and yes I have even checked to make sure there is a valid result to be returned :slight_smile: … would appreciate any ideas, thanks! Here’s my sql query: SELECT * FROM chapters WHERE bookID =:P1/* {{$_SESSION.currentbookid}} */

Community Page
Last updated: