Need help with active record

[eluser]theshiftexchange[/eluser]
Ok - now try and add a new record called "testinserttest"

Now run

Code:

$query=$this->db->query(“select * from UserTable where Username like ‘%insert%’”);

Does that work?

No? Then the issue is with the word "insert". You might need to double escape it or something so MYSQL knows it is a text field, not a command.

Yes? Then the issue is because you are looking for a wildcard on the left, but there is no text to the left. i.e.

Code:

$query=$this->db->query(“select * from UserTable where Username like ‘%insert%’”);  

vs

$query=$this->db->query(“select * from UserTable where Username like ‘insert%’”);