to select range of id from table

Hi,
how do you choose a range of ID from a db?

I used query to select record matched with particular id
$data = mysql_query("SELECT * FROM table_name WHERE (id=2)")

I tried like above query to select record with id's 2 through 9
$data = mysql_query("SELECT * FROM table_name WHERE (1<id<9)")

it didnt work. Help me

 

Hi,

You can use following query

Thanks