It maybe as simple as changing == to eq



On Jul 21, 2008, at 11:34 AM, Michael Dickens wrote:

Hello all. I live in Pearland and I have been following your group for a while and want to see if you can help me with a problem I am having.

I am retreiving data from mysql using DBI here is the code

while ( ($id, $vote) = $sth->fetchrow_array() ) {
    $vote = "maybe" if vote == "";
    print "$id\t$vote\n";
}

but when I do this, all the vote records retreived are changed to 'maybe' instead of just the ones that match "".
Can I use a conditional statement on the values retreived from mysql?

here is what is in mysql
id | vote
1 | no
2 | NULL
3 | yes


thanks
Michael


_______________________________________________
Houston mailing list
[email protected]
http://mail.pm.org/mailman/listinfo/houston
Website: http://houston.pm.org/

Attachment: smime.p7s
Description: S/MIME cryptographic signature

_______________________________________________
Houston mailing list
[email protected]
http://mail.pm.org/mailman/listinfo/houston
Website: http://houston.pm.org/

Reply via email to