Using method.sql from the XML-RPC service

<?php
require_once "XML/RPC.php";
require_once "slides/mdb/scripts/xmlrpc_util.php";
require_once "slides/mdb/scripts/mdb_tests.cfg";
?>
<b>method.sql:</b> 
<small>"select source_id,expdata,rev_date,resolution,description 
from protein limit 10"</small><br>
<?php
$method = "method.sql";
$query = "select source_id,expdata,resolution,description ";
$query .= "from protein where expdata like '%x-ray%' and ";
$query .= "resolution >= 0.7 order by resolution limit 5";
$q = new XML_RPC_Value($query, $GLOBALS['XML_RPC_String']);
$msg = new XML_RPC_Message($method,array($q));

$c=new XML_RPC_Client(XMLRPC_URI, MDB_SERVER_NAME, MDB_SERVER_PORT);
$r = $c->send($msg);
if (!$r->faultCode()) {
 echo toTable(XML_RPC_decode($r->value()));
} else {
 echo "<pre>\n";
 echo "ERROR: ".$r->faultCode()." -- ".$r->faultString();
 echo "</pre>\n";
}

?>
Output
method.sql: "select source_id,expdata,rev_date,resolution,description from protein limit 10"
source_id expdata resolution description
1d8g x-ray diffraction 0.74 Header: [deoxyribonucleic acid 23-oct-99 1d8g] Title: [ultrahigh resolution crystal structure of b-dna decamer d(ccagtactgg)] Compound: [mol_id: 1; molecule: 5'-d(*cp*cp*ap*gp*tp*ap*cp*tp*gp*gp*)-3'; chain: a; engineered: yes] Source: [mol_id: 1; synthetic: yes] Keywords: [calcium, alternate conformation, ultrahigh resolution, trp repressor, polyamide]
1gci x-ray diffraction 0.78 Header: [serine protease 02-sep-98 1gci] Title: [the 0.78 angstroms structure of a serine protease - bacillus lentus subtilisin] Compound: [mol_id: 1; molecule: subtilisin; chain: null; ec: 3.4.21.62; engineered: yes; biological_unit: monomer] Source: [mol_id: 1; organism_scientific: bacillus lentus; expression_system: bacillus subtilis] Keywords: [bacillus lentus, hydrolase, serine protease, ultra-high resolution]
1iua x-ray diffraction 0.80 Header: [electron transport 01-mar-02 1iua] Title: [ultra-high resolution structure of hipip from thermochromatium tepidum] Compound: [mol_id: 1; molecule: high-potential iron-sulfur protein; chain: a] Source: [mol_id: 1; organism_scientific: thermochromatium tepidum; organism_common: bacteria] Keywords: [ultra-high resolution, crystal structure]
1dpl x-ray diffraction 0.83 Header: [deoxyribonucleic acid 27-dec-99 1dpl] Title: [a-dna decamer gcgta(t23)tacgc with incorporated 2'-methoxy- 3'-methylenephosphate-thymidine] Compound: [mol_id: 1; molecule: 5'-d(*gp*cp*gp*tp*ap*(t23)p*ap*cp*gp*c)-3'; chain: a, b; engineered: yes] Source: [mol_id: 1; synthetic: yes] Keywords: [deoxyribonucleic acid]
1m40 x-ray diffraction 0.85 Header: [hydrolase 01-jul-02 1m40] Title: [ultra high resolution crystal structure of tem-1] Compound: [mol_id: 1; molecule: beta-lactamase tem; chain: a; synonym: tem-1; ec: 3.5.2.6; engineered: yes; mutation: yes] Source: [mol_id: 1; organism_scientific: escherichia coli; organism_common: bacteria; gene: bla; expression_system: escherichia coli; expression_system_common: bacteria; expression_system_strain: sf120; expression_system_vector_type: plasmid; expression_system_plasmid: palter ex ii - tem-1] Keywords: [acylation mechanism, x-ray structure, ultra- high resolution]