Query Prob

[tyrnt]

Hi all,

mysql_query("SELECT * FROM items WHERE 'min_dmg' >= '$min_dmg' AND 'max_dmg' <= '$max_dmg'", $link);

This is a query i am using for the search function of a database I am putting together. Most things are workin except for the searchin aspect. If i search for specifics it will return the right things but if its 40-80 and i search 45-60 it wont return anything.

Can anyone see anything wrong with the statement?

If more information is needed please tell.

Thanks in advance,

Tyrnt

[Anon]

mysql_query("SELECT * FROM items WHERE min_dmg >= '$min_dmg' AND max_dmg <= '$max_dmg'", $link);

Don’t use '' when referring to data in mysql

thats the only error with the info in ur post

[tyrnt]

Without using those quotes the query doesnt work at all. If there is any other information needed. I will provide it.