Unexpected EOF in mysql shell script -

I'm getting some mysql information from a shell like this:

  #! / Bin / Bash KOffArpas = $ 1Interncomm = $ 2Flat = $ 3Number = $ 4MySquelLollinPipSwiredDB_Name & lt; & Lt; Select EOF CodeGuest E-mail, codePrivateEmail from mbus_clients WHERE flat = $ flat and domophone = $ intercom; EOF  

I found this solution in some tutorials, but it says: To use the closest 'EOF', check the manual related to your MySQL server version for the correct syntax. That's wrong? How can I complete the mysql session? Here is an example of a tutorial where I got the solution.
UPDATE does not even include separate quotes for EOF.

Pass dynamic parameters with quotation marks in your query.

 < Code> select codeGuestEmail, codePrivateEmail from mbus_clients where flat = '$ flat' and domophone = '$ intercom';  

Or try with codeguestEmail, from codePrivateEmail to mbus_clients where flat = $ {flat} and domophone = $ {intercom};