[Marco van Herwaarden]

The query is correct, but i would suggest some minor changes:
[sql]CREATE TABLE whodownloaded (
downloadid INT(15) NOT NULL AUTO_INCREMENT,
userid INT(10) NOT NULL default 0,
username VARCHAR(100) NOT NULL default '',
fileid INT(10) NOT NULL default 0,
filename` VARCHAR(100) NOT NULL default '',
dateline INT(10) NOT NULL default '',
ipaddress VARCHAR(15) NOT NULL default '',
alt_ip VARCHAR(15) NOT NULL default '',
PRIMARY KEY (downloadid )
);[/sql]
- Removed the backticks, they are not needed.
- Removed the single quotes around the default values for numeric columns.
- Removed the table type MyIsam, not needed, can follow the database default.