title: mysql C# syntax issue with a select statement
body: <p>Hi I would like some help with my SQL syntax i'm very stumped into how to alter it to show the following Id,Author,Title From books</p>
  
  <pre><code>public  Book    getBookByID(int bookID) 
  {   
        System.Diagnostics.Debug.WriteLine("Attempting    to  get book    with    ID: "   +   bookID);    
        try   
        { 
            conn  =   new MySqlConnection(cs);    
            conn.Open();
  
            string stm = ("SELECT Id, AuthorId,Title  FROM    books   WHERE   Id  =   " + bookID);    
            MySqlCommand  cmd =   new MySqlCommand(stm,   conn);  
            rdr   =   cmd.ExecuteReader();        
  </code></pre>
  
  <p>And I recieve this error</p>
  
  <blockquote>
    <p>MySql.Data.MySqlClient.MySqlException (0x80004005): 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 'SELECT   Id, AuthorId,Title  FROM    books   WHERE   Id  =   1' at line 1</p>
  </blockquote>