<?php // Dodanie rekordu do bazy danych. $query = "INSERT INTO uploads (file_name, file_size, file_type, description, upload_date) VALUES ('{$_FILES['upload']['name']}', {$_FILES['upload']['size']}, '{$_FILES['upload']['type']}', '$d', NOW())"; ?>
nazwa: uploads
tabele: file_name, file_size, file_type, description, upload_date jakie parametry im dac?
i jeszcze powinno byc cos w stylu upload_id
EDYT
Chcialem tak:
CREATE TABLE `uploads` ( `upload_id` TINYINT( 4 ) NOT NULL AUTO_INCREMENT , `upload_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' ) ENGINE = MYISAM CHARACTER SET cp1250 COLLATE cp1250_bin MySQL zwrócił komunikat: Dokumentacja #1075 - Incorrect table definition; there can be only one auto column and it must be defined as a key
Jak to poprawic? Aha i ten TEXT tu nei pasuej chhyba ? :/ aha juz iwem dodalem primary cos tam, ale na co najlepiej zmienic te pola:
`file_name` TEXT NOT NULL ,
`file_size` TEXT NOT NULL ,
`file_type` TEXT NOT NULL ,
`description` TEXT NOT NULL ,
