[request] php expert

[tasha]

i need little help with my query... i need to select npcs with limit of levels 1-10.. (and no i dont wana use (WHERE level='1' AND level='2' AND level='3' ....etc))

 

$result = mysql_query("SELECT * FROM npc WHERE type='L2Monster' ORDER BY level LIMIT ((level='1'),(level='10'))");

[embass]

SELECT * FROM npc WHERE type='L2Monster' and level between 1 and 10 ORDER BY level DESC

 

This is not related to php at all. It's a simple mysql query.

 

 

More info here: http://www.w3schools.com/Sql/sql_between.asp