Help for this page

Select Code to Download


  1. or download this
    my $crid = $crm->db->selectrow_array("SELECT idPerson FROM Person WHER
    +E email = ? OR altEmail = ?", undef, $data{'email'}, $data{'email'});
    
    print "ERROR: " . $crm->db->errstr if $crm->db->err;
    
    print "#$data{'email'}# - $crid";
    
  2. or download this
    SELECT idPerson FROM Person WHERE email = 'me@examle.com' OR altEmail 
    += 'me@example.com'
    
     90
    102
    
  3. or download this
    my $query = $crm->db->prepare("SELECT idPerson FROM Person WHERE email
    + = ? OR altEmail = ?");
    $query->execute($data{'email'}, $data{'email'});
    my $crid  = $query->fetchrow_array;
    print "ERROR: " . $crm->db->errstr if $crm->db->err;