joining tables from selected values

2002-04-01 Thread Tomas Sanchez
Hi! Id would like to have 4 tables files ( id int(8), type set("directory", "file", "link"), ) files_directory ( id int(8), is_files int(8), name varchar(20) ... ) files_file ( id int(8), is_files int(8), name varchar(20) ... ) files_link ( id int(8), is_files int(8), name varchar(20) ... )

getting files into BLOBs and some more

2002-03-26 Thread Tomas Sanchez Romani
Hi! I'm thinking of creating a quite simple filemanager, using mysql/php, for a groupware-suite. My first approach was to just create a directory-tree on the webserver and let my app mirror that, then I realised that I needed some privilege-system and thus mysql. How do I insert files inte B