response_id,participant_id,question_id,answer_option_answer_text vs
(response_id,participant_id,question_id,answer_option)
and your line ” $participant_id=$_POST[‘participant_id’]
” is missing its semicolon (;)
also please use
if( !mysql_query( $query, $con ) ) {
echo("Failure: " . mysql_error() );
}
to insert data.
2
solved Data inserting in mysql data base not working [closed]