finding rows between 2 values

[dkin]

Im trying to return values between 2 numbers but I cant seem to figure it out.

This is what I have.

$nresult = mysql_query("SELECT * FROM user_char where rank <= '$rows' && >= '$end_row' order by rank asc", $link) or die ("query 1: " . mysql_error());

any help is appreciated.

Cheers
Dylan

[dreamcatcher]

Hi dkin,

Try something like:

$nresult = mysql_query("SELECT * FROM user_char WHERE rank BETWEEN '$rows' AND '$end_row' ORDER BY rank asc", $link) or die ("query 1: " . mysql_error());

dc