Welcome Guest, Not a member yet? Register   Sign In
mysql forbidden field name in WHERE clause ?
#6

[eluser]symbol.software[/eluser]
[quote author="überfuzz" date="1253304517"]Try to echo the variable before and after the query.[/quote]

I have printed everything and works perfect. I am 7 years in PHP development & I have more than just basic understanding of PHP code.

This works:
Code:
$query = $this->db->get_where('users', array('asdfasdf'=>'jon', 'password'=>'password'));

But this is generating the sql wrong:

Code:
$query = $this->db->get_where('users', array('username'=>'jon', 'password'=>'password'));

It works with any string excepting 'username' string.

I am digging into the database library to see what the hell is happening.


Messages In This Thread
mysql forbidden field name in WHERE clause ? - by El Forum - 09-18-2009, 07:07 AM
mysql forbidden field name in WHERE clause ? - by El Forum - 09-18-2009, 08:07 AM
mysql forbidden field name in WHERE clause ? - by El Forum - 09-18-2009, 08:26 AM
mysql forbidden field name in WHERE clause ? - by El Forum - 09-18-2009, 09:07 AM
mysql forbidden field name in WHERE clause ? - by El Forum - 09-18-2009, 09:08 AM
mysql forbidden field name in WHERE clause ? - by El Forum - 09-18-2009, 09:31 AM
mysql forbidden field name in WHERE clause ? - by El Forum - 09-18-2009, 11:10 AM
mysql forbidden field name in WHERE clause ? - by El Forum - 09-18-2009, 11:16 AM
mysql forbidden field name in WHERE clause ? - by El Forum - 09-18-2009, 12:13 PM
mysql forbidden field name in WHERE clause ? - by El Forum - 09-18-2009, 12:38 PM



Theme © iAndrew 2016 - Forum software by © MyBB