Searching uploaded files from mysql database

[samrat]

Hello,

 

Can you please suggest me how to search the files which I've uploaded to my website. Here is my upload table,

 

CREATE TABLE upload (

      FileID Int Unsigned Not Null Auto_Increment,

      ProjectName VarChar(255) Not Null,

      Description VarChar(255) Not Null,

      FileName VarChar(255) Not Null Default 'Untitled.txt',

      FileMime VarChar(50) Not Null Default 'text/plain',

      FileSize BigInt Unsigned Not Null Default 0,

      Path LongBlob Not Null,

      Created DateTime Not Null,

      PRIMARY KEY (FileID)

    );

 

I'll be grateful if you give the code for search.

[.josh]

 

 

http://www.phpfreaks.com/tutorial/php-basic-database-handling