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

"You have to choose at least one column to display" Error

Discussion in 'General PHP and MySQL Discussions' started by Matthew Hawley, Jan 30, 2014.

  1. Matthew Hawley

    Matthew Hawley Well-Known Member

    I'm trying to submit this query:

    And I am getting the following error.

    "You have to choose at least one column to display"
     
  2. Chris D

    Chris D XenForo Developer Staff Member

    Are you running that in PHP My Admin?

    Make sure you use the SQL tab. Not the Query tab.
     
  3. Matthew Hawley

    Matthew Hawley Well-Known Member

    Oh.... I was doing it in the Query tab.
     
  4. Chris D

    Chris D XenForo Developer Staff Member

    You're welcome (y)
     
  5. Matthew Hawley

    Matthew Hawley Well-Known Member

    Oh sorry!!!! Thanks!

    I'm trying to say thank you more often. Sorry for forgetting. :oops:
     
  6. Matthew Hawley

    Matthew Hawley Well-Known Member

    Oh also I got this error when I entered it, but I think it has a problem to do with the smiley manager.

    #1091 - Can't DROP 'smilie_category_id'; check that column/key exists
     
  7. Chris D

    Chris D XenForo Developer Staff Member

    It's trying to say it can't drop the column because it doesn't exist. So you can remove that drop statement from your query.
     
  8. Matthew Hawley

    Matthew Hawley Well-Known Member

    Thanks! Worked like magic. :love:
     

Share This Page