I have a the following query:

function background_audio_file_query($path) {
  $result = db_query("SELECT uri
    FROM `file_managed`
    WHERE `filemime` = 'audio/mpeg'
    LIMIT 1 , 30",

return $result;

How can I pass this to a Drupal variable? I am assuming variable_set() but I am having trouble with the syntax. Could anyone lend a hand?


If you want to set a variable with the URI returned from the query, you just execute code similar to the following one:

variable_set('variable name', $result->uri);

Replace "variable name" with the name you want to give to the Drupal variable, which is the same one you pass to variable_get().

  • In that way, the value name is always 'variable name', not the actual variable name ;) – Chris Burgess Feb 23 '12 at 21:27

Once you have your result, variable_set syntax is simply name, value:

variable_set('background_audio', 'meep.au');

Does that answer your question?

  • In that way, the value is always "meep.au" not the result from the query. – kiamlaluno Feb 22 '12 at 6:54

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.