Search database fields using single text field

[S]

Kindly advise on how to develop a database search page such that there is
single text field to enter serach string and the results are shown on the
same page.
ALso guide if there is any extension available for achieving the above.

[S]

advise on how to develop a database search page such that there is single
text field to enter search string and the results are shown on the same
page.
Also guide if there is any extension available for achieving the above.

[S]

I understand what you say.
What I am looking for is a wizard or an extension which creates the form, as
well as writes the SQL string and also generates the results page
(preferably on the sarch page itself).
I am looking for a google like solution where the site homepage has one text
field, and users can search for all the fields of a database to give results
on the same page.

Please help.

"malcster2" <webforumsuser@macromedia.com> wrote in message
news:gg9g8b$lf9$1@forums.macromedia.com...

> the simplest way of doing it is to have an input box and a submit button
> in a
> form,
>
> when the submit button is pressed, the text in side the input box is
> posted to
> a variable.
>
> the variable is then inserted into a mysql select statement, and the
> results
> are then echoed to the screen.
>
> all of this using php.
>
>
>
>

[Hunter Elliott]

"S" <uandme72@yahoo.com> wrote in message
news:gg9h9e$mns$1@forums.macromedia.com...

>I understand what you say.
> What I am looking for is a wizard or an extension which creates the form,
> as well as writes the SQL string and also generates the results page
> (preferably on the sarch page itself).
> I am looking for a google like solution where the site homepage has one
> text field, and users can search for all the fields of a database to give
> results on the same page.

then why not just use Google's search tool on the site?

[S]

Google search does search only the text portion of the site pages. What we
want is searching all the fields of the database which can be done only by
search page.



"Hunter Elliott" <nospam@gatewaycity.com> wrote in message
news:gg9p02$2ig$1@forums.macromedia.com...

>
> "S" <uandme72@yahoo.com> wrote in message
> news:gg9h9e$mns$1@forums.macromedia.com...

>>I understand what you say.
>> What I am looking for is a wizard or an extension which creates the form,
>> as well as writes the SQL string and also generates the results page
>> (preferably on the sarch page itself).
>> I am looking for a google like solution where the site homepage has one
>> text field, and users can search for all the fields of a database to give
>> results on the same page.

>
> then why not just use Google's search tool on the site?
>
>