problem in update data

[msafvati]

hi

when i use from UPDATE (sql) in my script,compiler show a warning for me

please guid me to corrrect this problem thank u

 

edu is PK

 

$new_Edu=$_GET['txt1']; 
$new_Back=$_GET['txt2'];
$new_Otherskiils=$_GET['txt3'];
$new_Age=$_GET['txt4'];
$new_Tell=$_GET['txt5'];
  
  $SqlUpdate="UPDATE tblReguser SET (Edu = '$new_Edu', Background = '$new_Back' , Otherskills = '$new_Otherskiils' , Age = '$new_Age' , Tell = '$new_Tell')";
$connectionstring=odbc_connect("user","","");
$resultup=odbc_do($connectionstring,$Sqlupdate);
    if ($SqlUpdate==1)
          echo "Record successfully updated!";
odbc_close($connectionstring); 
?>

 

and warning is :

 

Warning: odbc_do() [function.odbc-do]: SQL error: [Microsoft][ODBC Microsoft Access Driver]Invalid use of null pointer , SQL state S1009 in SQLExecDirect in D:\MAS\Prj2\Local path\MASUdate\Update.php on line 250

 

[tinker]

Not that this is your error, but which is line 250?

 

You have:

$resultup=odbc_do($connectionstring,$Sqlupdate);
    if ($SqlUpdate==1)

should be:

$resultup=odbc_do($connectionstring,$Sqlupdate);
    if ($resultup==1)

[msafvati]

thank

i change

 if ($resultup==1)

but so i have same problem..

line 250 is :

$resultup=odbc_do($connectionstring,$Sqlupdate);