Followup on extracting information from a text field and inserting it into another field

Hi All,

I don’t know who is still subscribed to post # 79134 http://www.interactivetools.com/forum/forum-posts.php?extracting-an-email-address-from-a-text-field-79134 so I decided to re-post a followup question.

THEN
In that post, I was extracting an email address from a text field and inserting it into an email field if the email field was blank.

NOW
I’m now trying to locate the word “free” in that text field, and if it exists, insert the option value “2" into a list field called "membership_level".

The basic concept seems to be working (too well).

THE ISSUE
My problem is that the code below inserts the option value “2" in all blank membership_level fields and I only want it to insert a "2" in the memberhip_level field if the membership field is currently blank AND the target word $myword exists in internal_notes.

I tried to include the parameter || $allLevel == '' in the if statement, but that didn’t seem to do the job.

I hope someone can see my error.

Thanks,

Jerry Kornbluth

 <?php
function extract_membership_level_from($string){
    $myword = 'free' ;
    preg_match_all("/\b" . $myword . "\b/i", $string, $matches);
    return $matches[0];
}
    ?>
      
  <?php
  foreach ($accountsRecords as $record) {
    $allLevel  = extract_membership_level_from( $record['internal_notes'] );
    if ($record['membership_level'] || @$allLevel == '' ) { continue; } // skip records that already have a membership level set (or where there’s no match for $myword in internal_notes )
    $firstLevel = '2';
    print "User {$record['username']} will get this level: $firstLevel<br/>\n";
   mysql_update('accounts', $record['num'], null, array('membership_level' => $firstLevel ));
 }
?>