MYSQL error?

Discussion in 'MySQL' started by josephman1988, Feb 17, 2006.

0
  1. #1
    mySQL query error: SELECT gid,name,score,date,mid FROM ibf_games_hall WHERE gid IN (28,75,30,1,29,16,64,8,42,11) ORDER BY gid

    SQL error: Unknown column 'gid' in 'field list'
    SQL error code:
    Date: Friday 17th of February 2006 03:00:22 PM

    whats wrong n how can i fix?

    cheeeers
     
    josephman1988, Feb 17, 2006 IP
  2. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    38,334
    Likes Received:
    2,613
    Best Answers:
    462
    Trophy Points:
    710
    Digital Goods:
    29
    #2
    Did you check that the ibf_games_hall table actually has a column named gid?
     
    digitalpoint, Feb 17, 2006 IP
  3. josephman1988

    josephman1988 Peon

    Messages:
    3
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    This is my listing in ''ibf_games_list''

    [​IMG]

    If i need to add on. how do i do so?
     
    josephman1988, Feb 17, 2006 IP
  4. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    38,334
    Likes Received:
    2,613
    Best Answers:
    462
    Trophy Points:
    710
    Digital Goods:
    29
    #4
    Looks to me like gid is supposed to be champ_gid in your query... either way, there is NOT a column named just gid.
     
    digitalpoint, Feb 17, 2006 IP