Between

[Tweak]

How can I make a search that searches between two numbers, like if someone wanted to search all between 5 and 10.

[extra]

Do you mean to get all the numbers between $number1 and $number2 (5 and 10 in your example)?
If yes:
[php]<?php
$number1 = 5;
$number2 = 10;
for($i < $number2; $i = $number1; $i++){
echo $i."<br />";
}
?>[/php]
If you mean to give a random number between 5 and 10, then put this:
[php]<?php
$number1 = 5;
$number2 = 10;
$randomNumber = rand($number1, $number2);
?>[/php]

I would not recommend setting the variables as they slow out the script, just put them directly.

[Tweak]

Well i have the input type='text' on the page, so i will change to variables to "Get" and it will work?

[wide_load]

Well i have the input type='text' on the page, so i will change to variables to "Get" and it will work?

dont know where you got that idea

do you meen between rows 5 and 10 of a database ?

[Tweak]

no. Okay so there is levels in the game. I want the user to be able to search through all users. I have it so they can search by username, but i want it so they can search by level. So i have two input boxes. So they will search all users whos level is between the specified searches.

[libeco]

So probably you are searching through a database, in which case you want to use the LIMIT clause to get only 5 results starting at a certain record.

[wide_load]

So probably you are searching through a database, in which case you want to use the LIMIT clause to get only 5 results starting at a certain record.

no no

he means that there is a field that has possible values form 1 to 10 and wants to search for the ones that have this value between 5 and 10

thats my understanding of it anyway

i believe you can use the less than < and greater than > opperator but not too sure.

[Tweak]

When I try a "mysql_query("SELECT * FROM users WHERE Level > $search AND < $search2");"
I get an error.

[Cags]

To use that syntax you would have to use the field name before both the less than and greater than symbols, not just the first. This is much the same as logic in PHP. You can't do...

[php]if( $a > 10 && < 11 ) {[/php]
Having said that your topic title has the answer in it.

[syntax=mysql]WHERE level BETWEEN $search AND $search2[/php]