Fatal error: Uncaught mysqli_sql_exception: You have an error in your SQL syntax; 채택완료

   $idx = mysqli_real_escape_string($connect, $idx);     $name = mysqli_real_escape_string($connect, $name);   $subject = mysqli_real_escape_string($connect, $subject);    $memo = mysqli_real_escape_string($connect, $memo);  //$pwd = mysqli_real_escape_string($connect, $pwd); 

   // if($idx){  // 수정 

    //    $query = "select * from sing_board where idx='$idx' and pwd=password('$pwd') ";      //   $result = mysqli_query($connect, $query);      //   $data = mysqli_fetch_array($result); 

     //   if(!$data[idx]){        //     echo "       //                         //      ";       //      exit;        //  }         

      //  $query = "update sing_board set name='$name',       //  subject='$subject',       //  memo='$memo'       //  where idx='$idx' ";                 //  mysqli_query($connect, $query); 

  //  }else{ 

       // $regdate = date("Y-m-d H:i:s");          $ip = $_SERVER[REMOTE_ADDR]; 

        $query = "insert into sing_board(name, subject, memo, ip, )             VALUES ('$name','$subject','$memo','$ip' ) ";       echo $query;

    mysqli_query($connect, $query); 

 ?>

안녕하세요 서기님 강의를 듣는중에 에러가 납니다. 어디서 나는지 알 수가 없습니다.

https://www.youtube.com/watch?v=rVzTFsQNOJU&t=195s

Success... Localhost via UNIX socket insert into sing_board(name, subject, memo, ip, ) SELECT ('asva','svasdva','sdvasdvav','59.15.139.219' ) Fatal error: Uncaught mysqli_sql_exception: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') SELECT ('asva','svasdva','sdvasdvav','59.15.139.219' )' at line 1

writePost.php(60): mysqli_query(Object(mysqli), 'insert into sin...') #1 

감사합니다.   query 까지 실행이 잘되비다만 데이터베이스에 저장이 안됩니다. 감사합니다.