Kan iemand helpen?

Beste,

Ik heb de volgende querty. Alleen krijg ik een rare error. Wat doe ik fout? En ohja, er zit voor het gemak ook een printscreen van mijn PHPMyAdmin database bij.

Mijn database:
Mijn MySQL querty:

[COLOR= #0000BB]<?php
$args[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"siteurl"[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$row[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$db[/COLOR][COLOR= #007700]->[/COLOR]q[COLOR= #007700]([/COLOR][URL="http://www.php.net/sprintf"]sprintf[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT option_value FROM options WHERE option_name = %s LIMIT 1"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$args[/COLOR][COLOR= #007700]));[/COLOR]
[URL="http://www.php.net/return"]return[/URL] [COLOR= #0000BB]$row[/COLOR][COLOR= #007700];[/COLOR]

De fout die ik krijg:

Unknown column siteurl in where clause

er is geen kolom van siteurl en de kolom is option_name inplaats van siteurl.

Oke, maar wat word de querty dan?

Allard schreef:

Mijn MySQL query:

[COLOR= #0000BB]<?php
$args[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"siteurl"[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$row[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$db[/COLOR][COLOR= #007700]->[/COLOR]q[COLOR= #007700]([/COLOR][URL="http://www.php.net/sprintf"]sprintf[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT option_value FROM options WHERE option_name = %s LIMIT 1"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$args[/COLOR][COLOR= #007700]));[/COLOR]
[URL="http://www.php.net/return"]return[/URL] [COLOR= #0000BB]$row[/COLOR][COLOR= #007700];[/COLOR]

[COLOR= #0000BB]<?php
$args[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"option_value"[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$row[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$db[/COLOR][COLOR= #007700]->[/COLOR]q[COLOR= #007700]([/COLOR][URL="http://www.php.net/sprintf"]sprintf[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT option_value FROM options WHERE option_name = %s LIMIT 1"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$args[/COLOR][COLOR= #007700]));[/COLOR]
[URL="http://www.php.net/return"]return[/URL] [COLOR= #0000BB]$row[/COLOR][COLOR= #007700];[/COLOR]

?
het is overigens query en niet querty

[COLOR= #0000BB]<?php
$args[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"siteurl"[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$row[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$db[/COLOR][COLOR= #007700]->[/COLOR]q[COLOR= #007700]([/COLOR][URL="http://www.php.net/sprintf"]sprintf[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT Option_value FROM options WHERE option_name = $args"[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/return"]return[/URL] [COLOR= #0000BB]$row[/COLOR][COLOR= #007700];[/COLOR] 
?>

Probeer dit eens ?

Propje schreef:

[COLOR= #0000BB]<?php
$args[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"siteurl"[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$row[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$db[/COLOR][COLOR= #007700]->[/COLOR]q[COLOR= #007700]([/COLOR][URL="http://www.php.net/sprintf"]sprintf[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT Option_value FROM options WHERE option_name = $args"[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/return"]return[/URL] [COLOR= #0000BB]$row[/COLOR][COLOR= #007700];[/COLOR] 
?>

Probeer dit eens ?

Waarom Option_value met hoofdletter?
ontopic: wat is precies de bedoeling van het script?

Nee klopt niet. Ik krijg terug Array. Dit is mijn hele functie:

[COLOR= #0000BB]<?php[/COLOR]
[COLOR= #007700]function[/COLOR] get_option[COLOR= #007700]([/COLOR][COLOR= #0000BB]$args[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$default[/COLOR] [COLOR= #007700]=[/COLOR] false[COLOR= #007700]) {[/COLOR]
    [URL="http://www.php.net/global"]global[/URL] [COLOR= #0000BB]$db[/COLOR][COLOR= #007700];[/COLOR]
    
    [COLOR= #0000BB]$args[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/trim"]trim[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$args[/COLOR][COLOR= #007700]);[/COLOR]
    [URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][URL="http://www.php.net/empty"]empty[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$args[/COLOR][COLOR= #007700]))[/COLOR]
        [URL="http://www.php.net/return"]return[/URL] false[COLOR= #007700];[/COLOR]
        
    [COLOR= #FF8000]// Kijken of optie bestaat (Komt later pas...)[/COLOR]
    [COLOR= #0000BB]$exists[/COLOR] [COLOR= #007700]=[/COLOR] true[COLOR= #007700];[/COLOR]
            
    [URL="http://www.php.net/if"]if[/URL] [COLOR= #007700](![/COLOR][URL="http://www.php.net/empty"]empty[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$default[/COLOR][COLOR= #007700]) ||[/COLOR] [COLOR= #0000BB]$exists[/COLOR] [COLOR= #007700]==[/COLOR] true[COLOR= #007700])
    {[/COLOR]
        [COLOR= #0000BB]$row[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$db[/COLOR][COLOR= #007700]->[/COLOR]q[COLOR= #007700]([/COLOR][URL="http://www.php.net/sprintf"]sprintf[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT option_value FROM options WHERE option_name = %s LIMIT 1"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$args[/COLOR][COLOR= #007700]));[/COLOR]
        [URL="http://www.php.net/return"]return[/URL] [COLOR= #0000BB]$row[/COLOR][COLOR= #007700];
    }[/COLOR] [URL="http://www.php.net/else"]else[/URL] [COLOR= #007700]{[/COLOR]
        [COLOR= #0000BB]$default[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/trim"]trim[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$default[/COLOR][COLOR= #007700]);[/COLOR]
        [URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$exists[/COLOR] [COLOR= #007700]==[/COLOR] false[COLOR= #007700])[/COLOR]
            [URL="http://www.php.net/return"]return[/URL] false[COLOR= #007700];[/COLOR]
        [URL="http://www.php.net/else"]else[/URL] 
            [URL="http://www.php.net/return"]return[/URL] [COLOR= #0000BB]$default[/COLOR][COLOR= #007700];
    }

}[/COLOR]