I'd like to check if a record exists, if it doesn't, then add it. If it does, don't do anything. I found the 'insert ignore' command and tried it with this code.
$query = $qry_contact_church_owner->prepare('INSERT IGNORE INTO contact_church_owner (
$query->bindParam(':al_username', $al_username, PDO::PARAM_INT);
When I run the code, the record is inserted even though there is already a record in the table.
Any ideas on a fix are greatly appreciated.