Hi guys,
I've trying to work with a file upload/download script and I want to show today's and yesterday's uploaded files on the main page. But I'm having problems with selecting them from the databse. The table looks like this:
CREATE TABLE uploaded_files (
id int(10) unsigned NOT NULL auto_increment,
info_hash varchar(20) binary NOT NULL default '',
name varchar(255) NOT NULL default '',
filename varchar(255) NOT NULL default '',
search_text text NOT NULL,
category int(10) unsigned NOT NULL default '0',
size bigint(20) unsigned NOT NULL default '0',
added datetime NOT NULL default '0000-00-00 00:00:00',
times_downloaded int(10) unsigned NOT NULL default '0',
visible enum('yes','no') NOT NULL default 'yes',
owner int(10) unsigned NOT NULL default '0',
banned enum('yes','no') NOT NULL default 'no',
PRIMARY KEY (id),
UNIQUE KEY info_hash (info_hash),
KEY owner (owner),
KEY visible (visible),
KEY category (category),
KEY filename (filename),
KEY name (name),
KEY added (added),
FULLTEXT KEY ft_search (search_text)
) TYPE=MyISAM;
I very much need your help. I've tried many variations but nothing worked. Please suggest/help me with whatever you can...
EDIT: Never mind, I already finished working with this. It works perfect. Anyway, thanks to those who tried to help but couldn't.
