[Solved] error Column count doesn’t match value count at row 1


You have two time $Garment_Type remove one

$query = "Insert Into dbo_dailyline (
        Entry_date
        , Work_Center
        , Shift_Length
        , Number_Sewers
        , Deduct_Hours
        , Garment_Type
        , Other
        , Quantity
        , Notes)
          values ('" . 
            $Entry_Date. "', '" . 
            $Shift_Length . "', '" .
            $Coats . "', '" . 
            $Number_Sewers . "', '" . 
            $Deduct_Hours . "', '" . 
            $Garment_Type . "' , '" . 
            $Other . "', '" . 
            $Quantity . "', '" . 
            $Notes . "')";

3

solved error Column count doesn’t match value count at row 1