Updating database not working

PHP
1

i have a form with two input job sheet number and status
i want the code to search for the entered job sheet and update entered status

here is sample code

if(isset($_POST['submit'])){ 
    if(isset($_GET['go'])){ 
        if(preg_match("/[A-Z  |  0-9  |  a-z]+/", $_POST['job_number'])){
    
$job_number=$_POST['job_number'];
$state_name=$_POST['state_name'] 

mysqli_query($connect," UPDATE jobsheets SET 'state_name'= [VALUE('$state_name')] WHERE job_number LIKE '%" . $job_number .  "%'") ;

it always gives me syntax error, unexpected ‘mysqli_query’ (T_STRING)

can any body help me, what i am doing wron

2

That line is missing a ; at the end of it

1 Like
3

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.