title: Python MYSQL problems
body: <p>I have been trying to create a clock in and out the system, for the small business that I work for. </p>
  
  <p>At the moment I am having trouble getting it to talk to the MySQL server. I am probably doing something really silly wrong. </p>
  
  <p>The section I am having trouble with is this:</p>
  
  <pre><code>cnx = mysql.connector.connect( host=localhost, user="time_clock", passwd="kayak100", db="Staff_time_clock")
  cursor = cnx.cursor()
  staffid = input('Please enter your Staff ID now ...')
  idcheck = ("SELECT staff_name, staff_id FROM Staff WHERE staff_id = %s")
  cursor.execute(idcheck,(staffid))
  </code></pre>
  
  <p>I am quite new to using MYSQL and have learnt it to try and do this small program.</p>
  
  <p>Edit - Yeah sorry forgot to add the error code that I get.</p>
  
  <pre><code>---------------------------------------------------------------------------
  ProgrammingError                          Traceback (most recent call last)
  &lt;ipython-input-49-b672a17a258e&gt; in &lt;module&gt;()
  ----&gt; 1 cursor.execute(idcheck,)
  
  C:\Users\ellio\Anaconda3\lib\site-packages\mysql\connector\cursor.py in     execute(self, operation, params, multi)
      505             self._executed = stmt
      506             try:
  --&gt; 507                        self._handle_result(self._connection.cmd_query(stmt))
      508             except errors.InterfaceError:
      509                 if self._connection._have_next_result:  # pylint:   disable=W0212
  
  C:\Users\ellio\Anaconda3\lib\site-packages\mysql\connector\connection.py in  cmd_query(self, query)
      720         if not isinstance(query, bytes):
      721             query = query.encode('utf-8')
  --&gt; 722         result = self._handle_result(self._send_cmd(ServerCmd.QUERY,    query))
      723 
      724         if self._have_next_result:
  
  C:\Users\ellio\Anaconda3\lib\site-packages\mysql\connector\connection.py in _handle_result(self, packet)
      638             return self._handle_eof(packet)
      639         elif packet[4] == 255:
  --&gt; 640             raise errors.get_exception(packet)
      641 
      642         # We have a text result set
  
  ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '%s' at line 1
  </code></pre>
  
  <p>This is the total of the error.</p>
  
  <p>Thank you</p>