in da_silvy's code change this line in the bold.

Code:
$query = "CREATE TABLE `downloads` (`ID` INT(11) NOT NULL AUTO_INCREMENT, `title` TEXT NOT NULL, `link` TEXT NOT NULL, `description` TEXT NOT NULL, `downloads` INT(11) NOT NULL , PRIMARY KEY (`ID`))";
you could do it without mysql, but what fun would php be if you can't use mysql.

I think that will fix it. if not just take out all the not nulls except this one
downloads` (`ID` INT(11) NOT NULL AUTO_INCREMENT,

do not take the not null out of that one.
also I don't think you can have a row the same name as the table. might want to check with da_silvy on that one since he wrote it. that is my guess