sort table by dropbox entry

Ads
 

sort table by dropbox entry

Hi All, I current have the following code, apologies for the length. I am able to retrieve all the information i require but am looking to include some filter boxes. I have managed to add the filter drop down to the table BUT and am unable to get this to do anything. The dropdown pulls its data from another dedicated table(works) but I need an OnCHANGE event to filter the data where the Country equals the selected record in the dropdown?? (#95 are underscores in the code below) I can manually add the following into the $sql= ... AND Country='BE' and it will find all records for that country.. can this be done dynamically or with a page reload??? Any help gratefully received:

<?php
require './connections/db_connect.php';

$db_name="Projects_Main"; // Database name 
$tbl_name="Main"; // Table name

// Connect to server and select database.
mysql_connect($host, $usrname, $pssword)or die("Connection failed"); 
mysql_select_db($db_name)or die("Connection failed");
$sql=("SELECT * FROM $tbl_name WHERE Status not like 'CLOSED'");
$result=mysql_query($sql);

$num_rows = mysql_num_rows($result);
$fields_num = mysql_num_fields($result);

?>
<table>

<!-- create the table headers and using the next section build the table. sections not shown as page space not sufficent -->
<tr>
    <th>Project ID</th>
    <th>Financial Year</th>
    <th>Country</th>
    <th>More Details</th>
    <th>UPDATE</th>
</tr>
<!--START:filter    NOT WORKING-->
<tr>
    <th></th>
    <th></th>
    <th></th>
    <th></th>
    <th>
        <?php
            $db_name = 'Projects_Main';
            $ctrytable = 'Country';
                if (!mysql_connect($host, $usrname, $pssword))
                       die("Can't connect to database 'cos somethin' is wrong");
                if (!mysql_select_db($db_name))
                     die("Can't select database");
            $result1 = mysql_query("SELECT country_abbrev, country_name FROM {$ctrytable} order by country_name");
            $options="";
        while ($row=mysql_fetch_array($result1)) 
                {
                    $id=$row["country_abbrev"];
                    $thing=$row["country_name"];
                    $options.="<OPTION VALUE=\"$id\">".$id."</option>\n";
                }
        ?>
            <SELECT NAME="Country" type="text" onchange="filterTable(this.options[this.selectedIndex].value);">
                <OPTION VALUE=\"\">ALL
                                        <? echo $options?>
            </SELECT>
    </th>

    <th></th>
    <th></th>
    <th></th>
    <th></th>
    <th></th>
    <th></th>
    <th></th>
    <th></th>
    <th></th>
    <th></th>
    <th></th>
    <th></th>
    <th></th>
    <th></th>
    <th></th>
    <th></th>
    <th></th>
</tr>
<!--END:  filter -->

    <?php

    while($rows=mysql_fetch_array($result))
    {


    ?>
<!-- echo the contents of database table -->
<tr>
    <td align="center"><?php echo $rows['Project_id']; ?></td>
    <td><?php echo $rows['FinancialYear']; ?></td>
    <td><?php echo $rows['Country']; ?></td> 
    <!-- link to show more info on the record or update record.. -->
    <td><a href="./projects_more.php?Project_id=<?php echo $rows['Project_id']; ?>">more...</a></td>
    <td><a href="./projects_update.php?Project_id=<?php echo $rows['Project_id']; ?>">update</a></td>
</tr>
    <?php
    }
    ?>
</table>

<?php
mysql_close();
?>
View Answers

Ads









Related Tutorials/Questions & Answers:
sort table by dropbox entry
sort table by dropbox entry  Hi All, I current have the following... drop down to the table BUT and am unable to get this to do anything. The dropdown pulls its data from another dedicated table(works) but I need an OnCHANGE
JavaScript sort table
JavaScript sort table..., we are going to sort the table using the JavaScript. To sort the table, we... created a for loop which iterates through the rows of the table in the function
Advertisements
How to add dropdown list in a row of a sort table applet?
How to add dropdown list in a row of a sort table applet?  How to add dropdown list in a row of a sort table applet
Mysql Date Sort
; Mysql Date Sort is used to return the sort  records or rows value in table... Sort. To understand this example, we create a table 'employee1' with field name...) Query to sort data from the table according to Empname created
Sort
all the votes have been counted, the program should output a table showing how
ModuleNotFoundError: No module named 'dropbox'
ModuleNotFoundError: No module named 'dropbox'  Hi, My Python... 'dropbox' How to remove the ModuleNotFoundError: No module named 'dropbox... to install padas library. You can install dropbox python with following command
table
table  multiplicatyion table
Order Entry System
Order Entry System  Create a new order entry system using netbeans and microsoft access.can anyone help me
ModuleNotFoundError: No module named 'entry'
ModuleNotFoundError: No module named 'entry'  Hi, My Python program is throwing following error: ModuleNotFoundError: No module named 'entry' How to remove the ModuleNotFoundError: No module named 'entry'
Extjs Table Sorting
Extjs Table Sorting  how is it possible to do the table sort in extjs
Extjs Table Sorting
Extjs Table Sorting  how is it possible to do the table sort in extjs
Help With Costructing Selection sort?
Help With Costructing Selection sort?  Using a selection sort, for each entry in the array, display the original index of the first dimension... in advance!   Please visit the following link: Java Selection Sort
Table
Table  How i generate table in showMessageDialog. I want that i creat a table and run in showMessageDialogeprint("cprint("code sample");ode sample
bubble sort
bubble sort  write a program in java using bubble sort
insertion sort
insertion sort  write a program in java using insertion sort
insertion sort
insertion sort  write a program in java using insertion sort
insertion sort
insertion sort  write a program in java using insertion sort
insertion sort
insertion sort  write a program in java using insertion sort
insertion sort
insertion sort  how many arrays needed for insertion sort and why
bubble sort
bubble sort  how to calculate the number of passes in bubble sort
Table
Table  How I generate table in showMessageDialog. E.g 3X1=3 3X2=6 3X3=9print("code sample
Table
Table  How i generate table in showMessageDialog. I want to creat a table and run in showMessageDialoge. Pl make a table programe which run..., JOptionpane, Integer.parseInt. Please use only these above methods to make table
Version of com.fathzer>jclop-dropbox dependency
List of Version of com.fathzer>jclop-dropbox dependency
Table
Table  How i generate table in JOptionpane.showMessageDialog... advance coding but i want u make the table using JOptionpane.showMessageDialog, import.javax.swing int Integer.parseInt(). Thats my limit. Pl generata a table
table
input from oracle table(my database table..) This is a very important table of my
table
table  Hi..I have a list of links which links to a table in the same page.If I click first link the table is displayed at the top, likewise if i click the last link the table is displayed at the last,i dont know how to set
Edit cron entry
Edit cron entry   Hi, What is the command to Edit cron entry in linux? Regards Deepak Kumar   Hi, You can use the following command to open cron configuration in vi editor: crontab -e After editing just save
JDBC: Sorting Table Example
JDBC: Sorting Table Example In this section, you will learn how to sort your table records under any column using JDBC API. ORDER BY Clause : You can sort your table record either in ascending order or in descending order
ModuleNotFoundError: No module named 'dropbox-index'
ModuleNotFoundError: No module named 'dropbox-index'  Hi, My... 'dropbox-index' How to remove the ModuleNotFoundError: No module named 'dropbox-index' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'dropbox_tools'
ModuleNotFoundError: No module named 'dropbox_tools'  Hi, My... 'dropbox_tools' How to remove the ModuleNotFoundError: No module named 'dropbox_tools' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'dropbox_backup'
ModuleNotFoundError: No module named 'dropbox_backup'  Hi, My... named 'dropbox_backup' How to remove the ModuleNotFoundError: No module named 'dropbox_backup' error? Thanks   Hi, In your python

Ads