Problem

Im building a website where ppl can upload and retrieve documents. The data beloning to that document like author and title are put in a database,at the moment im implementing the search option but i cant seem to get parameter in a SELECT statement, example

SELECT * FROM DOCUMENT
WHERE DocName="$cgi_data{'search'}"

While the parameter is filled it doesnt seem to have affect. Anyone ideas?

For i forget im using Perl and DBI to acces my database. If i didnt explain anything right pls tell me so i can explain.

Tnx in advance,

Thijs Hodiamont AKA BuTcH!

i didn't get your question.but i am writing
the syntax for searching

"SELECT * FROM DOCUMENT WHERE DocName='$cgi_data{'search'}'"


for detailed search use following

"SELECT * FROM DOCUMENT WHERE DocName='%$cgi_data{'search'}%'"