Building a simple search engine

Hi cool11,

Just an update: i got my little simple search engine to work. Im not sure what language or database your using but im using ASP and Access. I have a table in my database called PAGES and in that table i have the columns:

> PAGEID
> PAGENAME
> KEYWORDS
> URL

im just about to add a description too.

Then i connected the database. Create a form with one textbox called Search, made the action of the form point to my results page. Thats that page done.

On the results page i just created a recordset which search my keywords column then for the condition i set to 'contains'. third box set to form variable and the forth to the name of my text box on the search page. then just create a recordset to display ur results in a repeat table and your done!!

Hope this helps, give me a shout if you need help.

Adam

How exactly have you constructed your database? If your simply searching the page url then only exact maches will display results. Perhaps you shoulud think about adding a column called keywords or something? I am trying the same thing at the mo but its just the keywords im having trouble with.

Hope this helps,
Adam

I tried 'contains' because I think is better for what I want.
Results are slightly better but once again nothing seem to work right.
What I mean? For the first time I see results when I give nothing to search. It returns all the records. This could not happen with '='.
But when I search something that exists, it still does not give any matches.
Why?
I am doing everything the instructions said.

cool11 wrote:
> I have made many tests and I found that the problem is the 'equal' sign.
> I tried almost everything. Search about anything. I see the data in the
> database and I am giving search strings that exist. But no results yet.

The equals sign looks for an exact match. Try "contains", "begins with",
or "ends with". (The names may be slightly different in the Recordset
dialog box - I don't have DW open at the moment.)

--
David Powers
Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
http://foundationphp.com/