Searching the uploaded files

[samrat_php]

Hello,

Can you please suggest me how I can search the uploaded files from the website I'm building. 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 that.

[djjjozsi]

create a form to a file name ,
and use a mysql query on the filename field..

<?php
if ( !empty( $_POST["FileName"] ) ) {
	include( "db_conn.php" ); //conn to the database

$sql = sprintf( "SELECT * FROM upload  WHERE FileName LIKE '%%%s%%'" , mysql_real_escape_string( $_POST["FileName"] ) );
$res = mysql_query( $sql );
if ( mysql_num_rows( $res ) > 0 ) {
	while ( $fields = mysql_fetch_assoc( $res ) ) {
		print $fields["ProjectName"] . ".....<br />" ;
	} 
} else
	echo "No result";
} 

?>