for that you need to create a php if statement that evaluates the value being stored in the database.
<?php if($row_RecordsetName['SubscribeColumn'] == "<subscribe value>") { ?>
You are subscribed
<?php } else { ?>
you are not subscribed
<?php } ?>
Note, this is sample code. Substitute "RecordsetName", "SubscribeColumn" and "<subscribe value>" with the correct name for your recordset, the subscribe column and the subscribe value.