Problems Adding/Modifying a Row

[Andrew]

The following is the code I am having issues with:

PHP Code:

// Process custom fields
$result2 = mysql_query('SELECT * FROM cms_roster_fields');
$nrows = mysql_num_rows($result2);

for ($i = 0; $i < $nrows; $i++)
{
    // Extract custom field content
    $content = $_POST[$i];
    
    // Set default value if field is empty or clean it if it's not empty
    if ($content == "")
    {
        $content = "Not Available";
    } else
    {
        $content = strip_tags(content);
        $content = trim(content);
    }
    
    // See if an entry for this user exists
    $result3 = mysql_query('SELECT * FROM cms_roster_fields_content WHERE UserID = '.$UserID.' AND FieldID ='.$i);
    $nrows2 = mysql_num_rows($result3);
    
    // If an entry exists update it otherwise add a new entry
    if ($nrows2 == FALSE)
    {
        $result4 = mysql_query("INSERT INTO cms_roster_fields_content (UserID,FieldID,Content) VALUES ('$UserID','$i',$content')");
    } else
    {
        $result4 = mysql_query("UPDATE cms_roster_fields_content SET Content=".$content." WHERE UserID=".$UserID." AND FieldID=".$i);
    }
} 

Theoretically it should see what custom fields exist and then see if a given user has an entry for that field. If they do the field is updated otherwise a new row is added for that user. Only problem is this section of the code does nothing - No errors at all it just does nothing. I've rewrote it twice and am to the point where I am clueless as to why it won't work. I'm just learning PHP/MySQL so don't be too hard on my poor coding habits - I know it's prolly a little sloppy. Anyone with a little more experience see anything that would be causing it to not work ?

Anyone - I still haven't been able to find out why this doesn't work :disappointed: