Variable in SQL

[ScottR]

Query with variable not prepared

Hello everyone, I currently use the following query which I execute on form submission. The problem is that it will always result in an error when I'm using a variable. (In this case the value of my search_query input). You'll see the variable below. However, if I leave the variable away and just manually enter for example, my name, it seems to be working. So the issue does not lay with the query. At least, that's what I think. The error I get is bind message supplies 1 parameters, but prep…