RE: Quering Msql database from perl

2005-10-14 Thread Timothy Johnson
Sign up for the dbi-users list. http://dbi.perl.org/support/ -Original Message- From: Jeff 'japhy' Pinyan [mailto:[EMAIL PROTECTED] Sent: Friday, October 14, 2005 12:13 PM To: K.Moeng Cc: beginners@perl.org Subject: Re: Quering Msql database from perl This is an SQ

Re: Quering Msql database from perl

2005-10-14 Thread Jeff 'japhy' Pinyan
On Oct 14, K.Moeng said: $dsn= "dbi:mysql:db_doom:localhost"; So it's a mysql table, not an Msql table. $statement = "select msg from t_main where votes = (this is where Iam stuck) "greater than others" This is an SQL question rather than a Perl question, but I will answer it for you. I

Quering Msql database from perl

2005-10-14 Thread K.Moeng
hello, If i am running perl and i want to qury the Msql Database records how do that from perl. HERE ARE CLUES: DATABASE NAME: DOOM TABLE NAME: T_MAIN RECORDS:VOTE & VOTES RECORD TO QUERY:VOTES PROCEDURE: WHERE A VALUE UNDER VOTE