range search in mysql

[andre_amp_rachel]

In order to find a postcode range in the database , I am selecting every record , after selecting I evaluate the query with the record and add an echo ""
Yes, I am getting the proper output.
However , I would like to make the query in the database and get the same result.

Question 2500
Query: select * from $table ORDER by place
if ($postcode >= $question_laag && $postcode <= $question_hoog) {
echo "";
}

Please supply me with an other option.

Thank You

[cleromancer]

SELECT * FROM $table
WHERE postcode >= $question_laag
AND postcode <= $question_hoog
ORDER BY place

have a look at this basic tutorial for more info:
<basics>

[andre_amp_rachel]

Great , Thanks for the advice 🙂 , Works like a charm.
Have the same problem but now I am trying to find a substring in an varchar field.

$result = mysql_query ("SELECT * FROM $table WHERE stristr(title) = "$question" ORDER BY nummer DESC");

Is what I am trying to get a faster result.
What I am using now is :

$result = mysql_query ("SELECT * FROM $table ORDER BY nummer DESC");

while ($row = mysql_fetch_array ($result)){
extract ($row);
if (stristr($titel,$question)) {
echo"";}

And again , this works , but not like it should 😕

SELECT titel from $table where 1 and titel like "%$question%" LIMIT 0, 30