hey im looking for a way to encrypt credit card numbers stored in a mysql database.
i can encrypt them symmetrically, but if someone had ftp access, they could simply view my code and find the key that was used to encrypt the credit card numbers before they are entered in the database.
is there a way to encrypt data using one key, but only decrypt it using another key?