Member Avatar for xabi

I'm receiving the error

Unknown column 'members.committee' in 'on clause'

from the following code.

"SELECT members.firstname, members.surname, members.photo, YEAR(members.datejoined) AS yearjoined, members.profile, members.committee, category.cat_type, committee.`position`, articles.art_ID, articles.title FROM members, category LEFT JOIN committee ON members.committee = committee.ctte_ID LEFT JOIN articles ON members.mem_ID = articles.author WHERE %s = mem_ID AND members.category = category.cat_ID "

Any pointers, it's from a tutorial in a book and everything I have followed is typed correctly, the tables in the db are correct?

The only thing I can think of is that I am using PHP v5.3.0 and the book was using PHP v4.3.4.

  • 2 Contributors
  • 1 Reply
  • 108 Views
  • 15 Hours Discussion Span
  • Latest Post Latest Post by theausum
Member Avatar for theausum

seems like theres no committee column in members table

also why arnt you using aliases for tables?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.