Select data from table where date = today

Hi,

First off I must start on the fact you have critical security problems with your code. If you are using similar queries in your application you have giving everyone a master key. They have access to all your data in the database.

You should use the query bindings if you don't use the Query Builder.
https://codeigniter.com/user_guide/datab...y-bindings
https://codeigniter.com/user_guide/datab...cting-data

And for the date part, I think the problem are that you need to have quotes around the date string.

You can use last_query to see what it's actually generating, and run it directly inside the database.
https://codeigniter.com/user_guide/datab...last_query