Hi,
Does anyone have any suggestions as to how I can let users query a two column table.
Basically what I'd like to do is: Allow users to search fusing or a specific string stored in Column A and the search should show up all the matches from column B.
For example: Lets say I have a table with colun names 'school_ID' and 'phone_number'. I'd like users to be able to find the phone_number using the school_ID. The text they enter should match the data in the table EXACTLY or an error message is shown.
Are there any modules to help me to this? Or can I customise something already out there?
Kind regards, Ayath
And you can't use CCK & Views w/ exposed filter? *
Ryan LeTulle,* Web Developer
personal: bayousoft.com http://www.bayousoft.com twitter: @bayousoft http://twitter.com/bayousoft
http://twitter.com/bayousoft*"Be the change you want to see in the world." * Mahatma Gandhi
On Wed, Jan 19, 2011 at 3:14 PM, Ayath ULLAH ayath@hotmail.co.uk wrote:
Hi,
Does anyone have any suggestions as to how I can let users query a two column table.
Basically what I'd like to do is: Allow users to search fusing or a specific string stored in Column A and the search should show up all the matches from column B.
For example: Lets say I have a table with colun names 'school_ID' and 'phone_number'. I'd like users to be able to find the phone_number using the school_ID. The text they enter should match the data in the table EXACTLY or an error message is shown.
Are there any modules to help me to this? Or can I customise something already out there?
Kind regards, Ayath
-- [ Drupal support list | http://lists.drupal.org/ ]
Hi ,
I'm quite new to Drupal any chance you can walk me thorugh the method suggested below. Another query... Is it possible to block users viewing nodes via the direct url or the menu. But allow them to see the content via a search only.
Kind regards, Ayath
From: bayousoft@gmail.com Date: Wed, 19 Jan 2011 15:20:45 -0600 To: support@drupal.org Subject: Re: [support] Searching custom MySQL Tables
And you can't use CCK & Views w/ exposed filter? Ryan LeTulle, Web Developer
personal: bayousoft.com
twitter: @bayousoft
"Be the change you want to see in the world." Mahatma Gandhi
On Wed, Jan 19, 2011 at 3:14 PM, Ayath ULLAH ayath@hotmail.co.uk wrote:
Hi,
Does anyone have any suggestions as to how I can let users query a two column table.
Basically what I'd like to do is: Allow users to search fusing or a specific string stored in Column A and the search should show up all the matches from column B.
For example: Lets say I have a table with colun names 'school_ID' and 'phone_number'. I'd like users to be able to find the phone_number using the school_ID. The text they enter should match the data in the table EXACTLY or an error message is shown.
Are there any modules to help me to this? Or can I customise something already out there?
Kind regards, Ayath
--
[ Drupal support list | http://lists.drupal.org/ ]
You are going to want to google cck and views video tutorials for beginners. I suggest that you watch videos since they are hands on and you can pause them as you follow along.
Here's a link I found to a couple of free videos by Lullabot: http://www.lullabot.com/articles/free-drupal-cck-views-video-chapters
*
Ryan LeTulle,* Web Developer
personal: bayousoft.com http://www.bayousoft.com twitter: @bayousoft http://twitter.com/bayousoft
http://twitter.com/bayousoft*"Be the change you want to see in the world." * Mahatma Gandhi
On Wed, Jan 19, 2011 at 4:57 PM, Ayath ULLAH ayath@hotmail.co.uk wrote:
Hi ,
I'm quite new to Drupal any chance you can walk me thorugh the method suggested below. Another query... Is it possible to block users viewing nodes via the direct url or the menu. But allow them to see the content via a search only.
Kind regards, Ayath
From: bayousoft@gmail.com Date: Wed, 19 Jan 2011 15:20:45 -0600 To: support@drupal.org Subject: Re: [support] Searching custom MySQL Tables
And you can't use CCK & Views w/ exposed filter?
Ryan LeTulle,* Web Developer
personal: bayousoft.com http://www.bayousoft.com twitter: @bayousoft http://twitter.com/bayousoft
http://twitter.com/bayousoft*"Be the change you want to see in the world."* Mahatma Gandhi
On Wed, Jan 19, 2011 at 3:14 PM, Ayath ULLAH ayath@hotmail.co.uk wrote:
Hi,
Does anyone have any suggestions as to how I can let users query a two column table.
Basically what I'd like to do is: Allow users to search fusing or a specific string stored in Column A and the search should show up all the matches from column B.
For example: Lets say I have a table with colun names 'school_ID' and 'phone_number'. I'd like users to be able to find the phone_number using the school_ID. The text they enter should match the data in the table EXACTLY or an error message is shown.
Are there any modules to help me to this? Or can I customise something already out there?
Kind regards, Ayath
-- [ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
-
Ayath ULLAH -
Ryan LeTulle