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()`.