hi every one, am having a bit of an issue in my already exist profile page.
The thing is if a user checks his/her profile page to reedit their profile and click save the already exist code will kick in not allowing the user to save and showing the already exist error msg for the email instead of just ignoring and should only work if the user tries to change his/her email to another email that already exist to show the error hope u understand below is the code i wrote up funny thing the code works in a weird way if i try inserting the 1st email in the column that isnt mine i get already exist but if i try others it get updated

 $query = "SELECT email FROM " . $DBPrefix . "users WHERE id = id IN (SELECT id FROM " . $DBPrefix . "users     
            
            WHERE email = :email)";
            $params = array();
            $params[] = array(':email', $system->cleanvars($_POST['TPL_email']), 'str');
            $db->query($query, $params);
            if ($db->numrows() > 0)
            {
                $ERR = $ERR_115; // E-mail already used
            }

THANKS

Are you trying to submit a form, but don't want to update the unfilled or untouched part?

Enclose your codes in (I assume you are sending through POST):

if(isset($_POST['email_name'])){
//your code to store it in DB
} else {
//do nothing
}

mokoshalb:
Are you trying to submit a form, but don't want to update the unfilled or untouched part?

Enclose your codes in (I assume you are sending through POST):

if(isset($_POST['email_name'])){
//your code to store it in DB
} else {
//do nothing
}

Hi, can you help work on a phpbb site

SirLakes:


Hi, can you help work on a phpbb site

modifications or installation.

mokoshalb:
modifications or installation.

Need to add some features