Codeigniter changes the input name!

[eluser]behnampmdg3[/eluser]
Hi;

In my query I have admin.status = 'active' and account.status = 'inctive'

But codeigniter changes to admin_status = 'active' and account_status = 'inctive'


I am keeping index.php in URL if related.

What is the solution?

Thanks

[eluser]jairoh_[/eluser]
i don't understand. can you please elaborate? tnx

[eluser]behnampmdg3[/eluser]
[quote author="jairoh_" date="1370594137"]i don't understand. can you please elaborate? tnx[/quote]Replaces DOT with UNDERSCORE!

[eluser]Rokkitt[/eluser]
Have you tried properly quoting your SQL?

<code>admin.status = ‘active’ and account.status = ‘inctive’</code>

becomes

<code>`admin`.`status` = 'active' and `account`.`status` = 'inctive'</code>

[eluser]behnampmdg3[/eluser]
[quote author="Rokkitt" date="1370611490"]Have you tried properly quoting your SQL?[/quote]What are you talking about????? I use active records. I dont think you make any sense.