+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: Codeigniter changes the input name! (/showthread.php?tid=58374)
Codeigniter changes the input name! - El Forum - 06-07-2013
[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
Codeigniter changes the input name! - El Forum - 06-07-2013
[eluser]jairoh_[/eluser]
i don't understand. can you please elaborate? tnx
Codeigniter changes the input name! - El Forum - 06-07-2013
[eluser]behnampmdg3[/eluser]
[quote author="jairoh_" date="1370594137"]i don't understand. can you please elaborate? tnx[/quote]Replaces DOT with UNDERSCORE!
Codeigniter changes the input name! - El Forum - 06-07-2013
[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>
Codeigniter changes the input name! - El Forum - 06-08-2013
[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.