SQL querys on different severs

[wizzard1]

Please forgive my incompetence, I am running two MySQL databases on two different servers. I have been entering fields like "lastName", "firstName" and "contactID" (primary&auto increment").
One server allows a SQL query like $sql = 'SELECT lastname, firstname FROM contacts WHERE id = 1 ';
but returns an error for
$sql = 'SELECT lastname, firstname FROM contacts WHERE lastname = bush ';

The other database allows a query like $sql = 'SELECT lastname, firstname FROM contacts WHERE lastname = bush ';
but returns an error for
$sql = 'SELECT lastname, firstname FROM contacts WHERE id = 1 ';

Does anybody know what I have done wrong or could shed some light?

Many thx in advance

[mystrymaster]

based on the info that you have given I wouldn't see how the ID query works anywhere as the field name is contactID.

Please provide two actual calls that work and don't work on each server and whether or not you are doing this on a php page or directly in the database.

[wizzard1]

Thx for your time Mystrymaster,
Your answer prompted me to look at exactly what my fields were called one was called contact ID which I was using contactID to SQL query in the database. After changing the field to contactID with no space it works fine.

The SQL query with the surname works when the surname is enclosed in commas.

Thank you it all seemed a lot clearer the next day.