Simple perl mysql query not working

Question

I've been out of the mysql and perl game for quite a few years and can't seem to get this right. I have a table with just 3 columns. 'cnt' is one of them. All I want to do is query the table on 'name' and see if name exists. If it does, I want to capture the value of 'cnt'. The table has a record of testName with a value of 2 I added manually. When this script is run it returns empty.

my $count;
my $pop = qq(SELECT cnt FROM popular WHERE name="testName"); 
my $sth = $dbh->prepare($pop); 
$sth->execute() or die $dbh->errstr; 

my @return; 

while (@return = $sth->fetchrow_array()) { 
   $count = $return[1]; 
} 

print "our return count is $count";

Is it obvious to anyone what I did wrong?

does "returns empty" mean it doesn't even print out "our return count is"? — ysth
– ysth, Commented Nov 22, 2013 at 3:16
It prints out the string but it stops after "is". $count doesn't contain anything. — Aaron Anderson
– Aaron Anderson, Commented Nov 22, 2013 at 3:20

ysth · Accepted Answer · 2013-11-22 03:24:00Z

3

You probably mean

$count = $return[0];

answered Nov 22, 2013 at 3:24

ysth

99.1k6 gold badges126 silver badges219 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

wuchang · Accepted Answer · 2013-11-22 07:28:29Z

0

According to perl doc on mysql

An alternative to fetchrow_arrayref. Fetches the next row of data and returns it as a list containing the field values. Since you select cnt as the return value ,so , the size of @return is 1,but you misunderstand it as the number of results which meets your query condition.No, it is not so!Please have a more careful reading of perl doc.

answered Nov 22, 2013 at 7:28

wuchang

3,0799 gold badges45 silver badges71 bronze badges

Collectives™ on Stack Overflow

Simple perl mysql query not working

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related