Home > Archive > PERL Beginners > July 2007 > perl-mysql...
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Rupeshgade@Googlemail.Com 2007-07-25, 6:59 pm |
| 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??
| |
| Andrew Curry 2007-07-25, 6:59 pm |
| You should be able to get your data out using a simple sql query and then
display it accordingly.
-----Original Message-----
From: rupeshgade@googlemail.com [mailto:rupeshgade@googlemail.com]
Sent: 25 July 2007 13:34
To: beginners@perl.org
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: beginners-unsubscribe@perl.org For additional
commands, e-mail: beginners-help@perl.org http://learn.perl.org/
This e-mail is from the PA Group. For more information, see
www.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.
| |
| Prabu Ayyappan 2007-07-25, 6:59 pm |
| Hi Rupesh,
Can you explain your problem scenario a little more briefly. So that it may help in understanding the problem clearly,
For Example,
My input is like
I am expecting this output.
What you tried to achieve your output..
Regards,
Prabu
"rupeshgade@googlemail.com" <rupeshgade@googlemail.com> wrote: 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: beginners-unsubscribe@perl.org
For additional commands, e-mail: beginners-help@perl.org
http://learn.perl.org/
---------------------------------
Get the free Yahoo! toolbar and rest assured with the added security of spyware protection.
| |
| Rupeshgade@Googlemail.Com 2007-07-25, 6:59 pm |
| Hi Prabhu,
I am using the files from the link... http://affymetrix.arabidopsis.info/...sefulfiles.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, andrew.cu...@pa-sport.com (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: rupeshg...@googlemail.com [mailto:rupeshg...@googlemail.com]
> Sent: 25 July 2007 13:34
> To: beginn...@perl.org
> 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: beginners-unsubscr...@perl.org For additional
> commands, e-mail: beginners-h...@perl.orghttp://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.
|
|
|
|
|