Dropdown filter need for this table

Hi,


How to have the Dropdown filter for the filter.My table Coding is

<?php
print "<br></br>";
print "<br></br>";
print "<br></br>";
print "<br></br>";
print "<h3> Projects in Progress </h3>";

$result = mysql_query( "SELECT p.Project_Name,p.Activity_Name,v.Village, v.Mandal, v.District, v.State,p.Estimated_Cost_Rs,p.Funds_Mobilized_Dollar,DATE_FORMAT(p.Expected_Start_Date,'%m-%d-%Y'), DATE_FORMAT(p.Expected_Complete_Date,'%m-%d-%Y')   FROM Project as p 
JOIN Project_Location as v ON v.fabrik_internal_id = p.Village WHERE p.Status_Id ='In Progress'" ) 

or die("SELECT Error: ".mysql_error());
$num_rows = mysql_num_rows($result);
print "There are $num_rows records.<P>";
print "<table width=950 border=1>\n";
print "<th>Project Name</th>";
print "<th>Activity Name</th>";
print "<th>Village</th>";
print "<th>Mandal</th>";
print "<th>District</th>";
print "<th>State</th>";
print "<th>Estimated Cost</th>";
print "<th>Funds Mobilized</th>";
//print "<th>Still Funds Required</th>";
print "<th>Start Date</th>";
print "<th>Estimated Completion Date</th>";
while ($get_info = mysql_fetch_row($result))
{

print "<tr>\n";
foreach ($get_info as $field)

print "\t <td><font face=arial size=1/>$field</font></td> \n ";



print "</tr>\n";

}
print "</table>\n";
?>

I want to filter my table according to the "Project Year" Dropdown.

Eg. If I select "2009" the selected year projects should be displayed.


Regards,
Shoaib
🙂

Hi Shoaib,

If you select 2009 where??? There is nothing in this code to select a year?

This is probably better done in ChronoConnectivity.

Bob

Hi Bob,

I have no idea about the Chronoform connectivity. Can you explain me in steps or any document on how to use chronoform connectivity for table filter.


Regards,
Osmodels.
🙂

Hi Osmodels,

There is a (very) long thread with a worked example from BenBLee in the ChronoConnectivity forum here.

Bob

Hi Bob,

Is there any possibility to do this in the chronoform. I cheked the CC but I unable to join 2 tables there. I checked it here by applying submit button. but i get only blank page.

the url of the page --/index.php?option=com_chronocontact&chronoformname=supportastudent

when i click the submit button it navigates to
index.php?option=com_chronocontact&task=send&chronoformname=supportastudent

Regards,
Osmodels.