CREATE TABLE table_34942 ("Date" TEXT, "Opponent#" TEXT, "Site" TEXT, "Result" TEXT, "Attendance" TEXT)

What is the Attendance number when the Opponent was purdue?
SELECT "Attendance" FROM table_34942 WHERE "Opponent#" = 'purdue'
SELECT "Attendance" FROM "table_34942" WHERE "Opponent#" = 'purdue'