[Benumbed]

If I do...

PHP Code:

    $loadedmodulename = $loadedmodule[module];





    $settings = $DB_site->query("
        SELECT setting.*, settinggroup.*
        FROM " . TABLE_PREFIX . "dwip_module_settinggroup AS settinggroup
        LEFT JOIN " . TABLE_PREFIX . "dwip_module_setting AS setting USING(grouptitle)
        WHERE settinggroup.module = $loadedmodulename
    "); 


I get

PHP Code:

Database error in vBulletin 3.0.7:

Invalid SQL: 
        SELECT setting.*, settinggroup.*
        FROM dwip_module_settinggroup AS settinggroup
        LEFT JOIN dwip_module_setting AS setting USING(grouptitle)
        WHERE settinggroup.module = sitenav

    
mysql error: Unknown column 'sitenav' in 'where clause' 


but if I manually put

PHP Code:

WHERE settinggroup.module = 'sitenav' 


it works fine.

Its as though its not passing the variable right or I am calling it wrong within the WHERE. I have tried different ways but cant seem to get it.