Does this query look right?

It’s just a simple query but all of my queries are like this and I never noticed it before. There is a ? in place of. the parameter. Is this always been like that?

Yes the query is perfectly fine and ? are correct.

1 Like

Ok, it scared me. Not used to seeing it like that. Why that change? It doesn’t make sense now.

As long as it will still work, I will live with it.

Thanks.

Please check Patricks replies in the topic i linked to, he explains why was this changed.

Yeah, I read the whole thread. I didn’t understand it due to my lack of knowledge. :wink:

It’s confusing as it still has the :P1 etc in the parameters tab. If you have several parameters and you want to try a test value for them in the parameters tab it is impossible to know which parameter goes where.

The question marks ? are parameters, on the database server they get replaced with the submitted values. We use prepared statements on the server to prevent SQL injection.

PHP MySQL Prepared Statements (w3schools.com)

It’s all good. As long as it is suppose to be that way I will adjust. You guys keep freaking me out but I still love you guys. :slight_smile: :beers: