Help with this select query

[golfinggod]

HI
can anyone sort this line of code out for me. I want to find all the values that are greater than 500 and lower than 1001.

$query = "SELECT * FROM FreeRolls Where Prize < '500' && Day = '$Today' && Prize < '1000=1'  ||   Prize < '500' &&  Day = 'Eve' && Prize < '1000=1'    Limit 14  "; 

At the minute im getting every result below 1000.

[gufmn]

Ummm....if you want values grater than 500, maybe you should use the greater than symbol ">" 🙂

[golfinggod]

LOL 😃

Guess I missed that one.

Cheers