select all data to a database between results = 1 to 100
<p>I have a problem selecting data to a table and echoing e.g. </p>

<pre><code>--------------------------------------
id   |   bought   |   customerName    | 
--------------------------------------
1    |     70     |  customer 1       |
2    |     20     |  customer 2       |
3    |     50     |  customer 3       |
4    |     30     |  customer 4       |
5    |     80     |  customer 5       |
6    |    100     |  customer 6       |
--------------------------------------
</code></pre>

<p>what I want to do is order by bought and select bought between 50 to 100 that would be resulting </p>

<pre><code>customer 3 --- 50
customer 1 --- 70
customer 5 --- 80
customer 6 --- 100
</code></pre>
