Question: What is wrong with this code. I seem to have the same problems everytime I try to use an AND or an `OR` in a mysql statement.

I am obviously not understanding how this is being interpreted as I can never get it to work. 

```
SELECT *
  FROM customer
 WHERE (record_number = '{$_POST['record_number']}')
    OR (po = '{$_POST['record_number']}) 
LIMIT 1

```

Even when I enter the correct data, it comes back as nothing found. What is the proper syntax for this - drives me insane. I have tried this 10 different ways, including no ( brackets, brakets in different areas of the statement etc.

Answer: 
You didn't close the quote on `OR (po='{$_POST['record_number']})`.

On a side note - this is hugely opened to sql injection attack - might want to look into sanitizing your inputs.
Use:

```
$query = sprintf("SELECT c.*
                    FROM CUSTOMER c
                   WHERE c.record_number = '%s'
                      OR c.po = '%s'
                   LIMIT 1",
                 mysql_real_escape_string($_POST["record_number"]),
                 mysql_real_escape_string($_POST["record_number"]));

$result = mysql_query($query);

```

* You were missing a single quote for the `po` comparison
* The brackets are not necessary in this query
* The [query you posted is susceptible to SQL injection attacks](http://xkcd.com/327/) - use prepared statements