salve ragazzi ho fatto una funzione che seleziona da tre tabelle gli staff , i dipartimenti assegniati agli staff e la fira , adesso io il controllo del campo obligatorio l ho messo solo al nome, però mi modifica la password ugualmente perche

posto la funzione :
Codice PHP:

function UpdateStaffFromId($staffid,$nome,$cognome,$username,$email,$password,$enabled,$gruppostaff,$mobilenumber,$signature,$assdepart)
{
 global 
$dbcore ;

 
$sql mysql_query("update tech set 
                                     groupid = '
$gruppostaff',
                                     nome = '
$nome',
                                     cognome = '
$cognome',
                                     username = '
$username',
                                     password = '
$password',
                                     email = '
$email',
                                     mobilenumber = '
$mobilenumber',
                                     lastchange = '"
.time()."',
                                     enabled = '
$enabled'
                                     where staffid = "
$staffid ."
                                    "
)or die (mysql_error());
          if(!
$sql)
          {
         
// exit();
          
return false;
          }
          if(!
$staffid)
          {
         
// exit();
          
return false;
          }
              
$query mysql_query("update  techsignatures  set signature = '$signature' where staffid = "$staffid ." ") or die (mysql_error());
          if(!
$query)
          {
         
// exit();
          
return false;
          }
          if(!
$staffid)
          {
         
// exit();
          
return false;
          }
          
$querycontr mysql_query("select * from techassigns where staffid = "$staffid ."")or die(mysql_error());
          
$result mysql_num_rows($querycontr);
          if(
count($result) !=0){
          
$querydel mysql_query("delete from techassigns where staffid = ".$staffid." ")or die(mysql_error());
          if(!
$querydel)
          {
         
// exit();
          
return false;
          }
          }
        if(!
is_array($assdepart))
        {
            
//exit();
            
return false;
        }
        if(
count($assdepart)==0)
        {
        
//exit();
            
return false;
        }
        if(!
$staffid)
        {
        
//exit();
            
return false;
        }
        for(
$i=0$i <count($assdepart); $i++ )
        {
             
$queryas mysql_query("replace into  techassigns (techassignsid ,departid ,staffid )values(null,"$assdepart[$i] .","$staffid .") ")or die(mysql_error());
        }
        if(!
$queryas)
        {
        
//exit();
            
return false;
        }
     return 
true;

e posto la pagina dove c, e l update

Codice PHP:
if(isset($_POST['action'])and ($_POST['action']=='editstaff'))
{
if(!isset(
$_POST['nome'])){$nome='';}else{$nome trim(addslashes($_POST['nome']));}
if(!isset(
$_POST['cognome'])){$cognome='';}else{$cognome trim(addslashes($_POST['cognome']));}
if(!isset(
$_POST['username'])){$username='';}else{$username trim(addslashes($_POST['username']));}
if(!isset(
$_POST['email'])){$email='';}else{$email trim(addslashes($_POST['email']));}
if(!isset(
$_POST['password'])){$password='';}else{$password trim(addslashes($_POST['password']));}
if(!isset(
$_POST['enabled'])){$enabled='';}else{$enabled intval($_POST['enabled'])?1:0;}
if(!isset(
$_POST['gruppostaff'])){$gruppostaff='';}else{$gruppostaff intval($_POST['gruppostaff']);}
if(!isset(
$_POST['mobilenumber'])){$mobilenumber='';}else{$mobilenumber trim(addslashes($_POST['mobilenumber']));}
if(!isset(
$_POST['signature'])){$signature='';}else{$signature trim(addslashes($_POST['signature']));}
if(!isset(
$_POST['assdepart'])){$assdepart='';}else{$assdepart $_POST['assdepart'];}
if(!isset(
$nome) or $nome ==''){
$smarty->assign('messageerrortrue' true);
$smarty->assign('errormessage' 'One of the required field(s) is empty ' );
}
else{


$pass $password;
$password md5($password);




$updatestaff UpdateStaffFromId($staffid,$nome,$cognome,$username,$email,$password,$enabled,$gruppostaff,$mobilenumber,$signature,$assdepart);
if(
$updatestaff)
{
$smarty->assign('messageerrorfalse' true);
$smarty->assign('infomessage' 'Staff [b][/b] inserted successfully' );
}
else{
$smarty->assign('messageerrortrue' true);
$smarty->assign('errormessage' 'errore' );

}



}