title: Unknown column 'valueToPass' in 'field list' MySQL Error # :1054
body: <p>I have written a stored procedure in mysql to update. That is working fine, when you execute it in the mysql command line(through Mysql editor). </p>
  
  <p>Stored procedure is:</p>
  
  <pre><code>CREATE DEFINER=`root`@`localhost` PROCEDURE `Deduction_Of_PL`(
      IN P_EMPID VARCHAR(1000)
  )
  BEGIN
    DECLARE PresentYearPL VARCHAR(1000);
  
    set PresentYearPL=(select Present_Year_PL from leave_calculate_pl where employee_id=P_EMPID);
  
    IF(PresentYearPL&lt;=0) THEN
      UPDATE leave_calculate_pl
      SET Carrie_PL=Carrie_PL-1
      where employee_id=P_EMPID;
    ELSE
      UPDATE leave_calculate_pl
      SET Present_Year_PL=Present_Year_PL-1
      where employee_id= P_EMPID;
    END IF;
  
  END $$
  </code></pre>
  
  <p>And I calling the same Stored procedure in PHP, I am passing the input parameter also.</p>
  
  <pre><code>$LeaveTypeID_G=$this-&gt;getLeaveTypeId();
  $query_G="CALL Deduction_Of_PL($LeaveTypeID_G)";
  </code></pre>
  
  <p>Its giving the error as </p>
  
  <pre><code>Unknown column 'parameter_value' in 'field list'  MySQL Error # :1054 
  </code></pre>
  
  <p>Please let me know where went wrong and how can I resolve it.</p>