From: Stuart Felenstein [mailto:[EMAIL PROTECTED]
> I'm running into a problem here where mySQL is saying > unknown column. > Education_table > TypeID Type > HS High School > CO College > MA Masters > > SQL: > Select * from Education_table (and no the table is not > named table) > > From: TypeID = Value , Type = Label > Choose High School > Error Msg: > Unknown column 'HS' in 'field list' > > I tried adding where typeid = type but that makes not > sense. > I'm now wondering and running (after I post) if type > is a no-no-word. Try wrapping Value in single- or double-quotes in your code. It sounds like it's essentially generating this query: Select * from Education_table where TypeID = HS; instead of... Select * from Education_table where TypeID = 'HS'; HTH! -- Mike Johnson Smarter Living, Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
