Thread: Problem

    #1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2000
    Posts
    4
    Rep Power
    0
    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!

  2. #2
  3. .Net Developer
    Devshed Novice (500 - 999 posts)

    Join Date
    Feb 2000
    Location
    London
    Posts
    987
    Rep Power
    15
    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'}%'"

Similar Threads

  1. UTF-8 problem in 4.1.1a
    By mehran20 in forum MySQL Help
    Replies: 1
    Last Post: February 8th, 2004, 03:21 PM
  2. Redirection problem with frames.....
    By ykwongss in forum PHP Development
    Replies: 0
    Last Post: January 21st, 2003, 11:07 AM
  3. Strange problem with variables passed via URL
    By C3P0 in forum PHP Development
    Replies: 3
    Last Post: January 13th, 2003, 02:29 PM
  4. PHP / Cron / Shell Script problem, help needed
    By badhaiku.dk in forum PHP Development
    Replies: 3
    Last Post: January 9th, 2003, 01:08 PM
  5. ld problem in Apache build w/ PHP
    By Eric Anderson in forum Apache Development
    Replies: 3
    Last Post: April 9th, 2001, 02:18 AM

IMN logo majestic logo threadwatch logo seochat tools logo