Collections functions
General functions
Node functions
Render functions
Theme permission functions
User functions
Resource functions

get_research_request()

Parameters

ColumnTypeDefaultDescription
$ref

Location

include/research_functions.php lines 113 to 127

Definition

 
function get_research_request($ref)
    {
    
$rr_sql="SELECT rr.ref,rr.name,rr.description,rr.deadline,rr.email,rr.contact,rr.finaluse,rr.resource_types,rr.noresources,rr.shape,
                    rr.created,rr.user,rr.assigned_to,rr.status,rr.collection,rr.custom_fields_json,
                    (select u.username from user u where u.ref=rr.user) username, 
                    (select u.username from user u where u.ref=rr.assigned_to) assigned_username from research_request rr where rr.ref=?"
;
    
$rr_parameters=array("i",$ref);

    
$return=ps_query($rr_sql$rr_parameters);
    if (
count($return) == 0)
        {
        return 
false;
        }
    return 
$return[0];
    }

This article was last updated 19th March 2024 10:05 Europe/London time based on the source file dated 26th February 2024 11:00 Europe/London time.