Mysql question

[lebaron613]

I know pretty much nothing about databases, and I'm trying to use a testing application called quizomatic 76, and get this error when i try to open the page.

"Cant create table: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '( id SMALLINT(5) NOT NULL AUTO_INCREMENT, name varchar(30), score int, PRIMAR' at line 1"

Thank you all

[wysiwyg]

Actually I just looked up quizomatic 76 and it was written in 2004, I wouldn't use this.

[lebaron613]

Oh, thanks, do you have any suggestions on a different one to use?

[wysiwyg]

http://www.hotscripts.com/PHP/Scripts_and_Programs/Tests_and_Quizzes/index.html

Stuff in yellow is commercial so just ignore those.

Try sourceforge too, they have some good scripts on there.

Basically I wouldn't bother with anything where the example on their website doesn't work (http://www.flashlightbrown.com/quizomatic76/example_test_01.htm), or it hasn't been updated for php5.