TVintA - making TV interActive


SQL
SELECT id, fk_user, live, type, titel, projektnavn, beskrivelse, video, size, score, finished FROM projekter WHERE deleted = 0 AND type = 'single' or type='multi' AND finished = 'yes' ORDER BY rand() LIMIT 5
encountered the following error:
Unknown column 'video' in 'field list'



#0 prepare(SELECT id, fk_user, live, type, titel, projektnavn, beskrivelse, video, size, score, finished FROM projekter WHERE deleted = 0 AND type = 'single' or type='multi' AND finished = 'yes' ORDER BY rand() LIMIT 5) called at [/customers/3/0/b/kevinlauridsen.dk/httpd.www/itv/php/database.php:125] #1 executeSelect(SELECT id, fk_user, live, type, titel, projektnavn, beskrivelse, video, size, score, finished FROM projekter WHERE deleted = 0 AND type = 'single' or type='multi' AND finished = 'yes' ORDER BY rand() LIMIT 5) called at [/customers/3/0/b/kevinlauridsen.dk/httpd.www/itv/php/projects.php:221] #2 getProjectsFront() called at [/customers/3/0/b/kevinlauridsen.dk/httpd.www/itv/inc/indexVideoTable.php:4] #3 include(/customers/3/0/b/kevinlauridsen.dk/httpd.www/itv/inc/indexVideoTable.php) called at [/customers/3/0/b/kevinlauridsen.dk/httpd.www/itv/pages/index/body.php:14] #4 include(/customers/3/0/b/kevinlauridsen.dk/httpd.www/itv/pages/index/body.php) called at [/customers/3/0/b/kevinlauridsen.dk/httpd.www/itv/page.php:56]