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

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. In

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 snip This is an SQL question