<div>Hi All</div>
<div>I just used below code to show the required result.</div>
<div> </div>
<div>function resume_search_skill_based_search()<br>{<br> $header = array('Name', 'Email', 'Phone', 'Experience(Years)');<br> $data = array();<br> $query = db_query("SELECT name, email, phone, yrsofexp FROM {resubmt_table}");<br>
while ($row = db_fetch_array($query)) $data[] = $row;<br> $output = theme('table', $header, $data);<br> return $output;<br>}</div>
<div><br>Though this query is simple I can replace with actual query. </div>
<div>With this probably I will not use view.</div>
<div> </div>
<div>Now, I want to make one coulmn in table should be a link, for example name field should be a link , on clicking it I should be able to prepare the data on fly and show it user. Is it really possible? If so, please give me some hink.</div>
<div> </div>
<div>Regards,</div>
<div>Austin</div>
<div> </div>
<div><br> </div>
<div class="gmail_quote">On Sat, Apr 9, 2011 at 11:34 AM, Austin Einter <span dir="ltr"><<a href="mailto:austin.einter@gmail.com">austin.einter@gmail.com</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">
<div>Thanks Nancy.</div>
<div> </div>
<div>I am very much confused what to do at this stage. My requirements are - </div>
<div> </div>
<div>1. There will be a small search form, where user need to put the data (on that "data" basis search should be done).</div>
<div> </div>
<div>2. There will be a search button in the form, on pressing search button the form data should be taken as input, a SQL query should be exucted, and records returned from SQL query should be shown in a tabular formt. Here the SQL query may involve 3/4 tables with JOIN and WHERE operations.</div>
<div> </div>
<div>3. One coulmn in table (say name field) should be clickable. On clicking that field details about the user should be shown.</div>
<div> </div>
<div>This is what my precise requirement. </div>
<div> </div>
<div>Can somebody suggest, is it possible to acheive abobe thing using VIEW module or it will be better to have a custom module?</div>
<div> </div>
<div>Please bear with me these questions, if I asking bit silly questions.</div>
<div> </div>
<div>Best Regards</div>
<div>Austin</div>
<div> </div>
<div> </div>
<div> </div>
<div> </div>
<div> </div>
<div> </div>
<div> </div>
<div><br><br> </div>
<div class="gmail_quote">
<div>
<div></div>
<div class="h5">On Sat, Apr 9, 2011 at 8:12 AM, nan wich <span dir="ltr"><<a href="mailto:nan_wich@bellsouth.net" target="_blank">nan_wich@bellsouth.net</a>></span> wrote:<br></div></div>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">
<div>
<div></div>
<div class="h5">
<div>
<div style="FONT-FAMILY: arial, helvetica, sans-serif; FONT-SIZE: 12pt">
<div></div>
<div>Assuming that "res_table" is the primary table you created for the view, then "skilltable" would be a Relationship that you would define in that section of the view.</div>
<div> </div>
<div>All the fields in the WHERE clause are "filters," which you would "expose" to the user. <br> </div>
<p><font color="#ff007f" size="4" face="bookman old style, new york, times, serif"><em><strong>Nancy</strong></em></font></p>
<p> </p>
<p><font face="arial, helvetica, sans-serif">Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.</font></p>
<div><br></div>
<div style="FONT-FAMILY: arial, helvetica, sans-serif; FONT-SIZE: 12pt"><br>
<div style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt"><font size="2" face="Tahoma">
<hr size="1">
<b><span style="FONT-WEIGHT: bold">From:</span></b> Austin Einter <<a href="mailto:austin.einter@gmail.com" target="_blank">austin.einter@gmail.com</a>><br><b><span style="FONT-WEIGHT: bold">To:</span></b> <a href="mailto:support@drupal.org" target="_blank">support@drupal.org</a>; <a href="mailto:development@drupal.org" target="_blank">development@drupal.org</a><br>
<b><span style="FONT-WEIGHT: bold">Sent:</span></b> Fri, April 8, 2011 10:27:32 PM<br><b><span style="FONT-WEIGHT: bold">Subject:</span></b> [support] Doubts on VIEWS & DATA module - please help me<br></font>
<div>
<div></div>
<div><br>
<div>Hi All</div>
<div>I have around 5 different tables containing employee records (Name, skill set , current company, years of experience etc).</div>
<div>I am trying to show the employee records for different kind of search. </div>
<div> </div>
<div>One seacrh may be, show all the employees having knowledge on PHP and must have 5+ years of experience.</div>
<div>I know, I need to a database query and show it in a view (either a page or block display).</div>
<div> </div>
<div>I know how to collect the records. The query will be something like this.</div>
<div> </div>
<div>SELECT <a href="http://res_table.name/" rel="nofollow" target="_blank">res_table.name</a>, res_table.yrsexp, res_table.emailid<br> FROM res_table<br> WHERE (res_table.yrsexp >= 5 AND skilltable.userid = $user->userid AND skilltable.skill = 'PHP') <br>
</div>
<div>Or even in some cases I need to go for JOIN.</div>
<div> </div>
<div>Somebody suggested to use Data module for it. I gave a try, I am just seeing tables (in view creation), not sure how do I impose the custom SQL query.</div>
<div>Is it really possible to impose above kind of sql query using Data module???</div>
<div> </div>
<div>Or is it the best way to go for custom module and implement _alter_view or _pre_exute_view hooks.</div>
<div> </div>
<div>Regards</div>
<div>Austin</div>
<div> </div>
<div> </div>
<div> </div></div></div></div></div></div></div><br></div></div>--<br>[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br></blockquote></div><br></blockquote></div>
<br>