WHERE Clause

[Benumbed]

same thing =\

I really dont understand why it doesnt work.

Explain (its in debug mode trying to fix this) of it with $ variable

PHP Code:

Query:

        SELECT setting.*, settinggroup.*
        FROM dwip_module_settinggroup AS settinggroup
        LEFT JOIN dwip_module_setting AS setting USING(grouptitle)
        WHERE settinggroup.module='' 
    
Time before: 0.090831995010376
Time after: 0.091269016265869
Time taken: 0.00043702125549316

table type possible_keys key key_len ref rows Extra 
settinggroup  ALL          3  Using where  
setting  ALL          3 


Explain if I just set it a constant (sitenav)

PHP Code:

Query:

        SELECT setting.*, settinggroup.*
        FROM dwip_module_settinggroup AS settinggroup
        LEFT JOIN dwip_module_setting AS setting USING(grouptitle)
        WHERE settinggroup.module='sitenav' 
    
Time before: 0.12685608863831
Time after: 0.12722706794739
Time taken: 0.00037097930908203

table type possible_keys key key_len ref rows Extra 
settinggroup  ALL          3  Using where  
setting  ALL          3