Welcome Guest, Not a member yet? Register   Sign In
[2.1.1] Active Record quotes marks issues
#5

[eluser]Costa Rica SEO[/eluser]
Same here:

Code:
$custom_where = "`menu_item` > 0 AND `subdomain` = '{$this->subdomain}' OR `menu_item` = 1 AND `subdomain` = ''";

$query = $this->db
  ->select('menu_name,url,security,menu_item,ssl_required,menu_class,title')
  ->from('CORE_Pages')
  ->where($custom_where)
  ->order_by('menu_item ASC, order ASC')
  ->get();

Results in:

Code:
SELECT `menu_name`, `url`, `security`, `menu_item`, `ssl_required`, `menu_class`, `title`
FROM (`CI_CORE_Pages`)
WHERE `menu_item` `> 0 AND `subdomain` = 'www' OR `menu_item` = 1 AND `subdomain` = ''`
ORDER BY `menu_item` `ASC`, `order` `ASC`

Notice that both the WHERE and ORDER BY are both broken.


Messages In This Thread
[2.1.1] Active Record quotes marks issues - by El Forum - 06-13-2012, 06:20 AM
[2.1.1] Active Record quotes marks issues - by El Forum - 06-13-2012, 06:53 AM
[2.1.1] Active Record quotes marks issues - by El Forum - 06-13-2012, 12:32 PM
[2.1.1] Active Record quotes marks issues - by El Forum - 06-13-2012, 12:39 PM
[2.1.1] Active Record quotes marks issues - by El Forum - 06-13-2012, 01:28 PM
[2.1.1] Active Record quotes marks issues - by El Forum - 06-13-2012, 01:47 PM
[2.1.1] Active Record quotes marks issues - by El Forum - 06-13-2012, 01:56 PM
[2.1.1] Active Record quotes marks issues - by El Forum - 06-13-2012, 02:32 PM
[2.1.1] Active Record quotes marks issues - by El Forum - 06-13-2012, 04:45 PM
[2.1.1] Active Record quotes marks issues - by El Forum - 06-13-2012, 05:03 PM
[2.1.1] Active Record quotes marks issues - by El Forum - 06-13-2012, 10:03 PM
[2.1.1] Active Record quotes marks issues - by El Forum - 06-14-2012, 05:35 AM
[2.1.1] Active Record quotes marks issues - by El Forum - 06-14-2012, 06:06 AM
[2.1.1] Active Record quotes marks issues - by El Forum - 06-14-2012, 07:02 AM
[2.1.1] Active Record quotes marks issues - by El Forum - 06-14-2012, 07:14 AM
[2.1.1] Active Record quotes marks issues - by El Forum - 06-14-2012, 04:29 PM



Theme © iAndrew 2016 - Forum software by © MyBB