typomaniac - 7:24 pm on Jul 2, 2012 (gmt 0)

Not sure exactly what the problem is here but I'm unable to delete a row in a mysql table.
The query is:
my $sth=$dbh->prepare("delete from table WHERE where column='$_[0]'");
Table & column name changed for posting purposes but the value compared against column is what it should be. One thing I'm curious about is the Collation setting. It is
currently set to latin1_swedish_ci .A meta tag in the form is calling for charset=UTF-8. The reason for this is a javascript which encrypts passwords before sending them through the net. I see in phpadmin where charsets can be set per column, etc., and I tried different settings for the UTF-8 but still the delete isn't happening. The column which holds the passwords and also is not the one being matched for deletion. ?