Search function using a database?
481531
I don't know if what you looking for is possible. The way it sounds you want search terms entered and then based on those, it will decide which page to go to. A better way is to have a search page that displays results and allows them to be clicked on and then displays the page. \n\nThis would definitly take some script of some sort. I prefer using ASP.NET and C#. However, this can be done many different ways. If you would use C# or VB, there are visual tools you can use to create a connection to your database, create a data table within your web application and then display the corresponding data.\n\nFor more information see:\nhttp://www.asp.net\n\nThat site contains a lot of information.\n\nGood luck!
1138091
You should try searchbug.com.
250012
Have you tried a search engine?
696438
I'm missing something from your question.\n\nYou can always test your query in query analyzer.\n\nYour query looks fine but my confusion is in your where clause - if xxx is coming from the textbox then it sounds like you might generate the following query:\n\nselect * from table where bob like '%@bob'.\n\nWhen you probably want the following:\nselect * from table where COLUMNNAME like '%bob'\n\nnote:  I removed the @ symbol from your sql statement.\n\nAlthough you're better off creating a stored procedure that accepts a parameter using the field value as the parameter.\n\nIf you have any questions feel free to send me an email.
305061
Look into osCommerce, a free open-source shopping cart for PHP / MySQL:\n\nhttp://www.oscommerce.com/
375067
I'd like to be able to search people based on their interests.
1333
Sorry in advance if Yahoo eats my indentation, but I think you are looking for something like this (tested under Access 2000):\n\n\nPublic Sub FiddlingWithQueryObjectsViaVBA()\n\n    Dim dbs As DAO.Database\n    Set dbs = CurrentDb\n    Dim qrydef As QueryDef\n    \n    Dim sSQLstring As String\n    Dim sQueryNames As String\n    \n    For Each qrydef In dbs.QueryDefs    ' iterate through all the Access query objects\n    \n        sSQLstring = UCase$(qrydef.SQL) ' Get the SQL for the current query\n        \n        If InStr(sSQLstring, "SOMETHING_I_AM_LOOKING_FOR") > 0 Then   ' I found what I'm looking for?\n        \n            sSQLstring = Replace$(sSQLstring, "SOMETHING_I_AM_LOOKING_FOR", "REPLACEMENT_TEXT") ' replace the text\n            qrydef.SQL = sSQLstring     ' update the query object with the new SQL\n        \n            sQueryNames = sQueryNames & qrydef.Name & vbCrLf    ' Maybe make a list of queries modified?\n        End If\n    \n    Next\n    \n    MsgBox "Modified the following queries:" & vbCrLf & sQueryNames\n    \nEnd Sub
256570
Check batf.org and enter still in search engine :-)
174841
Try WebSideStory. They have a free search module you can add to your site. It's free for sites with less then 1000 pages or something like that...\n\nWebSideStory Express Search:\nhttp://www.websidestory.com/products/hosted-site-search/express-search/overview.html?lid=//Products//Express+Search
896456
mySQL should be part of your solution.\n///
820602
Use Windows Explorer's search function if you can.
461634
type that in a search engine
520193
search and search at the right place
1138493
There's a number of ways to do that. Just understand that each name has its sequence of dial digits. You should index by these digits to lookup.\n\nSo if you have a database, just make a table of pairs: names and matching dial digits. Index by dial digits. Then you can lookup fast.\n\nIf you want to do that manually, you might sort your huge name list by sequence of dial digits, and then lookup fast with binary search (logarithmic time). This way you do not even have to store your dial digits for each name. In C++ this could be done with e.g. a std::set of strings sorted by dial digits.\n\nI hope this is clear. If you need details, drop me a note.
95688
This can be done without too much trouble. Start by creating a text box on the page, then on the button click event, query the database based on the textbox content, for example if the box will contain a name or fragment of the name, then use this as your command text:\n"SELECT * FROM [table] WHERE [field] LIKE '%" + TextBox1.Text + "%'"\n\nThis query will return anything that starts with, contains, or ends with the text in box 1.  Then you display that data by binding the datatable the contains the new data with your datagrid. \n\nGood Luck!
461382
Since not getting a response from here, you might try on-line search.  To do a single search normally doesn't cost all that much.
393916
Check the US Patent and Trademark Office. They have a search function.