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 the future, please determine the appropriate list for your questions.
$statement = q{ SELECT * FROM some_table ORDER BY votes DESC LIMIT 1 }; That will get you one row back, the row with the highest votes. -- Jeff "japhy" Pinyan % How can we ever be the sold short or RPI Acacia Brother #734 % the cheated, we who for every service http://www.perlmonks.org/ % have long ago been overpaid? http://princeton.pm.org/ % -- Meister Eckhart -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>