i have a mysql database with movies
title, genre, artists etc

i need a search engine, which can search the database by any of the sections....

took a look at hotscripts com, but can understand at first look, which will do this, and i do not have time to test, i need it urgently

therefore i hope that someone of you will point me concrete script doing this job

    You only need a few lines of SQL code:

    Here is an example:

    SELECT * FROM table WHERE column LIKE 'search_string%';

    SELECT title, genre, etc FROM movies WHERE title LIKE 'Gremlins%';

    The direct above code will select the title, genre, and etc from table movies where the search was Gremlins.

    It will output somethign like this:

    Gremlins
    Gremlins 2
    Gremlins 3
    Gremlins Attack
    Gremlins for President

    If you add a % before the search string, the it will report everything with the word Gremlins in it.

    Hope that helps, becuase I doubt anyone will write this entire code for you.

      thanks, but i still do not have the knowledge to build a script from that....

      i was hoping that someone will point me something simple, quering the database, allowing wildcards and outputing the results
      i''ll be able to do the rest on my own

        5 days later

        Originally posted by gamew0rld
        Hey, check out http://www.digitalgenesis.com/

        I use it on my site at http://www.gameworldx.com

        o, great, dgs search
        that's the script i found at hotscripts, that suits best my needs, but the link there was 404
        now i'm installing it

        btw do u use it for searching into databse, or file system?

        what r ur impressions about it?

          I use it to search my database. I had to edit the script to suit my needs a little bit, but it still works great.

            right now i'm editing it too
            very good script for what i'm needing

            thanks

              Make sure to mark this resolved if your question has been answered. 😃

                Write a Reply...