A MySql query, then display

[WinterDragon]

Alright, how would I get results, lets say all results that are LESS than a certain number that was entered by the user? Also, lets say also that only match a certain type... so i have a few columns, lets say 2 of them, one is TYPE, and one is LEVEL, type could be head, body, ring, etc... and LEVEL can be 1-100, how can I for instance, search for an item that is level 30 or lower, and is... body? Thanks for any help. 🙂

[jeremuck]

I'd recommend checking out the MySQL language reference at www.mysql.com.

You want something like:
SELECT * FROM table_name WHERE LEVEL < 30 AND TYPE = "body";