1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

to select range of id from table

Discussion in 'MySQL' started by kalaid, Jul 21, 2007.

Thread Status:
Not open for further replies.
  1. kalaid

    kalaid New Member

    Joined:
    Jul 21, 2007
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    0
    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 navydb WHERE (1<id<9)")

    it didnt work. Help me
     
  2. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,285
    Likes Received:
    364
    Trophy Points:
    83
Thread Status:
Not open for further replies.

Share This Page