SELECT `id`, `name`, `position`, `signedthru`, `salary2007`, `sb2007`, `wk2007`,`rb2007`,`basesalary2007`, `number`, `college`, `otherbonus` FROM `roster` WHERE signedthru >= 2007 AND (active='y' OR active='e' OR active='i' OR active='p') ORDER BY signedthru DESC<br />Unknown column 'salary2007' in 'field list'