<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style>
</head>
<body class='hmmessage'>
Hi ,<br><br>I'm quite new to Drupal any chance you can walk me thorugh the method suggested below.<br>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.<br><br>Kind regards,<br>Ayath <br><br><br><br><br><hr id="stopSpelling">From: bayousoft@gmail.com<br>Date: Wed, 19 Jan 2011 15:20:45 -0600<br>To: support@drupal.org<br>Subject: Re: [support] Searching custom MySQL Tables<br><br>And you can't use CCK & Views w/ exposed filter?<br clear="all"><b><div><b><br></b></div>Ryan LeTulle,</b> Web Developer<br><br><div>personal: <a href="http://www.bayousoft.com" target="_blank"><font class="ecxApple-style-span" color="#666666">bayousoft.com</font></a><br>
twitter: <a href="http://twitter.com/bayousoft" target="_blank"><font class="ecxApple-style-span" color="#666666">@bayousoft</font></a></div><div><br></div><div><a href="http://twitter.com/bayousoft" target="_blank"></a><div>
<br></div><div><a href="http://twitter.com/bayousoft" target="_blank"></a><i>"Be the change you want to see in the world."</i> Mahatma Gandhi</div><br><br></div><br>
<br><br><div class="ecxgmail_quote">On Wed, Jan 19, 2011 at 3:14 PM, Ayath ULLAH <span dir="ltr"><<a href="mailto:ayath@hotmail.co.uk">ayath@hotmail.co.uk</a>></span> wrote:<br><blockquote class="ecxgmail_quote" style="border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div>
Hi,<br><br>Does anyone have any suggestions as to how I can let users query a two column table.<br><br>Basically what I'd like to do is:<br>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.<br>
<br>For example: Lets say I have a table with colun names 'school_ID' and 'phone_number'.<br>I'd like users to be able to find the phone_number using the school_ID.<br>The text they enter should match the data in the table EXACTLY or an error message is shown.<br>
<br>Are there any modules to help me to this?<br>Or can I customise something already out there?<br><br><br>Kind regards,<br>Ayath <br><br><br> </div>
<br>--<br>
[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br></blockquote></div><br>
<br>--
[ Drupal support list | http://lists.drupal.org/ ] </body>
</html>