Hi Prabhu, I am using the files from the link... http://affymetrix.arabidopsis.info/narrays/help/usefulfiles.html
i have put the first 2 files in the MySQL database and the third file is a 500 MB files dealing with the calculation of r-value... The principle is the smaller the r-value between the 2 probes ,the closer it is to the target probe...So i have put the r-value in the descending order on the browser. i just want to add the GeneID and Description of the second probe to each row on the browser. Rupesh. On Jul 25, 3:45 pm, [EMAIL PROTECTED] (Andrew Curry) wrote: > You should be able to get your data out using a simple sql query and then > display it accordingly.-----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: 25 July 2007 13:34 > To: [EMAIL PROTECTED] > Subject: perl-mysql... > > Hi All, > I have this problem of appending data from MySQL database to the > output html page on the browser. > > The output on the browser in the html format looks like this : > > Probe1 Probe2 r-value p-value > e-value > 1234 4567 1.373 0.0e > +1 0.0e+ > 1234 3274 0.468 > 0.1e-1 0.1e-1 > > Probe1 is the submitted probe and is the submitted probe so it will stay the > same...neways the problem > > i have this database having columns GeneID ,Strand, Domain and > Description .now what i want to do is append GeneID and Description to the > above output such that the GeneID and Description should fit that for > Probe2.The problem is compounded by the fact that the output is according > to the r-value in descending order . > > The output i would like to have is : > > Probe1 Probe2 r-value p-value e- > value GeneID(as of Probe2) Description(as of Probe2) > > i have been able to connect to the Mysql database via perl ...what to do > next?? > > -- > To unsubscribe, e-mail: [EMAIL PROTECTED] For additional > commands, e-mail: [EMAIL PROTECTED]://learn.perl.org/ > > This e-mail is from the PA Group. For more information, > seewww.thepagroup.com. > > This e-mail may contain confidential information. Only the addressee is > permitted to read, copy, distribute or otherwise use this email or any > attachments. If you have received it in error, please contact the sender > immediately. Any opinion expressed in this e-mail is personal to the sender > and may not reflect the opinion of the PA Group. > > Any e-mail reply to this address may be subject to interception or > monitoring for operational reasons or for lawful business practices. -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] http://learn.perl.org/
