I have another question regarding duplicates and inserting...
if first name last name and phone number do not exist... than insert... if they do exist.. do nothing... here's what i have so far...
$exists = sql::value("Select 1 from event.aps.trainer where first = $first, last = $last, trainer_phone = $trainer_phone");
if (!$exists) sql::safe_insert('event', 'aps', 'trainer', $trainer_hex);
else
{
IGNORE ('event', 'aps', 'trainer', $trainer_hex);
}