Help with 1 line please?

Discussion in 'PHP' started by mokimofiki, Dec 26, 2008.

  1. #1
    I can't seem to figure out what my problem is (I am Noob so it may be easy)

    $townquery = doquery("SELECT name FROM {{table}} WHERE id='".$userrow["id"]."' LIMIT 1", "users");
    Code (markup):
    This is the error that I recieve:

    Unknown column 'name' in 'field list' (what does this mean that I'm missing or looking at something wrong?)

    Thank you in advance
     
    mokimofiki, Dec 26, 2008 IP
  2. tamen

    tamen Peon

    Messages:
    182
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    0
    #2
    It means there is no field named "name" in the table you are searching in.
     
    tamen, Dec 26, 2008 IP
  3. qualityfirst

    qualityfirst Peon

    Messages:
    147
    Likes Received:
    6
    Best Answers:
    1
    Trophy Points:
    0
    #3
    Yea, no column called name in the table field list.
     
    qualityfirst, Dec 26, 2008 IP
  4. mokimofiki

    mokimofiki Well-Known Member

    Messages:
    444
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    130
    #4
    Oh duh ... thank you ... I have been looking at that line for a while trying to figure it out and of course its just the table name

    Thank you :)
     
    mokimofiki, Dec 26, 2008 IP