Hi All,
i am in the middle of my project and i have already got a browser output.
When i submit a probeID (ProbeID1 here)query it matches all the other probeID(ProbeID2 here) in the file.The output looks like this...
<pre>
ProbeID1 ProbeID2 r-value p-value e-value
244901_at 244901_at 0.2463 0.0e-1 0.0e-1
244901_at 244902_at 0.2374 0.0e-1 0.1e-1
244901_at 244903_at 0.2360 0.1e-2 0.2e-1
</pre>
and blah blah blah.......The answer is according to the r-values in descending order.
The output i would like to have on the browser would be like this
ProbeID1 ProbeID2 r-value p-value e-value GeneID Description
244901_at 244901_at 0.2463 0.0e-1 0.0e-1
244901_at 244902_at 0.2374 0.0e-1 0.1e-1
244901_at 244903_at 0.2360 0.1e-2 0.2e-1
The problem is i have to call the GeneID and Description from the mysql database and append to this output..The tables in question are ProbeGene and geneInfo
where ProbeGene contains columns GeneID and ProbeID and geneInfo contains columns GeneID,length,Strand,Description.
The GeneID and description would be that for the ProbeID2 .I have already connected to the MySQL database but stuck at this point.i hope i am clear in what i have said...guess i need some help.