[support] Search My Custom MySQL Table in drupal

[Larry Garfield]

My that first link looks familiar... ;-)

The Views Advanced Help text includes decent information on hook_views_data(), 
which is the main hook you'll use.  The table wizard module will also auto-
generate most of that hook for you.  You'll need to tweak it some to change 
the handlers used for each field (in some cases), but overall it should get you 
a very good start.

On Tuesday 04 August 2009 12:20:29 am Steve wrote:
> Thanks just the direction i needed  Yes it is a read-only data and i need
> to expose it to drupal. Do you have links of how this is implemented or the
> exact link of the views documentation i would appreciate. I have checked
> out some
> here<http://www.palantir.net/blog/remote-data-drupal-museums-and-web-2009>a
>nd
> here<http://www.gregeisenman.info/blogs/greg/views-2-and-drupal-adding-cust
>om-field-views-query>but most are just write ups.
>
> Thanks its time i start figuring this out
>
> On Mon, Aug 3, 2009 at 5:54 PM, larry at garfieldtech.com <
>
> larry at garfieldtech.com> wrote:
> > CCK and webform won't really help you here.  If this data is read-only,
> > and you just want to expose it to Drupal, I'd recommend adding Views
> > integration hooks for that table.  Then you can build lists and queries
> > against it using Views, including exposed filters that you can use as a
> > search form.
> >
> > The Views documentation has more details.  I also recommend the table
> > wizard module, which can greatly speed up the process of writing the
> > necessary hooks.

-- 
Larry Garfield
larry at garfieldtech.com