It sounds like you want a node type called "library_item". That gives you add and edit forms. Drupal's built-in search functionality can let you search those as well as other nodes, or restrict the search to just one node type. To create a form that searches just one node type, do an advanced search with the search module (built-in) on just one node type and see what the URL looks like. Then write a new form (using Drupal's Form API!) that simply adds on whatever the "one node only" parameters are and submits to the common search page.
For creating nodes, you can either model node_example.module (http://api.drupal.org/) or use CCK (http://drupal.org/project/cck) to define the node type dynamically through Drupal. I personally prefer the latter as it's much faster and more flexible, but YMMV.
On Saturday 27 January 2007 9:22 am, John Clarke wrote:
Hi, I am working with a functioning Drupal site and have been asked to add an additional MYSQL table (book/resource library items) and a SIMPLE entry, edit and search form. I want the users to be able to search on several fields at once always with a %like% argument. Also, I need some simple results control (i.e. max items per page).
Are there any Drupal-friendly PHP snippets that I could use to do this? My MYSQL table is up and running so I only need the scripts.
Any suggestions are welcome.
-John